PHP

Mysql streamline process (delete some files) bitsCN.com saw a Buddy wrote a tutorial, record it, ready to lose weight at any time. 1. delete the mysql-test folder; 2. delete the SQL-test folder; 3. delete the debug folder under the bin directory;

In-depth analysis of the order of orderby and groupby in mysql bitsCN.com In mysql, the order by and group by are as follows:Select From Where Group Order Note:Group by IS executed first than order by, and order by does not sort the group by.

Resolve the problem of ERROR1005 when creating a foreign key in MySQL BitsCN.com When creating a foreign key in MySQL, an ERROR is prompted, but only the simple information is prompted: ERROR 1005 (HY000): Can't create table 'DB _ qxztc.

A detailed description of mysql merged tables: bitsCN.com The creation and merging of mysql tables is similar to that of partition tables. it is a feature of mysql that combines multiple myisam tables with the same structure into a virtual table.

Analysis of MySQL memory usage (global cache + thread cache) bitsCN.com First, let's take a look at the formula. MySQL memory is divided into two parts: global memory and thread memory (not all, but the most influential part ):Per_thread_buffers =

Mysql basics: mysqld_safe detailed description of the execution process for enabling bitsCN.com The basic process of mysqld_safe script execution:1. search for basedir and ledir.2. search for datadir and my. cnf.3. check my. cnf. for details about

Explanation of mysq-based field selection bitsCN.com Mysql supports many field types, including numeric, date/time, and string (character). storage space and storage efficiency must be taken into account during use;The following conventions are used

What is the difference between parsing mysql binary logs to process transactions and non-transactional statements? bitsCN.com During the execution of transactional statements, the server will perform additional processing. when the server executes

Brief summary of Mysql backup and recovery and introduction to the use of tee commands bitsCN.com Backup data method:I. SQL statements.Locks tables tablename READ; // READ lockBefore trying to LOCK a table, lock tables is not TRANSACTION-safe. it

Five tips for parsing and optimizing the MySQL insertion method bitsCN.com About 0.2 million of data insertion operations were encountered during work. after the program was compiled, it was found that the operation timed out. The maximum PHP

The use of bitsCN. comprofiling for parsing MysqlProfiling is a very useful mysql performance analysis tool. we will test the profiling function today. Thanks to the blog post "love Rose: The SQL performance analyzer of mysql is mainly used to

MySQL Query optimization-detailed explanation of adjusting internal variables bitsCN.com MySQL is so open that you can easily adjust its default settings to achieve better performance and stability. Key variables to be optimized are as

How to use the wordvb macro to generate SQL bitsCN.com Yesterday, BOSS issued a command to allow me to quickly generate SQL statements using word macros, so that we do not need to input a piece of metadata when creating a table. To improve

Usage of mysql_fetch_row () and mysql_fetch_array () bitsCN.com Mysql_fetch_array-- Get a row from the result set as an associated array or number array, or both Description: array mysql_fetch_array (resource result [, int result_type]) Returns the

How to release disk space by batch clearing the expired binlogs on the 128 group of node databases bitsCN.com. if there are 10 or less databases, you can manually enter the database through ssh. clean is enough, but there are hundreds of databases,

In-depth explanation of basic mysql knowledge bitsCN.com 1. each client connection is divided into a thread belonging to the server process. The corresponding queries of the connection are all processed by this thread. 2. the server caches the

Mysql common monitoring script command sorting bitsCN.com #/Bin/sh # Check whether mysql server provides services normally Mysqladmin-u sky-ppwd-h localhost ping # Obtain the current status values of mysql Mysqladmin-u sky-ppwd-h localhost status

Usage instructions and summary analysis of SQLite time functions This article mainly describes the analysis and summary of time functions in SQLite and provides use cases. The examples given in this article are all tested.SQLite time/date function

Based on some methods optimized in MYSQL, bitsCN.com Mysql storage engine myisam, innodb, and memoryMemory will be introduced later Innodb supports transactions, foreign keys, and row locks. mysql does not. Innodb does not support fulltext index

In-depth analysis of some SQL data connection problems bitsCN.com has not been very familiar with the differences between the keywords in connectionstring, so it is too cumbersome Let's explain some of the insights ...... ****************************