MySQL

Use an automated installer to automatically install MySQLNew MySQL 5.0 users can use the MySQL Installation Wizard and MySQL Configuration Wizard to install Mysql on Windows. The purpose of designing these two wizard is to facilitate new users to

Refer to heiyeluren's blog: test environment CPU: Intel Pentium4 2.66 GHzMemory: 1 GBDisk: 73 GB/SCSI OS: FreeBSD 4.11PHP: PHP 5.2.1MySQL: MySQL 4.1.23b Preliminary work My. cnf max_heap_table_size = 128M Create a table

The following article describes how to implement the MySQL database engine quickly. If you are a racing driver, you just need to press the button to change the MySQL database engine immediately. How do you feel? What MySQL (the best combination with

The following articles mainly introduce the performance tests of MySQL MyISAM engine and InnoDB engine. The MyISAM engine and InnoDB engine are often used in actual operations, the following article describes the performance tests of MySQL MyISAM

The following articles mainly describe the actual solution for forgetting the MySQL root Password. MySQL root Password is often used in practical applications. If you accidentally lose the root password, you can use our article to better understand

This article focuses on common MySQL maintenance and management tools. We all know that MySQL database is a very popular small database management system and was acquired by Sun IN January 16. Currently, MySQL is widely used in small and medium

This article mainly describes the summary of the actual operation steps for MySQL connection strings, including the connection methods of MySQL ctor/ODBC 2.50 (MyODBC 2.50), MySQL Connector/ODBC 3.51 (MyODBC 3.51) the connection method and other

The following articles mainly describe the use of C ++ database connection to Oracle database, ms SQL, and the actual operation process of MySQL database, I recently found SQLAPI ++ on the Internet. Its main function is to access multiple

The MySQL management tool introduced below is a dozen visual MySQL management tools with different functions. If you are interested in this, please take a look and I believe it will help you. Using a variety of well-designed tools to manage MySQL

MySQL master-slave synchronization is a mature architecture with the following advantages: ① the query can be performed on the slave server (that is, the READ function we often call) to reduce the pressure on the master server; ② back up data from

MySQL row-level locks often cause problems. The following describes the advantages and disadvantages of MySQL row-level locks. We hope you can learn more about MySQL row-level locks. If you want to perform a large number of INSERT and SELECT

Next, we will extract a background, and then the operation records I migrated from MySQL 5.5.31 to MariaDB 5.5.31 on CentOS 6.4. Finally, I found a better migration method. 1. Background MySQL is the most popular open source relational database in

  1. select count (*) FROM tablename is the optimal choice under any circumstances; 2. Minimize select count (*) FROM tablename where col = 'value' queries; 3. prevent the appearance of select count (COL) FROM tablename.     COUNT (*) and COUNT (COL)

MySQL partition Overview:Allows you to allocate multiple parts of a single table across file systems based on rules that can be set to any size. In fact, different parts of a table are stored as separate tables in different locations. The

Sqlyog has been trying for 30 days. I recently tried mysql database. The client tool using sqlyog feels good. The only difference is that the trial period is 30 days. I can see on the Internet that I want to delete a registry key, you can try it for

MySQL disk replication technology-DRBD: advantages and disadvantages comparison, precautions and Best Practices DRBD is the block-level synchronous replication technology implemented by the kernel module. The synchronization level here can be

The difference between engine = innodb and engine = myisam in mysql is that when MySQL Administrator is used to create a database, the table is of the InnoDB type by default. Later, when using Access2MySQL to export data, I found that only tables of

The load data command is a self-contained data import and export command in mysql. It can quickly import tens of millions of data records without getting stuck. Next I will introduce the usage of the load data command. Load data syntax

The TRUNCATE command clears all records in the Table in mysql and resets the table ID. Next I will introduce the usage and instance of TRUNCATE. Truncate table deletes all rows in the TABLE, but does not record the deletion of a single

1. Does MySQL 5.1 storage programs and functions work for replication? Yes, the standard behavior executed in the storage program and function is copied from the master MySQL server to the slave server. 2. Can the stored programs and functions