MySQL

Mysql> show Processlist;ID Identification numberUser Current usersWhich port from which IP the Host command is issuedDB Current Process-connected databasecommand commands for the current connection executionTime when this state was executedSQL

      org.hibernate.dialect.mysqldialect    com.mysql.jdbc.Driver     jdbc:mysql://localhost:3306/sampledb? Zerodatetimebehavior=converttonull    root    root    truE    Java minimal configuration for MySQL

mysql> show global status; Can list MySQL server running various status values, my personal preferred usage is show status like ' query value% '; One, slow query mysql> show variables like '%slow% '; +------------------+-------+ | variable_name

Environment: CentOS6.5, minimized installation environment1. PreparationYum Install Lrzsz gcc* LibaioYum Erase mysql-libs-5.1.71-1.el6.x86_642. Download mysql5.6http://dev.mysql.com/downloads/mysql/3. Upload and UnzipTar XF Mysql-5.6.20-1.el6.x86_64.

1#!/bin/Bash2# the- One-43 #author PDD4 #backup MySQL5 6Backup_target_dir="/data/mysql_backup"7Backup_logs_dir="/data/mysql_backup/logs"8 9date=$ (Date "+%y.%m.%d")Tenldate=$ (Date "-d-4 Day" "+%y.%m.%d") # Keep5Backup Files One A Echo "----------$

Explain shows how MySQL uses indexes to process SELECT statements and join tables. Can help select better indexes and write more optimized query statements.Using the method, add explain to the SELECT statement, such as:Select * from where

Range of values for each data type in MySQLTurn around here and write it down slowly.TINYINT-128-127TINYINT UNSIGNED0-255SMALLINT-32768-32767SMALLINT UNSIGNED0-65535Mediumint-8388608-8388607Mediumint UNSIGNED0-16777215INT or INTEGER-2147483648-214748

MySQL events are like timed tasks on a Linux system that perform set-up tasks at a set time or time interval.If you use a SQLyog class of write stored procedures, triggers, or events will be easier, such as SQLyog will generate an approximate

http://blog.csdn.net/flyinmind/article/details/7740540Erlang is used in the project, and MySQL is used as well. Convention, Google.However, according to the online said to do, some discrepancy, does not work, need to find their own, the following

Sister's, engaged for several days MySQL, manual installation is not successful, always have a variety of errors, original AH found that the version is not correct, so Linux installation software must be optimistic version.1. Unzip the downloaded

MySQL time can not be directly subtracted, if the day, minute, time difference, subtract the result is wrongMysql> select T1,t2,t2-t1 from MyTest; +---------------------+---------------------+-------+  | T1 | T2 |  T2-t1 | +---------------------+----

Windows:1. Log into the system with the system administrator.2. Stop the MySQL service.3. Go to the Command window and enter the MySQL installation directory, for example, my installation directory is c:mysql, enter C:mysqlbin4. Skip permission

Yesterday, in a variety of ways to test MySQL database backup and recovery operations, the recovery process, MySQL will not start.Tips are as follows:22:59:43 [MySQL] attempting to start MySQL app ... 22:59:43 [MySQL] status change

MySQL database operation under the command lineFirst, connect the database(1) Connect to the local database, enter a command, you will be prompted to enter a password. Enter Password Login databaseMysql-u root-p(2) Connect to the remote

Select partition_name part,partition_expression expr,partition_description descr,table_rows from where table_schema=SCHEMA and table_name='mx_ Domain'viewing partition informationCREATE TABLE' Mx_domain ' (' ID ')int(Ten) not NULLauto_increment, '

Prerequisite Requirements:The transaction log must be on the same volume as the data file;To request a global lock on MySQL before the snapshot volume is created, release the lock manually after the snapshot creation is complete;Once the global lock

1. Install MySQL First2. Second easy to operate MySQL should download a graphical interface to the database operating software: for example mysql-front or EMS SQL Manager3. Install the EMS will prompt to set the root user's password, this password

Today, one of the game server database MySQL master, the system becomes read-only mode, after restarting into safe mode, after the execution of fsck back to normal. After the server is up, MySQL starts up normally, but a slave has been in sync error.

Solve a deadlock problem in mysql Here we are talking about innodb deadlocks! I have found a lot of other commands on the Internet to view the deadlock information. This can be used later: Show engine innodb status; (varies with the mysql

MySQL security issues, mysql garbled issues When using MySQL, you must pay attention to security issues. The following are 23 notes for MySQL:1. If the connection between the client and the server needs to span and pass through an untrusted network,