分类为 ‘mysql’ 的文章归档：

MySQL如何利用索引优化ORDER BY排序语句

2010-03-22 Posted in mysql | No Comments » [ Popularity: 17% ]

Tags：复合索引, 优化, 索引优化, order by, 排序.

如何实现MySQL+PHP架构的网站转移数据备份恢复到新的服务器

2010-03-13 Posted in linux, mysql, 数据库, 服务器 | No Comments » [ Popularity: 18% ]

Tags：网站转移, 网站构架, ssh, 数据备份, 数据恢复.

MyISAM几个配置选项说明

2009-06-17 Posted in mysql | No Comments » [ Popularity: 52% ]

Tags：优化, 配置, MyISAM.

Mysql运行状态分析

2009-03-04 Posted in mysql, 服务器 | No Comments » [ Popularity: 59% ]

Tags：优化, 分析, 运行状态.

mysql中Explain的使用方法

2009-02-15 Posted in mysql | No Comments » [ Popularity: 59% ]

Tags：explain, mysql优化.

导入导出MySQL数据库SQL文件

2009-02-13 Posted in mysql | No Comments » [ Popularity: 59% ]

Tags：导出, 导入, 数据库.

mysql数据库动态修改参数的方法

2009-01-29 Posted in mysql | No Comments » [ Popularity: 59% ]

Tags：动态, 参数, 方法.

Host ‘XXXXXX’ is blocked because of many connection errors

2009-01-18 Posted in mysql | No Comments » [ Popularity: 59% ]

Tags：error.

修改MYSQL默认编码的方法

2009-01-17 Posted in mysql | No Comments » [ Popularity: 59% ]

Tags：编码.

MySQL实现编号自动增加的方法

2009-01-15 Posted in mysql | No Comments » [ Popularity: 60% ]

Tags：唯一编号.