MySQL

1. Login Configuration Interface2. Show ProcesslistView the processes currently in use3. Warnings suggest which parameters you should optimize.4, introduce the configuration of the slow query, the other can be configured on their own, are simple

Server on the use of MySQL command to insert data, many times will encounter the insertion of data garbled problem, export a SQL execution file, and then pour into the unbutn, the result garbled, toss 7-8 minutes,How to SolveWhen exporting the MySQL

In a database table, indexing a field can greatly improve query speed. Suppose we create a mytable table:Copy CodeThe code is as follows: CREATE TABLE mytable (ID INT NOT NULL, username VARCHAR (+) not NULL);We randomly inserted 10,000 records,

1, through floor critical error/* Database version */Http://www.waitalone.cn/sql.php?id=1+and (select 1 from (SELECT COUNT (*), concat (SELECT (select Concat (0x7e, Version (), 0x7e)) (Information_schema.tables limit 0,1), floor (rand (0) *)) x from

Today the company Daniel helped me fix the MySQL initialization password problem, record:~ PS aux | grep MySQLMetro 7149 0.0 0.0 2432772 564 s000 r+ 7:16 pm 0:00.00 grep--color=auto--EXCLUDE-DIR=.BZR--exclude-dir=cvs--exclude-dir =.git--exclude-dir=.

there are several declarative forms of error handling: § If any errors (not notFOUND), set L_error to1to continue execution after:DECLARE CONTINUEHANDLER forSQLEXCEPTIONSETL_error=1§ If any errors occur (not notFOUND), executes rollback and

Http://blog.chinaunix.net/uid-259788-id-4146363.htmlhttp://www.cnblogs.com/Amaranthus/p/4028687.html MYSQL 5.6 ManualHttp://www.cnblogs.com/hustcat/category/214566.html yy Brotherhttp://blog.163.com/li_hx/blog/static/18399141320150253652874/that

Recently I have been doing the Order class project, using the transaction. Our database chooses MySQL, the storage engine chooses the INNODB,INNODB to have the good support to the transaction. In this article, we're going to pick up a piece of

Http://www.innomysql.com/article/25717.html[[email protected] plugin]# pwd/Usr/Local/Mysql56/Lib/plugin[[email protected] plugin]# Lltotal2184-Rwxr-xr-X.1Root MySQL15437Sep + -adt_null.so-Rwxr-xr-X.1Root MySQL25619Sep + -auth.so-Rwxr-xr-X.1Root

The MySQL database disappears if the MySQL root password is not modified by the password () function under the Linux system. Some people may not know and directly modify the root password of MySQL, resulting in the MySQL database disappears problem,

Recently in the study of database backup, scheduled to perform backup tasks, where the backup script is set to the crontab command timed execution, the script content is as follows:[email protected] ~]# cat mysql-backup.sh#!/bin/bashDbpwd= '

Sql_cmd.hEnum Enum_sql_command {Sqlcom_select, Sqlcom_create_table, Sqlcom_create_index, Sqlcom_alter_table,Sqlcom_update, Sqlcom_insert, Sqlcom_insert_select,Sqlcom_delete, Sqlcom_truncate, sqlcom_drop_table, Sqlcom_drop_index,Sqlcom_show_databases,

Description1, red indicates key parameter2, "Global Cache", "Thread cache", the global cache is all thread sharing, the thread cache is each line thread attached the data when the creation of a thread ( if not set up a thread pool), if there is a 200

Summarize three kinds of MySQL foreign key constraint modeIf Table A's primary key is a field in table B, the field is called the Foreign key of Table B, table A is called the primary table, and table B is called from the table. Foreign keys are

Recently I have been doing the Order class project, using the transaction. Our database chooses MySQL, the storage engine chooses the INNODB,INNODB to have the good support to the transaction. In this article, we're going to pick up a piece of

Open eclipse1. Right-click the project for which you want to import the jar package, click Properties2. Choose Java build path on the left and select libraries on the right.3. Select Add External jars4. Select the jar package according to the pathOK,

(recently in learning MySQL optimization of some problems, the following is a few personal gains, if there is insufficient, please ask!) ）Overview: When a table of data is large, such as 200G, it is too large, we only rely on the index is not good,

The main library occupies a large space, found in the OA data directory vigorously Binlog file many, in the server patrol process found that disk space is a large number of occupied, log in from the library to find the actual amount of data, should

The database size remains unchanged after the delete record of mysql is deleted, and mysqldelete This problem occurs when conditions are followed after the DELETE operation. Delete from table_name where Condition After the data is deleted, the

Mysql Replication master-slave synchronization, mysqlreplication Introduction: Mysql master-slave synchronization is a common solution for enterprises. It is often used to back up databases. When the client operates the master database, the master