MySQL テーブル最適化

FrontPage

[root@tomcat ~]# mysql -u root -p wordpress
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1793
Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show tables;
+-----------------------+
| Tables_in_wordpress   |
+-----------------------+
| wp_ak_twitter         |
| wp_comments           |
| wp_ktaisession        |
| wp_links              |
| wp_options            |
| wp_postmeta           |
| wp_posts              |
| wp_term_relationships |
| wp_term_taxonomy      |
| wp_terms              |
| wp_usermeta           |
| wp_users              |
+-----------------------+
12 rows in set (0.00 sec)

mysql> OPTIMIZE TABLE `wp_comments` , `wp_links` , `wp_options` , `wp_postmeta` , `wp_posts` , `wp_terms` , `wp_term_relationships` ,`wp_term_taxonomy` , `wp_usermeta` , `wp_users`
    -> ;
+---------------------------------+----------+----------+----------+
| Table                           | Op       | Msg_type | Msg_text |
+---------------------------------+----------+----------+----------+
| wordpress.wp_comments           | optimize | status   | OK       |
| wordpress.wp_links              | optimize | status   | OK       |
| wordpress.wp_options            | optimize | status   | OK       |
| wordpress.wp_postmeta           | optimize | status   | OK       |
| wordpress.wp_posts              | optimize | status   | OK       |
| wordpress.wp_terms              | optimize | status   | OK       |
| wordpress.wp_term_relationships | optimize | status   | OK       |
| wordpress.wp_term_taxonomy      | optimize | status   | OK       |
| wordpress.wp_usermeta           | optimize | status   | OK       |
| wordpress.wp_users              | optimize | status   | OK       |
+---------------------------------+----------+----------+----------+
10 rows in set (0.76 sec)

mysql>