Database Administrator

New Features of MySQL5.6-Batched Key Access 1. Introduction MySQL 5.6 provides many performance optimization features, one of which is about the Batched Key Access (BKA) algorithm to improve the performance of table join. This article will combine

Check whether the data table exists during Oracle During the process, especially for daily tasks, check that the queried data table does not exist. If the data table does not exist, wait for a while. The following code implements this function, if

Undo tablespace repair Summary First, you must know that the rollback segment cannot be offline or deleted under the automatic management of undo tablespace. You can change it to manual before performing the operation, we know that the undo

Mysql Data Type summary, mysql Data TypeData Type optimization1. Try to use the minimum data type that can normally store data (faster, less occupied disk, memory, and cpu). 2. Try to use a simple data type. (For example, the integer type is lower

Galera 10.0.20 on CentOS 6.6, galeracentos Galera 10.0.20 on CentOS 6.6 0. Use Cases Database software: mariadb-galera-10.0.20-linux-x86_64.tar.gzCluster Management: galera-3-25.3.10Node synchronization mode (xtrabackup, rsync): percona-xtrabackup-2

MySQL (22) ------------ table structure optimization, mysql ------------ ManyDatabase design paradigmAs a database table structure design "Bible", the author believes that as long as the design is based on this paradigm requirement, the designed

Install the MEAN development framework and mean development frameworkInstall MEAN development framework The MEAN development framework is a package of solutions designed to streamline the development process and improve development efficiency.

Use force index to optimize SQL statement performance, forcesql Today, I wrote a statistical SQL statement, which is executed on a table with nearly million pieces of data. No results can be found within S. The SQL statement is as follows:

Install phpmyadmin4.10 and phpmyadmin4.4.8 1 .: Phpmyadmin4.10 Https://files.phpmyadmin.net/phpMyAdmin/4.4.10/phpMyAdmin-4.4.10-all-languages.zip Apache 2.4.12 (VC9) Http://www.apachehaus.com/cgi-bin/download.plx Php-5.4.42

Jedis is simple to use and jedis Currently, only the standalone version of jedis is used. The cluster is successfully built, but the Interface Test is faulty. 1. Connect to the jedis Service public class RedisUtil {private static String

Install mongodb2.6 and centosmongodb2.6 on centos 6.5 Preface: System Version: Centos-6.5-x86_64 * ** It is best to compile and install the mongodb 2.6 System Using Centos 64-bit to better utilize the performance of mongodb. 1. Prepare and download

Migrate mysql Data from Windows to Linux. 1. First, set data on windowsExportOne file. (Take a database as an example) Export the entire database mysqldump-u user name-p Password Database Name> export the exported file name export the specified

Error code: 1045 Access denied for user 'skyusers' @ '%' (using password: YES), deniedskyusers1. Error description Grant all privileges on *. * TO root @ "%" identified ". "; 1 queries executed, 0 success, 1 errors, 0 warnings query: grant all

Vertical table sharding and SqlServer vertical When there is too much data in a single table, we can divide the table horizontally. For more information, see SqlServer partition view to achieve horizontal table sharding, which can improve the table

Impdp reports error ORA-39083 & ORA-01917, impdp times ora-39083Impdp reports error ORA-39083 & ORA-01917ORA-39083: Object Type OBJECT_GRANT creation failed with error:ORA-01917: the user or role 'hq _ 88 'does not existFailed SQL:Grant alter,

SQL calls WebService interface, SQL calls webservice Today, I am doing a wonderful job. There is a process in the middle that calls the webservice Interface in the SQL trigger. Haha ~ -- Call webService ---------------- declare @ ServiceUrl as

Mysql Development --- split the table into a post table and a reply table using two-layer nested cursors. mysql cursors Note: (1) The table names of the tables to be split are different. Therefore, create a temporary table and insert the data in the

Mydumper installation and installation fault summary and mydumper fault Summary Mydumper is a lightweight third-party open-source tool for mysql database backup. The backup method uses the term logical backup. It supports multithreading, And the

Efficiently traversing InnoDB B + Trees with the page directory -- slot, traversinginnodb Efficientlytraversing InnoDB B + Trees with the page directory1, the purpose of the page directory As described in the posts mentioned above, all records in

Detailed description of data types in SQLite, detailed description of sqlite Data Types Most SQL database engines (all SQL database engines except SQLite as we know) use strict static types. When static type is used, the value type is determined by