MySQL

Today, encountered a problem, Zabbix prompt data disk/opt less than 20%, need to clean up. After viewing,/opt/mysql a log file reached 16G, and the data disk total 20G, the log file is Master.log, the query, it is the general query log MySQL, record

Commands to back up the MySQL databaseMysqldump-hhostname-uusername-ppassword databasename > Backupfile.sqlBacking up the MySQL database to a format with a delete tableBacking up the MySQL database is a format with a delete table that allows the

This version of MySQL doesn ' t yet support ' LIMIT & In/all/any/some Error ResolutionThis error occurs when using nested queries in a MySQL expression. The reason is that the inner SELECT statement has a limit clause.In the online search, there are

at night a small study of the next MySQL stored in the Read binary data function. The key step is the following three points: the most important point: the type of table that stores the binary data needs to be a blob type (divided by length tiny,

Today, we tested MySQL's highly available architecture--mha, and performed automatic switching, manual failover, and manual online switching, where manual online switching found pits: When the old Master switched to a new slave, the READ_ONLY was

Integrated Apache+php+mysqlApache: First modify the Apache configuration file, let Apache support parsing php files. Apache configuration files are httpd.conf in the Conf directory of the Apache installation directory.1. Allow Apache to parse the

SHA1 ();             40-bit SHA (); 40 guestsMD5 ();   32-bit password (); 41 Guestsuse of case and then endSelect Sname name, Sscore score, case when Sscore was null then ' retake ' when sscore>=90 then ' excellent ' when sscore>=80 then ' good '

Build a double master, suddenly think of if the table set the self-increment primary key, when the business at the same time to insert a pair of data in a double library, what is the situation like?For example, a table data on the main library A and

1, in MySQL, the reserved word can not be used as table name, field name, etc., as follows:Mysql> ALTER TABLE student ADD column desc varchar (+) after name;1064-you has an error in your SQL syntax; Check the manual-corresponds to your MySQL server

open MySQL slow query under Linux1. Introduction to Slow QueriesAs the name implies, the slow query log is a long-running query SQL statement, the default file name is Hostname-slow.log, the default directory is also the data directory. The slow

Business Requirements: User table R_user Save the user name and other information. Now need to set up a work base for each user, a user can have more than one work base, multiple users can also have a work base, that is, many-to-many relationships. (

After downloading the ecshop, unzip, go to the directory upload/includes, copy the cls_mysql.php into your own websiteLike my directory structure.Classes/classes/cls_mysql. php/classes/connfig. PHP/index.phpCreate a new connfig.php file in

MySQL statement optimizationExample 1: Optimization statement SELECT * from ' Tbl_order_buy_eta ' WHERE ' Id_order ' =1843#通过explain分析语句结果如下mysql > explain SELECT * FROM  ' Tbl_order_buy_eta '  where   ' Id_order ' =1843\g*************************** 

1. Find out if MySQL was previously installedFirst use: Yum remove mysql* command to uninstall MySQL and related componentsCommand: Rpm-qa|grep-i MySQLYou can see the following as shown:Description was previously

Today when you configure the server to install mysql5.5 always cannot install, view Log error prompt is 1067 error, see my workaround belowEvent Type: ErrorEvent Source: Service Control ManagerEvent Type:NoEvent id:7034Date: 2012-11-1Event:

In MySQL master-slave architecture, the default is the asynchronous mode, that is, in master to save the data in the database, and then write the operation to Bin-log in response to the client. As to whether the slave synchronized the binaries and

SELECT * FROM INFORMATION_SCHEMA. Innodb_lock_waits;select * from INFORMATION_SCHEMA. Innodb_locks; Show Processlist//View the status of the table in the database, whether it is locked; kill ID //Kill the Locked tablePerform show engine InnoDB

When I first started installing MySQL, I could see it in the Windows service, but I didn't use it for a while, and when I was ready to start the MySQL service from the Windows service, I found there was no MySQL service, so my solution was:1. If you

First, MySQL ClusterAdvantage: Very high availability, very good performance. Each piece of data can have at least one copy stored on different hosts, and redundant copies of the data are synchronized in real time. But its maintenance is very

Mac does not own MySQL, here need to reinstall, the method is still very simpleInstall--verbose--user= 'whoami'--basedir="$ (brew--prefix MySQL)" --datadir=/usr/local/var/mysql--tmpdir=/tmpsudochown -R your_user/usr/local/var/ mysql/The first