MySQL

The optimization of MySQL is not in line, has done several optimizations, but is not very ideal, or waste resources too much. I have always found that my MySQL cache hit rate is very poor, in good times to reach the 60-70%, but run a long time, only

mysql tutorial cant open file: Table name modification method 1.can ' t Open file: ' [table]mytable.myi '2.table ' picture ' are marked as crashed and should be repaired The following methods are valid only for tables in MyISAM format. Other types

Linux open MySQL Remote connection method 1. Grant command create remote connection MySQL authorized user root Mysql-u root-pMysql>grant all privileges in *.* to root@localhost identified by ' 123456 ' with GRANT OPTION; Increase root user

MySQL Tutorial save data appears illegal mix of collations (gbk_chinese_ci,implicit) Other such issues are very simple to deal with, that is, the page submitted data and MySQL field types inconsistent with the image, as long as they are unified.Now

Back up the MySQL Tutorial database tutorial commands mysqldump-hhostname-uusername-ppassword databasename > Backupfile.sql Backing up the MySQL database for a deleted table formatBacking up the MySQL database is a format with a deleted

MySQL tutorial concat () connection string detailed descriptionIn some cases you want two or more strings, in MySQL there is a string concatenation function concat (), let's talk about how it is used. Concat syntaxConcat (STR1,STR2,...) Simple

MySQL tutorial temporary tables and memory tables create query deletions and considerationsThe temporary table and the engine of the memory table are different, the temporary table defaults to the MyISAM, and the memory table is memory, the

After restarting the server, use the top command to see which processes are consuming so much CPU usage. Stare at a good more than 10 minutes, the main CPU-consuming process has two, one is MySQL, the other is Apache. As you can see from the figure

In Excel, we can use this formula to calculate the price segment of each price, and then use the pivot table to get the data:= LOOKUP (H2, {0, 49.99, 99.99, 149.99, 199.99, 249.99; "050 & Prime;," 100 & Prime;, "150 & Prime ;, "200 & Prime;," 250 &

1. Log generation performance impact:The direct performance loss caused by log records is the most expensive IO resource in the database system. MySQL logs include ErrorLog, UpdateLog, Binlog, QueryLog, and SlowQueryLog. Of course, the update log is

Online switching is also supported. Switching from the current running master to a new master takes only a short time (within 0.5-2 seconds). In this case, only write operations are blocked and read operations are not affected, easy to maintain host

MySQL supports SQL subqueries. This technique can use the SELECT statement to create a single column query result, and then use this result as a filter condition in another query. Subqueries can be used to complete SQL operations that require

When using mysql to create and call stored procedures, functions and triggers, the error code is 1418.ERROR 1418 (HY000): This function has none of DETERMINISTIC, no SQL, or reads SQL DATA in its declaration and binary logging is enabled (you *

I recently saw an article about mysql optimization. I would like to record and share the optimization methods used in two of them.Group by optimizationSELECT goods_id, count (*) FROM t group by goods_id;BY default, MySQL applies to all group by col1,

After MySQL is installed on VPS, the default user is root @ localhost. The simplest way to add a new MySQL User is:Execute the following statement in phpmyadmin (add points at the end of the statement; no ):Grant all privileges on DBNAME. * to

First, describe the background. There are two local hard disks,120 gb ssd = 60 (linux ext4) + 60 (win7 NTFS)2 TB mechanical hard drive = 600 gb ntfs + 600g ntfs + 700G NTFSIn order to take care of Windows 7's compatibility with ext partitions, we

Three installation methods:1. install sudo apt-get install mysql-server from the Internet. After the environment variables have been automatically configured, you can directly use the mysql command.Note: We recommend that you change cn

1. Install php5 The code is as follows:Copy code Apt-get install php-pear php5-cli php5-common php5-cgi php5-mysql php5-gd php5-dev 2. Install mysql5 The code is as follows:Copy code Apt-get install mysql-server mysql-client

 Preparation:1. Configure the firewall and enable port 80 and Port 3306.Vim/etc/sysconfig/iptables-A input-m state -- state NEW-m tcp-p tcp -- dport 80-j ACCEPT # Allow port 80 to pass the firewall-A input-m state -- state NEW-m tcp-p tcp -- dport 33