NAV: SLTechnology News&Howtos > Database >

• 

  Introduction to persistence of Redis

  First, the role of persistence 1. What is persistent redis all the data is stored in memory, updates to the data will be asynchronously saved to the hard disk 2. Snapshot of persistence: a completed backup of data at a certain time-Dump of mysql-RDB write date of redis

  2022-06-01 18:09:10 Views: 295
• 

  How to use queue to realize History search function in redis

  1. Use the phpinfo () function to check your configuration and match the corresponding redis extension version (Note: the following case is carried out under window system). 2. Download redis extension redis extension download address: https://windows.php.

  2022-06-01 18:08:55 Views: 227
• 

  SQL Server transaction log analysis

  The SQL Server transaction log analysis fn_dblog () and fn_dump_dblog () functions introduce that SQL Server has two unexposed functions, fn_dblog () and fn_dump_dblog (), which are very useful and provided

  2022-06-01 18:08:40 Views: 243
• 

  12c RAC expands undo tablespace

  Oracle 12cR1 RACcol sid for a10col name for a20col value for a20select sid,name,value from v$spparam

  2022-06-01 18:08:40 Views: 289
• 

  1z0-062database OCP item bank 2

  Examine the parameters for a database instance:NAME TYPE VALUEtemp_undo_enabled boolean TRUEundo_man

  2022-06-01 18:08:40 Views: 296
• 

  In-depth analysis of the internal initialization of Oracle startup process

  1 Oracle startup option; when the Oracle database is started by startup, Oracle will look for the initialization parameter file in the default location $ORACLE_HOME/dbs; Oracle looks for the appropriate initialization file in the following order: s

  2022-06-01 18:08:38 Views: 281
• 

  What if redis-cli connects to redis Cluster Times wrong?

  An error was reported when using redis-cli to connect to the redis cluster and perform data operations. / redis-cli-h 192.24.54.1-p 6379-a '123456 > 192.24.54.1

  2022-06-01 18:08:37 Views: 253
• 

  Authority Management of MySQL Database

  Mysql permission system is very important, but at the same time, it is ignored by many developers or managers. The allocation of rights will not only lead to irreparable tragic consequences. I used to work in a company that pays no attention to database permissions, and all developers have the highest permissions on the system. Want to

  2022-06-01 18:08:37 Views: 207
• 

  What is the purpose of Mysql stored procedures? How do I use stored procedures?

  Mysql has supported stored procedures since 5.0. generally speaking, stored procedures are encapsulated SQL, but not only SQL, but also variables, condition judgments, loop bodies, cursors and so on. The role of stored procedures in many scenarios, the need to process the data of multiple tables

  2022-06-01 18:08:37 Views: 214
• 

  Introduction and use of Mysql process Control statement

  Mysql flow control statements may not be used most of the time, but they will be used if we need to write stored procedures. With flow control statements, mysql can write programs like other programming languages. The conditional bifurcation and the loop body are introduced below. Conditional branching my

  2022-06-01 18:08:37 Views: 265
• 

  Analysis on the slow query of MySQL Statistical Information

  The reason is that after running mysqld_exporter on the MySQL server, it is found that the number of active connections in the database has skyrocketed, and they are all slow queries from mysqld_exporter, with the following sentence: SELECT TABLE

  2022-06-01 18:08:36 Views: 297
• 

  What are the integrity of the database?

  What is database integrity? database integrity ensures that the data entered into the database is accurate, valid, and consistent. Any data changes in the database must comply with all integrity restrictions and data validity tests. 1. Entity integrity is the uniqueness of the record in the relationship, that is, the master.

  2022-06-01 18:08:36 Views: 259
• 

  Oracle 10g snooping hang processing

  Environment description Oracle 10.2.0.4windows 20082. Problem description according to the description of the field engineer, the customer restarted the PC server, after getting up, the monitoring was slow and slow, and the database status OPEN could not log in 3. It is useless to try to reconstruct the surveillance at the scene.

  2022-06-01 18:08:36 Views: 208
• 

  Oracle Learning-- the shoulder of Giants

  Include the website of the masters for learning: nameurlOracle DBA-Tips and Techniques http://gavinsoorma.com/Documentation Libraryhttp

  2022-06-01 18:08:36 Views: 220
• 

  The whole process of mysql highly available MHA deployment

  Deployment Plan mysql_master192.168.2.74centos6.9mysql5.5/mha-nodemysql_salve1192.168.2.75centos6.9mysql5.5/mha-

  2022-06-01 18:08:35 Views: 234
• 

  Use memorycache as the session shared configuration

  # cp / application/php/lib/php.ini {, .bak} back up php.ini files first web cluster session shared storage settings: type and configuration path of session in default php.ini: # s

  2022-06-01 18:08:35 Views: 215
• 

  MySQL backup

  MySQL backup 1. MySQL backup process: MyISAM complete: a. Lock table-- LOCK TABLE-lock-all-tablesb. Synchronization table-FLUSH TABLESc. Refresh the binary log

  2022-06-01 18:08:35 Views: 285
• 

  Mariadb's log

  Mariadb log classification: query log: query log slow query log: slow query log query operation time exceeds the specified time error log: error log also contains startup and shutdown service

  2022-06-01 18:08:28 Views: 288
• 

  Mariadb cluster master and slave

  1. On the master node / etc/my.cnfservice-id=1, authorize the backup user's authority grant replication slave on *. * to backup@'%' iden in the main library mysql

  2022-06-01 18:08:28 Views: 249
• 

  How oracle displays currently executed users and action examples

  Today, I attended the OCP training and listened to the teacher talk about a little skill about oracle. I felt it was still very useful and wrote it down. If you are interested in this document on the official website, you can also check it out. The document on the official website is accurate to time. Use sqlplu in our daily work

  2022-06-01 18:08:28 Views: 238