MySQL

How to view MySql status-how does MySql view the number of connections and status and how does it enter the mysql command line? There is a bin directory under the mysql installation directory. first enter the directory with the command line, and

MySQL Reading Notes about table_lock_wait and table_lock_immediate received a document from a fellow user a few days ago, which is MySQL High Performance 2 Reading Notes, 97 pages, 6 w words. After describing the knowledge point, I hope to discuss

MySql numeric functions abs (N) returns the absolute value of N www.2cto.com mysql> select ABS (2);-> 2 mysql> select ABS (-32);-> 32 sign (N) returns the parameter symbol (-1, 0, or 1) mysql> select SIGN (-32);->-1 mysql> select SIGN (0 ); -> 0

MySQL queries do not use index summary. We all know that adding an index is an effective way to increase the query speed. However, in many cases, even if an index is added, the query still does not use an index, which seriously affects the

MySQL 1594 error solution MySQL 1594 error solution: Example: www.2cto.com Master_Log_File: mysqld-bin.000042 Read_Master_Log_Pos: 99749808 Relay_Log_File: mysqld-relay-bin.000083 Relay_Log_Pos: 15995 runtime: mysqld-bin.000041 runtime: Yes Slave_

MySQL 1236 error solution due to the master server abnormal reboot, resulting in an error from, the error is as follows: www.2cto.com show slave status error: mysql> show slave status \ GMaster_Log_File: mysql-bin.000288Read_Master_Log_Pos: 627806304

Use BINLOG to find the SQL statement of the specified date and search for posts on the 95 database server. post_thread's postid = 1652971, the SQL statement www.2cto.com # grep datadir/etc/mysql/my that was executed on February 24. cnfdatadir

[MySQL] converts the date and time formats. Here is an example of using the date function. The following query Selects all records. The value of date_col is within the last 30 days: www.2cto.com mysql> SELECT something FROM table WHERE TO_DAYS (NOW (

Mysql structure hierarchyTo understand MySql, you must keep in mind its architecture. Mysql is composed of SQL interfaces, Resolvers, optimizers, caches, and storage engines.Www.2cto.com1. Connectors refers to the interaction with SQL in different

Connection between left and right of mysql and internal connection of cainiao1. create a table: boy and insert several lines of data. Java code: create table boy (Name varchar (10 ),Flower varchar (10)); Java code insert into boyValues("Lin shuhao",

Mysql inserts large data into a table. Method 1: The data volume is not large and there are thousands of rows of data. use notepad to edit the data. The result is as follows: insert into 'web4399 _ vote '. 'frxz2 _ hlwjhj_code '(active_code) values (

Record the helpless power failure caused by a failure to start mysql after a power failure. Mysql cannot be started. 1. view error 130313 15:31:13 [Note] Plugin 'federated 'is disabled. 130313 15:31:13 InnoDB: Initializing buffer pool, size = 107.0

The first step (generally omitted) for executing SQL scripts in mysql is to enable the mysql service (which runs automatically at startup by default): control panel --> management tools --> services, find the item named mysql in it, and double-click

Detailed records of innobackupex different backup methods [html] common backup mode [root @ Slave02 tmp] # innobackupex -- database = "inno test" -- user = root -- password = root -- no-lock -- defaults-file =/etc/my. cnf/data0/backup/mysql

MySQL master-slave replication several important startup options (1) log-slave-updateslog-slave-updates this parameter is used to configure whether to write updates from the server to binary logs, this option is disabled by default. However, if the

MySQL InnoDB Storage engine lock mechanism experiment MySQL's InnoDB Storage engine uses row-level locks, and the default transaction isolation level is Repeatable read, unlike Oracle's default transaction isolation level commit read. What is the

Build a mysql cluster in linuxChapter 2 Environment Description1.1 System DescriptionThree linux servers are used and centos is used to minimize the installation of the system.1.2 Software DescriptionDatabase Management Nodes and database nodes all

Mysql common options binlog-format can be set to STATEMENT (default), ROW, and MIXED. SUPER is required. It is not recommended to modify the binlog-format value when replication is in progress. Binlog-do-db (binlog-ignore-db, replicate-do-db,

The rational setting of SQL _mode in mysql SQL _mode is a variable that is easily ignored. The default value is null. In this setting, some illegal operations can be allowed, such as the insertion of some illegal data. In the production environment,

Mysql 5.6.10 parameters (verification) my. there are two INI files that must be changed: Cancel table_cache and log-slow-queries = slow. log must be changed to slow-query-log-file = slow. log [mysqld] port = 3306 available basedir = D:/wamp/mysql