MySQL supports a large number of column types, which can be divided into 3 categories: numeric types, date and time types, and string (character) types. This section first gives an overview of the available types, summarizes the storage requirements
After the MySQL installation is complete, MySQL needs to be configured and optimized so that MySQL can run more efficiently.vi/etc/my.cnf #打开配置文件 [mysqld]Datadir=/data/mysqldata #在此位置读取数据Socket=/tmp/mysql.sock #sock Communication settingsUser=mysql #
# # Part1: Authorization # Authorization is granting certain permissions to a user. # example 1: Grant the test user the SELECT permission on all tables of the ABC library. GRANT SELECT on ' abc '. * to ' test ' @ ' localhost '; # example 2: Grant
The following transfers are from:http://www.tech-q.cn/archiver/tid-11673.htmlMost of the time, we created an index in MySQL, but some queries are still slow, and no index is used at all! In general, some fields may not have been indexed, or the
MySQL's universal "nested loops" are not optimal for every type of query. But fortunately, the MySQL query optimizer onlyA few queries do not apply, and we can often make MySQL work efficiently by rewriting queries.Let's take a look at the
Mysql After the server loses power, it discovers that the site link database failed, after viewing the data set status[Email protected]~]# service mysqld StatusMysqldis stopped[Email protected]dbserver1~]# chkconfig--list mysqldMysqld 0:off 1:off
MySQL optimization, in general, we rarely think about it, even if the idea of optimization is generally more program-level, such as not to write too much resource-intensive SQL statements, but in addition, there are still many areas of the system
1. function mysql_connect () connected to MYSQL server;$con = mysql_connect ("localhost", "root", "123456");if (! $con){Die (' Could not connect: '. Mysql_error ());}?>2. Select a databasemysql_select_db ("David", $con);?>3. Execute the SQL
Heartbeat and DRBD are the same as they were before. Here fine-tuned the next DRBD communication with a dedicated network card, so consider the speed limit is only IO .
about MySQL:Yum install mysql-server MySQLback up the previous
MySQL Side settings:The general version of the Zabbix is default with the MySQL monitoring projectUnder the installation directory zabbix_agentd.d/userparameter_mysql.conf[[email protected] zabbix_agentd.d]# more userparameter_mysql.conf # for
Generally speaking,SQL Severand theMysqlthe idea of stored procedures is the same, but there is a big difference in syntax and structure. 1. Write the stored procedure in MySQL all the dbo is removed. 2 . each SQL statement needs to be followed by
0. User management:1. New User:>create USER name identified by ' Ssapdrow ';2. Change Password:>set PASSWORD for Name=password (' FDDDFD ');3. Rights Management>show GRANTS for name; View name User Rights>grant SELECT on db_name.* to name; All
To import *.sql scripts directly in MySQL Qurey Brower, is the command to execute SQL files in MySQL without executing multiple SQL commands at once:Mysql> source D:/myprogram/database/db.sql;Also attached to MySQL common commands:A) connect to
?Mydumper is a lightweight third-party, open Source tool for MySQL database backup, backed up in logical backup mode. It supports multi-threading, and backups are much faster than the mysqldump of the original ecosystem and many of its outstanding
MySQL deadlock checkI read a blog about the deadlock check today.Advanced InnoDB Deadlock troubleshooting–what SHOW InnoDB STATUS doesn ' t tell you, and what diagnostics you should be Lo OKing atOne common cause for deadlocks when using InnoDB
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service