- 博客(5)
- 问答 (1)
- 收藏
- 关注
RSS订阅原创 读Effective Mysql:optimizing SQL Statements 笔记之SHOW SLAVE STATUS
[code="sql"]show master logs;+---------------+------------+| Log_name | File_size |+---------------+------------+| binlog.000011 | 1073742011 | | binlog.000012 | 1073742164 | | binlo...
2013-01-30 22:05:05
171
原创 mysql获取数据库表最后更新时间，update_time 为null (update_time innodb)
引用http://blog.csdn.net/zhy1991/article/details/7554812http://www.busfly.net/csdn/post/mysql-show-get-database-info.html[quote]In the MySQL "information_schema" database is a table called "TABLES" ...
2013-01-29 23:21:36
1121
原创 mysql 更改my.cnf 慢查询日志
[b]冷备[/b]，定期备份MySQL数据库的配置文件my.cnf,这样有利于恢复操作。1，开启MYSQL的慢查询日志首先在my.cnf配置里面加入慢查询配置，然后建立慢查询的日志文件，并把用户和组修改为mysql，最后重启mysqld。[quote]vim /etc/my.cnf# 在配置文件的[mysqld]下面加入以下几行log-slow-queries=/var/log...
2013-01-29 19:36:13
656
原创 读Effective Mysql:optimizing SQL Statements 笔记之max_heap_table_size
The total size of a MEMORY storage engine table can be determined by the SHOW TABLE STATUS command and the INFORMATION_SCHEMA.TABLES table. For additional reference, a MEMORY storage engine table...
2013-01-25 23:40:41
90
原创 读Effective Mysql:optimizing SQL Statements 笔记
http://effectivemysql.com/downloads/words 获取数据源CREATE CHEMA IF NOT EXISTS book;use book;CREATE TABLE source_words( word VARCHAR(50) NOT NULL; index (word)) ENGINE = MyISAM;LOAD DATA LO...
2013-01-19 23:19:55
208
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人