NAV: SLTechnology News&Howtos > Database >

• 

  Operation and maintenance staff think about it. Do you know the relationship between CMDB and monitoring?

  With the development of business and the continuous introduction of new IT technology, the scale of IT resources of application systems is getting larger and larger, and the complexity of IT architecture is also increasing. In this case, we need to use a variety of monitoring systems, different ways to perceive whether the business system is alive, whether it is good or not, and how the user experience is. Often

  2022-06-01 08:58:58 Views: 223
• 

  MariaDB stop slave usage

  1. Environment description MariaDB 10.1.35CentOS 6.82, stop slave command root@MariaDB0 07:55: [(none)] > help stopERROR 2006 (HY

  2022-06-01 08:58:57 Views: 290
• 

  Centos6.6 installs oracle11g R2

  Suddenly want to build an oracle environment under linux. I found some materials on the Internet and drew lessons from the materials shared by several friends. I will record the installation steps and share them here for your reference. The NAT mode set by the virtual machine. The specific setting method can be found on the network. I use w

  2022-06-01 08:58:57 Views: 244
• 

  Hadoop+hbase+zookeeper+spark+p

  Troubleshooting log: solution: it may be caused by changing the machine name, modify hosts, write hostname and IP, and then, try it agin! Solution: when introducing hadoop-common-2.2.0.jar package for secondary development, it is better than

  2022-06-01 08:58:54 Views: 272
• 

  Laravel database connection problem

  1. Modify the configuration file / .nevDB_HOST=127.0.0.1 / / database address DB_PORT=3306 / / database port DB_DATABASE=database / / database name

  2022-06-01 08:58:51 Views: 248
• 

  Change votingdisk and OCR to other asm disk groups

  1. Check out ocr and Votedisk [oracle: / home/oracle:RACTEST1] ocrcheckStatus of Oracle Cluster Registry is as follo

  2022-06-01 08:58:50 Views: 246
• 

  [INS-20802] failed to start the basic grid

  Share a bug, oracle 11.2.0.4 RAC for window 2012 R2 installation GI is an error basic grid startup failure. Solution: [INS-20802] Grid Infrastructur

  2022-06-01 08:58:47 Views: 250
• 

  The solution of Oracle forgetting username and password

  Solution for Oracle forgetting username and password: sometimes, the oracle database password is forgotten, and you can't even try all the commonly used passwords, so you can read on. Log in directly through the operating system authentication, change the user's password and type in cmd or bash

  2022-06-01 08:58:47 Views: 232
• 

  MySQL Flip-flop of 8Python full Stack path Series

  If you want to trigger a specific behavior before and after adding / deleting / changing a table, the MySQL trigger l of the Python full stack series can be used to customize the behavior of the user before and after adding / deleting / changing the rows of the table. Create trigger basic syntax before inserting C

  2022-06-01 08:58:41 Views: 231
• 

  The latest open source DBLayer, database operation can also be very simple

  DBLayer, my recently open source database lightweight orm framework, currently supports sqlserver, mysql, oracle, especially paged encapsulation. This framework has been gradually upgraded since seven or eight years ago, and has experienced a lot of projects. I hope we can change everyone from s.

  2022-06-01 08:58:41 Views: 241
• 

  The whole process of uninstalling, installing and testing mysql under CentOS

  Mysql uninstall yum remove mysql mysql-server mysql-libs compat-mysql51rm-rf / var/lib/mysqlrm / etc/my.cnf View is

  2022-06-01 08:58:41 Views: 252
• 

  Two storage engines of MySQL

  MyISAM and InnoDB explain that InnoDB and MyISAM are the two most commonly used table types for many people when using MySQL. These two table types have their own advantages and disadvantages, depending on the specific application. The basic difference is that the MyISAM type does not support advanced processing such as transaction processing

  2022-06-01 08:58:40 Views: 249
• 

  Report Illegal mix of collations in mysql stored procedure

  I wrote a stored procedure with a cursor in it, and then iterated through the cursor. According to the result of the traversal, I update the value of another table, which is a general situation. The problem is to report Illegal mix of collations (utf8) in update.

  2022-06-01 08:58:40 Views: 297
• 

  Oracle looks at locked tables and unlocks

  -- the following are related tables SELECT * FROM lockout select * FROM vastsqlareash select * FROM vault session select * select

  2022-06-01 08:58:40 Views: 261
• 

  The Oracle database views client's user login information, including ip

  Log the login of the user by creating the trigger, audit the login user, record the login user, host, system user and IP address: 1. Create a table in sys mode to record the details of the client logging in to the database server. Create tabl

  2022-06-01 08:58:40 Views: 221
• 

  An oplog damage accident

  Question 1) Program alarm Execution TimeoutCouldn't get a connection within the time limit2) mongod log Jun 11 21:48:35 mo

  2022-06-01 08:58:37 Views: 208
• 

  Oracle database encryption script

  -permission setting grant execute on DBMS_CRYPTO to username;- encryption create or replace function encrypt256 (v _

  2022-06-01 08:58:36 Views: 261
• 

  Char (n) of the database

  Char (n) or varchar (n) in Mysql where n represents a column, not bytes! varchar (n) where n is at most 65535, you should specify that the table is encoded as latin1 at the same time you create the table, because lati

  2022-06-01 08:58:26 Views: 266
• 

  The query parameter of the oracle 11g expdp tool is used

  When conducting data in actual production, you may need to import part of the data to the test library, and the query parameters of expdp can meet this requirement. Database version zx@ORCL > select * from version of BANNER-

  2022-06-01 08:58:25 Views: 227
• 

  Pt-archiver

  Pt-archiver is a tool in pt-toolkit for archiving, transferring data to offline databases, or other database ExamplesArchive all rows from oltp_server to

  2022-06-01 08:58:25 Views: 296