AZ9009ZA的专栏

USE information_schema; SELECT TABLE_SCHEMA,TABLE_NAME,DATA_LENGTH/1024/1024,INDEX_LENGTH/1024/1024,TABLE_ROWS FROM TABLES ORDER BY TABLE_SCHEMA;   DATA_LENGTH/1024/1024：数据长度INDEX_LENGTH/1024/1024：索引长度

<br />实现三台主服务器的MySQL数据库同步到一台从服务器<br /> <br />一、相关配置文件：<br /> <br />主一：<br />[mysqld] server-id = 1 log-bin=/data/mysql_log/mysql_bin binlog-do-db=logdb binlog-ignore-db=mysql<br />赋权<br />GRANT FILE,SELECT,REPLICATION SLAVE ON *.* to 'repl'@'192.168.1.

<br />需求：在某些活动结束时，需要在某个时间点及时统计查询游戏数据。<br /> <br />实现：两种方法<br /> <br />一、使用mysql.exe+at/计划任务<br /> <br />D:/mysql/bin/mysql.exe  -u"username" -p"password" dbname --execute="delete from table1;select * from table2" >> c:/result.txt<br /> <br />    打开指定数据库，并执