NAV: SLTechnology News&Howtos > Database >

• 

  Paged query, secondary condition

  Paging query: paging query is unique to MySQL, generally there is no other database. A paging query can fetch a range of rows from a table, such as 0 to 50 rows of data and 30 to 100 rows of data. The key word of the paging query is LIMIT, written at the end of the query statement. SEL

  2022-06-01 13:45:52 Views: 284
• 

  A simple way to make High CPU Utilization

  Today, someone in the group asked to create scenarios with high CPU occupancy for testing. As the saying goes, it is difficult to do good things, but it is not easy to do "bad" things. There are many ways to achieve this requirement, such as using some stress testing tools. The first thing that comes to mind is HASH JOIN. This connection consumes more CPU resources

  2022-06-01 13:45:46 Views: 270
• 

  Test cases for functional testing

  First of all, functional automation testing TestBird helps to improve the efficiency of functional testing. 1. Login, add, delete, query modules are often encountered, how to consider the test points of these modules 1) login ① user name and password meet the requirements (format requirements) ② user name and password

  2022-06-01 13:45:45 Views: 231
• 

  How to force a log switch- forcibly switches logs

  Log switching is usually performed automatically by the system without human intervention. However, in some cases, you need to force log switching, here are a few ways. 1. Modify the system parameter The following initialization parameter setti

  2022-06-01 13:45:45 Views: 227
• 

  First acquaintance of MariaDB's 9--keepalive+GTID dual-host implementation of high availability

  Background introduction: under the traditional master-slave replication architecture, although semi-synchronous method can be used for read-write separation, the master node still has a single hidden danger. In the case of small scale, the keepalive+ dual-master mode can be used to protect the master node with high availability, and the client can access it through VIP.

  2022-06-01 13:45:44 Views: 227
• 

  Mysql stored procedure executes exception, parameter is not output parameter

  The following error occurs when executing the stored procedure. Generally, the .Parameter number 1 is not an OUT parameter checks the user's corresponding permission show grants fo because the calling user does not have the corresponding operation permission.

  2022-06-01 13:45:44 Views: 278
• 

  RDB snapshot of Redis persistence

  What is RDB? 1.Redis data is stored in memory, and a rdb binary file can be created on the hard disk through save or bgsave. This rdb file is equivalent to a snapshot of redis's data. When 2.Redis is rebooted, the rdb file in the hard disk will be transferred

  2022-06-01 13:45:35 Views: 249
• 

  Mysql query, left join (union), where (intersection)

  Prepare (two tables, T1 and T2): table t1:mysql > select * from T1 + | t1_id | t1_name | +-+-+ |

  2022-06-01 13:45:34 Views: 284
• 

  Delete private dblink under oracle sys

  1. Create or replace procedure Drop_DbLink (schemaName varchar2, dbLink varchar2) isplsql varchar2 (1

  2022-06-01 13:45:34 Views: 207
• 

  Interpretation and Summary of XtraBackup complete Workflow

  Background out of curiosity about how XtraBackup works, I did the following log interpretation backup output log interpretation [root@node1 09:23:35 / root] # time innobackupex-- defaults-file

  2022-06-01 13:45:34 Views: 298
• 

  Enhance business value APM application and integration and sharing

  Hangzhou Digital Cloud Luo Xingfeng Hangzhou Digital Information Technology Co., Ltd., founded in 2011, is China's leading provider of digital marketing software products and services. over the years, it has been committed to providing consumer brands and retail brands with one-stop digital marketing solutions that integrate software products, data models and professional services.

  2022-06-01 13:45:22 Views: 269
• 

  Lsof handles the problem of inconsistent size of df and du

  The root of the APP server is full. The constant alarm df shows that the root partition has used 90% of the space, but the total of the du root partition is only about 40G. The partition should not have a large number of small files, so it should not cause the block full problem caused by a large number of small files. I searched the Internet and found that it was possible.

  2022-06-01 13:45:21 Views: 251
• 

  Postgresql dynamic cursor use case

  CREATE or REPLACE FUNCTION insert_p_date () RETURNS text as ```$$DECLAREsql_string text;sdate timesta

  2022-06-01 13:45:21 Views: 259
• 

  Introduction to innotop usage

  Innotop is a real-time monitoring tool for mysql database, which has powerful functions and a wide variety of information, which can reflect the state of the database. It's actually a perl script that integrates show status/show variables/show eng.

  2022-06-01 13:45:09 Views: 269
• 

  Mysql 5.7innodb memcached plugin supports main memory database

  Http://dev.mysql.com/doc/refman/5.7/en/innodb-memcached.html 1, test environment mysql:5.7.15centos:6.6_x86_ 642, installation department

  2022-06-01 13:45:09 Views: 289
• 

  Solve the problem of flicker and garbled code when Navicat starts SQLPLUS

  1. Download instantclient-basic-windows.x64-12.2.0.1.0 and instantclient-sqlplus-windows.x64-12.2.0.1.0 to solve the flashback problem.

  2022-06-01 13:45:09 Views: 279
• 

  SQL Server database log shipping disaster recovery (Part2)

  3. Configuration steps: master server (A machine) settings (1) enable Log Shipping Configuration right-click the database to configure log transfer-> Tasks- > Ship Transaction Logs...-

  2022-06-01 13:44:55 Views: 282
• 

  An example of Oracle 10.2.0.5 RMAN Migration and upgrade 11.2.0.4

  1. Environmental introduction 1. Source database environment operating system version: OEL 5.4x64 database version: 10.2.0.5x64 database sid name: orclOracle 10g 10.2.0.5 (64bit) installation directory is as follows

  2022-06-01 13:44:54 Views: 278
• 

  10 sentences for getting started with Mysql

  1. Check what libraries (database) are under the current server? Answer: show databases;2. How do I create a database? Answer: the database name is written at the end of create database; the semicolon ends with 3. Select the database in progress

  2022-06-01 13:44:54 Views: 285
• 

  Modify oracle redo log file size

  Create 3 new log groups SQL > ALTER DATABASE ADD LOGFILE GROUP 4 ('/ u01 SIZE SIZE)

  2022-06-01 13:44:54 Views: 244