MySQL

The most important and distinctive feature of MySQL is his storage engine architecture, which is designed to separate query processing (precessing) and its system tasks (Server Task) from the storage/extraction of data.1.1 MySQL Logic

4.1 Selecting the Optimized data type general principlessmaller is usually betterThe premise is to ensure that you do not underestimate the range of values that you need to store: because it consumes less disk, memory, CPU cache, and requires less

What are the MySQL permissions tables, and what are the considerations for controlling MySQL permissions separately? 1, User: Record account number, password, global access information, etc., the permissions in the global level 1) *_priv: For MySQL

Server operations, often want to see the MySQL database size and size of each table, so the review, the main find out the argument, combined hurriedly special good, as follows.You can open the MySQL information_schema database if you want to know

In order to minimize the disk's Io,myisam storage engine table using key cache to cache the index block, the cache size of the index block is set by the Key_buffer_size parameter, and if the table in the database is dominated by the MyISAM storage

The following error occurred while viewing the MySQL logVi/home/mysql/var/localhost.localdomain.err160426 3:07:23 [Note]/usr/local/mysql/libexec/mysqld:shutdown complete160426 03:07:23 mysqld_safe mysqld from PID

one, when the table does not exist, createBefore doing the project is too rush, a lot of things are not recorded. It's time to make it back.MySQL makes a big table, because to save history, so the amount of data is very large, the query is very slow.

header (' Content-type:text/html;charset=utf-8 ');Encapsulating MySQL Connection databasePhp_mysqlEncapsulating MySQL Connection database php_mysqliEncapsulating MySQL Connection database php_pdoClass db{//Three private altogether//private static

First, mathematical functionsMathematical functions are mainly used for processing numbers, including integers, floating-point numbers, and so on.ABS (x)Returns the absolute value of XSELECT ABS (-1)--return 1Ceil (x), CEILING (x)Returns the

First, mathematical functionsMathematical functions are mainly used for processing numbers, including integers, floating-point numbers, and so on.ABS (x)Returns the absolute value of XSELECT ABS (-1)--return 1Ceil (x), CEILING (x)Returns the

ObjectiveAny system needs to focus on the production environment error log at any stage, and in recent months, it has been discovered that there are occasional database deadlock situations. Previously encountered the database class errors are mostly

Binlog LogBinary log formatStatement -based statementRow rows basedMixed Mode mixedBinary Log EventsLocation-based postion based on time Datetime-timestampThe replication process has a very important limitation--replication is serialized on slave,

Error problem:650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "border=" 0 "style=" Background:url ("/e/u261/ Lang/zh-cn/images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>650) this.width=650 ;

1. Data backup1) Backup with mysqldump commandFirst: Back up a database- -P dbname table1 table2 ... > Backupname.sql Note: dbname represents the name of the database, the name of the table1 and table2 tables, the entire database is backed up

Create database 1, directly on the shortcut key Ctrl+d, the following dialog box appears, select "Create" as needed, OK to add the user and add users to the added user authorization ①sqlyog and authorize the added user. 1. Create the connection as a

1. Modify Zabbix_agent.conf[email protected] etc]# cat zabbix_agentd.confLogfile=/tmp/zabbix_agentd.log#被动模式填服务器的IPserver=192.168.1.111#主动模式, fill in the IP of the

Learned a few good optimization methods:1. Technology optimizationThere are many ways to optimize SQL itself, such as indexing and ensuring the proper use of indexes, analysis of execution plan, in the context of cost-based execution scenario,

One. Common MySQL command-line commands1. Start MySQL service net start MySQLStop MySQL service net stop MySQL 2. Netstat–na | findstr 3306 View the port being monitored, findstr is used to find out if there is a port in the back3. Log in to the

Install mysql 5.5.28 and mysql-font After installing MySQL, I noticed some problems during the installation process. During the installation process, I cut down the steps and hoped to help anyone who needed them, my database is 5.5.28. Follow these

SQL File Import and Export from MYSQL 1. MYSQL Command Line Mode settings Desktop> my computer> Properties> environment variables> New>PATH = "; path \ mysql \ bin;", where path is the installation PATH of MYSQL. Ii. How to enter MYSQL through