PHP

Skip-grant-tables: very useful mysql startup parameter bitsCN.com Skip-grant-tables: very useful mysql startup parameters This section describes a very useful mysql startup parameter -- skip-grant-tables. As the name impliesGrant-tables is not

Differences between MySQL5.5 and 5.6 default parameter values of sweet potato bitsCN.com As part of the performance comparison between MySQL 5.5 and 5.6, I have studied the differences between the default parameters of the next two versions. to

MySQL Query cache summary bitsCN.com MySQL Query cache summary You can use the following SQL statement to view the cache-related parameter status of the current query: 1 Show variables like '% query_cache % '; The output result is similar to the

Compile and install Ubuntu-12.04.2 on MySQL-5.6.10 [Installation notes] Ubuntu BitsCN.com Compile and install the Ubuntu-12.04.2 on the MySQL-5.6.10 [Installation notes] The following installation involves several issues that need to be explained

Mysql permanently deletes Mysql and reinstalls bitsCN.com Mysql is permanently deleted, Mysql is reinstalled 1. delete mysql 1 sudo apt-get autoremove -- purge mysql-server-5.0 2 sudo apt-get remove mysql-server 3 sudo apt-get autoremove

Create and delete a MySQL trigger bitsCN.com Create and delete MySQL triggers The following article describes how to create a MySQL trigger and how to delete a MySQL trigger. if you create a MySQL trigger correctly, if you are interested in

Mysql numeric data type bitsCN.com Mysql value data type MySQL numeric data types can be roughly divided into two categories: one is an integer, and the other is a floating point or decimal. Many different subtypes are available for each of these

How to improve the database update speed bitsCN.com How to speed up database update You don't have to worry about it .. See the following SQL statement. [Java] String SQL = "update cats set name_alias = '" + rs. getString (1) + "'Where

A possible optimization method for mysqllimit large offset bitsCN.com A possible optimization method for mysql limit large offset When the mysql limit statement has a large amount of data, the offset After limit is too large, and the first query

Mysql log type bitsCN.com 1. [Error Log] --- record problems that occur when mysqld is started, running, or stopped You can use the -- log-error [= file_name] option to specify the location where mysqld saves the error log file. If the file_name

Database primary key scheme in distributed environment bitsCN.com Primary key solution for databases in distributed environments When mysql is applied, the primary key id usually increases automatically. how is this efficiency? In a cluster

Mysql concatenation operator bitsCN.com Mysql join operator 1. the effect of the comma-separated JOIN operator is similar to that of inner join: [SQL] Select t1. *, t2. * from t1, t2 where t1. I = t2. I; It is equivalent: [SQL] Select t1

SQL bitsCN.com for string processing An SQL statement for string processing A table has a json field. for example, props contains the following characters: {"1":36,"2":54,"3":160,"4":8,"5":767680,"6":12,"7":1,"8":8, "13":"14,17,21,20,23,22,25,24

MySQL Performance doctor: OrzDBA bitsCN.com MySQL Performance doctor: OrzDBA [Root @ even ~] # Svn co http://code.taobao.org/svn/orzdba/trunk A trunk/orzdba_rt_depend_perl_module.tar.gz A trunk/orzdba A trunk/orzdbatool usage instructions Obtain

Mysql execution plan bitsCN.com bad SQL not only directly affects the SQL response time, but also affects the database performance, resulting in a longer response time for other normal SQL statements. It is vital to learn how to write SQL statements

[Slow query optimization] use MySQL subqueries with caution, especially when you see the DEPENDENTSUBQUERY tag bitsCN.com case study: Preface: I have repeatedly stressed the importance of explain in slow query optimization 1 and 2, but sometimes

MySQL optimization-to do what you want, you must first sharpen the tool's EXPLAIN MySQLexplain BitsCN.com Recently, I have been getting familiar with MySQL and it is imminent to understand how to optimize it. to do this, you must first sharpen the

How can I modify the password bitsCN.com when I forget the password of MySQL? The password of the root account of MySQL is empty by default. it is often forgotten after the password is changed. If you forget the password of the root account, how can

Troubleshooting of mysql database startup exceptions in ubuntu BitsCN.com Run the following command to install mysql in ubuntu 12.04: sudo apt-get install mysql-server mysql-client Install After the installation, it starts normally, but finds that

How to restore Mysql database details bitsCN.com Because I plan to re-install the Mysql database on a test machine, the process may be miserable because I simply unmount the Mysql database and I didn't back up the Mysql database used by Discuz and