MySQL

  In the recent open-source project of yymysqlsdk, Chinese support is not in place. Therefore, it took 1.5 days to analyze various Chinese processing conditions.       1. First confirm your mysql configuration file, my. ini (only for windows)

  Yesterday, the database on the server suddenly couldn't be opened (I tried a variety of methods), and later I had to reinstall it. But every time I installed it in the last step, I would prompt that the installation was unsuccessful, the database

  1./cd /Usr/local/mysql/bin ./Mysql-h localhost-u root // You can access the MySQL server. 2. mysql> GRANT ALL Privileges on *. * TO 'root' @ '%' WITH GRANT OPTION // Grant data access permissions to any host For example, if you want myuser to use

  MySQL provides a tool for importing and exporting databases. However, sometimes we only need to import and export data from a single table, such as importing and exporting CSV files. In this case, you can use the MySQL Automatic Command to import

Reprinted, please sign: Yin Feng-----------------------------------------------------------Recently, I encountered a problem where an online machine waited for the semaphore for a long time. The mysql monitoring thread thought that mysqld had been

I encountered several cases where MySQL did not use the expected index. After reading some documents, I found that the impact of MySQL type conversion on index selection is not small. For example, there is a MySQL table: Create table 'indextest

Mysqldump-h host-u username-p Database Name> exported database name. SQLMysqldump-h host-u user name-p database name Table Name> exported table name. SQLSeveral common parameters are as follows: -P or -- port: the server port to be connected. this

Mysql latin1 is not equal to the standard latin1 (iso-8859-1) and cp1252, 0x80-0x9f characters more than the iso-8859-1, than cp1252 0x81, 0x8d, 0x8f, 0x90, 0x9d has a total of five

Show variables;/** view the actual running parameter values of the server **/02/* check whether the stored procedure exists. If yes, delete */03 drop procedure if exists helloword04/* test the Stored Procedure */05 DELIMITER //06 create procedure

Today, when connecting to mysql with myEclipse, the message "Communications link failure, Last packet sent to the server was 0 MS ago." error interface is shown in:  Myeclipse error prompt pageCheck that the remote server can be pinged on the local

20 million records need to be inserted in mysql. The insert statement has a limited insert speed. Hundreds of records are inserted every second. This speed can also be applied to hadoop clusters, which may be caused by database problems, the insert

Error: 1130-host... is not allowed to connect to this MySql server solution: 1. Change the table. It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log on to mysql on the localhost

1. What is an index? Indexes are used to quickly search for records with specific values. All MySQL indexes are saved as B-trees. If no index exists, MySQL must scan all the records of the entire table from the first record until the required

1. The configuration is enabled.Linux: In the mysql configuration file my. add log-slow-queries =/var/lib/mysql/slowquery in cnf. log (specify the location where the log file is stored, which can be null, the system will give a default file

When the innodb instance is shut down abnormally, the mysql instance cannot be started due to an innodb fault. View the err log. InnoDB: Starting crash recovery. innoDB: Reading tablespace information from. ibd files... innoDB: Restoring possible

The unix_timestamp function for time comparison in MySql can accept a parameter or do not use a parameter. The return value is an unsigned integer. If the parameter is not used, it returns the number of seconds that have elapsed since 00:00:00,

When creating a new TABLE that year, you can add an ENGINE or TYPE option to the create table statement to tell MySQL what TYPE of TABLE you want to CREATE: create table t (I INT) ENGINE = INNODB; create table t (I INT) TYPE = MEMORY; to convert a

Fil_init mainly refers to the initialization file opening pointer hash table. All opened files are recorded in fil_system, And the buf_pool_init memory buffer pool Initialization is constructed for the hash table searched by name, corresponding to

Mysql group_concat () function traps my colleague sent me a rest interface today saying there should be data, but no data was found. Solution: After troubleshooting, we found that mysql's group_concat () function only returns a 1024-length string by

Mysql show profiles is added after 5.0.37 to analyze SQL Performance. To use this function, make sure that the version is later than 5.0.37. Check my database version mysql> Select version (); + --------------------- + | version () | + --------------