MySQL

MySQL Select DatabaseAfter you connect to the MySQL database, there may be multiple databases that you can manipulate, so you need to select the database you want to manipulate. Select MySQL database from the command Prompt windowIn the Mysql>

Today, database operations are increasingly becoming a performance bottleneck for the entire application, which is especially noticeable for web applications. It's not just about the performance of the database that DBAs need to worry about, it's

MySQL Delayed update index (Delayed Key Write):The MyISAM table created with the table creation option Delay_key_write, after the query ends, does not write the changed data of the index to the disk, but instead caches the index change data in the

1. Modifying the varchar typeTo meet the requirements, the varchar (6) is now converted to varchar (8). The better approach is not to use altertable modify, but instead take the following steps:A Create a temporary table and set the varchar to

Write in frontMySQL database was used in the project, and MySQL was not used before, and today we learned the common syntax of MySQL, which is very similar to SQL Server syntax. It's pretty simple to use.An example1. Create a database named school.1.

In the previous two blogs, we discussed how to install and use Docker, and how to deploy an Apache server in Docker and access the server in an external computerLet's discuss how to use Docker to deploy a MySQL database and access the database on an

CREATE PROCEDURE userinfo_modify (in ID int,in loginid int,in levelid Int,innamestrvarchar (+), Intelvarchar (50), Inaccountvarchar ()) Beginset @lid =loginid;set @lvid =levelid;set @n=namestr;set @t=tel;set @a=account;set @uid =id; Select @eid

This article from: http://www.woqutech.com/?p=1116MySQL itself provides seconds_behind_master through show slave status to measure replication latency between master and slave, but today comes a scene that finds Seconds_behind_master as 0, a show

MySQL mysqldump only export the table structure or only the implementation method of data export, the need for friends can refer to.MySQL mysqldump export only table structure does not export dataThe code is as follows: -- opt-d database name-u root-

MySQL Client Connection server, client report corresponding error number summary:1. Error 104[Email protected]:~ $perror 104OS error code 104:connection reset by peerThis is because the server side backlog is full.2. Error 110[Email protected]:~

1,show processlist View the status of the table in the database, whether it is locked;Kill ID//kills locked table===================================================Set autocommit=0;SELECT * from t1 where uid= ' xxxx ' for update//is a row lock in

Use Pt-table-checksum to check master-slave consistency, pt-table-sync to achieve master-slave data consistency repairA. Percona-toolkit Download installation:Need to install other dependent environment packages first ...shell> perl-mcpan-e '

MySQL has a large number of parameters that can be modified--but should not be modified at random. Usually only the basic items are configured correctly (in most cases only a few parameters are really important) and more time should be spent on

1. Parameter descriptionSync_binlog Command-Line Format --sync-binlog=# Option-file Format Sync_binlog System Variable Name Sync_binlog Variable Scope Global

Today, database operations are increasingly becoming a performance bottleneck for the entire application, which is especially noticeable for web applications. It's not just about the performance of the database that DBAs need to worry about, it's

Root password forgotten, reset the root password of MySQL: First, modify the MySQL configuration file my.cnf 1. In paragraph [mysqld], add one sentence: skip-grant-tables

MySQL upgrades from 5.5 to 5.6, and changes in TIMESTAMPPreface Some time ago, the system MySQL was upgraded from 5.5 to 5.6, and a large number of exceptions occurred. Most of the exceptions are caused by changes in TIMESTAMP behavior.The behavior

MySQL study note _ 8_ SQL BASIC Language Review SQL language basic review  I. Overview SQL statement comments 1) All contents starting with "#" until the end of the line are comments 2) All content starting with "--" (-- and then a space) until the

A detailed tutorial on using sysbench to test MySQL performance, sysbenchmysql Sysbench is a modular, cross-platform, multi-thread benchmark testing tool used to evaluate the database load of different system parameters.Currently sysbench code

Detailed description of paging optimization instances in MySQL, and detailed description of mysql paging instances Generally, order by limit start and offset are used for paging query. For example, the following SQL statement: SELECT * FROM `t1`