MySQL

First, the optimization operation of common database1, the design of the table to conform to the three paradigms.2, add the appropriate index, the index has a large impact on the query speed, you must add an index. Primary key index, unique index,

Optimization technology of U MySQL DatabaseA comprehensive technology for MySQL optimization, mainly includingA: Rationalization of table Design (3NF compliant)B: Add appropriate index (index) [Four kinds: normal index, primary key index, unique

First, the questionThe company has an old Linux server, apache+mysql+php structure, to a recent PHP project to deploy to the above, as a test environment,Since the new project was developed using the PHP yii framework, and the data access of the YII

First, the host master and Salver both shut down the firewall iptables, execute the service iptables Stop command:To set the selinux=disabled of the SELinux file:Second, create a databaseLog in to master machine and slave machine separately

ALTER table: Add, modify, delete table columns, constraints, and other table definitions.View column: Desc table name;Modify table name: ALTER TABLE T_book Rename to BBB;Add column: ALTER TABLE name add column name varchar (30);Delete column: ALTER

1. Go to Data Source (ODBC), management tools, control Panel2. Click Add, data source driver select MySQL ODBC 5.1 Driver;3. Pop-up the MySQL connecotor/odbc dialog box, enter the data source name, description (optional), TCP/IP server (server IP),

ERROR 2002 (HY000): Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (2)MY.CNF add[Client]Socket =/tmp/mysql.sock (tmp is the actual path)This article is from the "Network Engineering topic" Blog, please be sure to

There are always some Web site users on the server is too large, and affect the normal use of other sites, then how to put a certain smelly fish in their own acres of three points? Methods to limit the maximum number of connections for a single user

Sysbench of MySQL stress testInstallation of 1.sysbenchDownload Sysbench Source Package http://down1.chinaunix.net/distfiles/sysbench-0.4.10.tar.gzAfter downloading, there will be a sysbench-0.4.10.tar.gz compressed package.Generate directory

Title MySQL SUM () COUNT () is also in the work of the recordSUM () returns the number of columns and the total number of points such as a studentEg:select sum (obj) from table is definitely the sum of the numbers of the obj columns in the table

1. First create a new database in your MySQL database that you need to import.For example, I want to import the database hacker and create a new hacker database in the MySQL database.There is nothing in the new hacker database.2. Select the table

Problem Description:MySQL 5.5.15 the original SQL as follows:Select Constraint_schema,table_name,constraint_name,constraint_type from Information_schema.table_constraints where Table_schema not in (' Information_schema ', ' MySQL ', ' Test ', '

Compile and install MySQL650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/57/83/wKiom1ScGyugs6f2AAIyu1EMINI544.jpg "title=" Picture 1.png "alt=" wkiom1scgyugs6f2aaiyu1emini544.jpg "/> Target: Compile and install mariadb on mysqlm , and

Compile and install MySQL650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/57/83/wKiom1ScGyugs6f2AAIyu1EMINI544.jpg "title=" Picture 1.png "alt=" wkiom1scgyugs6f2aaiyu1emini544.jpg "/> Target: Compile and install mariadb on mysqlm , and

In the daily work, we will sometimes slow query to record some long-running SQL statements, to find out these SQL statements does not mean that it is done, we often use the explain command to view the execution plan of these SQL statements, to see

Concept:Locks are used to manage concurrent access to shared files. InnoDB locks the database at the row level. However, the InnoDB storage engine uses locks in many other places within the database, allowing concurrent access to different resources.

Use the mysqlbinlog tool to recover data based on location or time point. Use mysqlbinlog to restore data based on location or time pointMySQL backup generally uses full backup and log backup. For example, a full backup is performed every day and a

Mysql connects to the database, mysql connects to the database Wow, there's something that comes in touch with the background today! Isn't "mysql" counted? Hey, I feel very happy to write code. Let's summarize it today! (Good god, don't like it, don'

Mysqld-nt: Out of memory (Needed 1677720 bytes) solution, mysqld-nt1677720 The website was found to be a little slow today and mysql Log prompts mysqld-nt: Out of memory (Needed 1677720 bytes). The Troubleshooting result was due to the recent

The performance impact of MySQL type varchar (20) and varchar (255)1.If the index size is not limited when MySQL creates an index, the index length will use the length of this field by default, that is, varchar (20) and varchar (255) the