mysql recreate

I deleted part of the data: mysql> Delete from pending_22 limit 1000;Query OK, 1000 rows Affected (2.99 sec) But delete does not automatically free space, the table table space size is still before size: 30408704 To release the next space by

This article mainly explains the mysql commands in centoslinux (redhatlinux). If your mysql is installed in source code, I add the "mysql installation directory bin" to the path environment variable, mysql startup script has been copied to etcinit.

Rotten mud: Restore the mysql database through binlog, binlogmysql This article was sponsored by Xiuyi linfeng and first launched in the dark world. In the previous article, we explained the basic knowledge about mysql binlog. In this article, we

MySQL upgrade is necessary. on PerconaSupport, we listed various questions about MySQL upgrade best practices. this article recommends some methods to upgrade MySQL under different circumstances. why is MySQL upgrade required? There are many reasons.

mysql| Standard | reference | reference Manual | chinese MySQL Chinese reference manual 6 (MySQL compatibility with the standard) Reprinted translator: Yan Zi return 〗〖 Forwarding Q Translator: Yan Zi (clyan@sohu.com) Homepage:

I. SQLSQL: the abbreviation of StructuredQueryLanguage Structured Query Language SQL industrial standard: SQL compiled by ANSI (ISO (core member of internationalstandardorgnation) According to industrial standards can run on any database. Dialect:

Guide to MySQL upgrade Http://blog.sina.com.cn/s/blog_5a8b8eb80100ld7a.html We recommend that you upgrade the version from one released version to another. For example, to upgrade MySQL 3.23 to MySQL 4.0, instead of directly upgrading to MySQL 4.1

Incompatible upgrade points 1. the character set or collation has changed in MySQL 5.1.21/5.1.23 and 5.1.24. Therefore, you may need to redo the index during the upgrade process.Section 2.12.3 specifies the specific situation in which the index

From: http://www.linuxidc.com/Linux/2011-01/31263.htm   I. Prepare the development environment1. install linux first. Ubuntu is used here.10.102. Install the MySQL software package. MySQL 10.10 is included in the system repository:Sudo apt-Get

Incremental backup concept:Backup files or content that have been added or changed since the last backupFeatures of incremental backups:Advantages: No duplication of data, backup volume is small, time is short.Disadvantage: All incremental backups