PEAK XOOPS - Optimizeやるなら in englishin japanese

Top > Comments >News comment >Optimizeやるなら

Optimizeやるなら

Target News
Subject Maintenance for MySQL
Summary I've found many queries like DELETE FROM xp_session WHERE sess_updated < 1151347298; in /var/log/mysql_slow_queriesCertainly, the table of session is write/delete much frequently.It cause fragmentation of the table."mysqlcheck -o --all-databases" red...

List posts in the topic

normal Optimizeやるなら

msg# 1
depth:
0
Previous post - Next post | Parent - Children.1 | Posted on 2006/8/18 20:30
gusagi  Private   Posts: 5
アクセスの少ない時間の方が良いですよね（’’）
書き込み（Insert / Update / Delete）が頻繁に行われているテーブルにOptimizeをかけると、稀にですがテーブル内の情報がおかしくなる場合があった気がするので。（仕事で、そんな現象が。。。）
Votes:1 Average:10.00

Posts tree

  Advanced search

Login
Username or e-mail:

Password:

Remember Me

Lost Password?

Register now!