Hi
im sorry for not good subject, forgive me
today i see my site's not load, after check, i see mysql is down, then try for start and restart,
then i see a table from basic site (myself hosting site) have 38GB size, (that was size from log sms)
then i try faster empty that,
now my problem is:
when i suspend same user, all other sites work fine,
but when i unsuspend same user, i see Slowly all site have error (cant connect to database), then i suspend same user, i see faster site's work fine.
Please help me
i do below action, but without different:
i have below log:
Please help me.
Thanks.
im sorry for not good subject, forgive me
today i see my site's not load, after check, i see mysql is down, then try for start and restart,
then i see a table from basic site (myself hosting site) have 38GB size, (that was size from log sms)
then i try faster empty that,
now my problem is:
when i suspend same user, all other sites work fine,
but when i unsuspend same user, i see Slowly all site have error (cant connect to database), then i suspend same user, i see faster site's work fine.
Please help me
i do below action, but without different:
/etc/rc.d/init.d/mysql stop
2) Repair all SQL databases:
myisamchk -r /var/lib/mysql/*/*.MYI
3) Start mysql again:
/etc/rc.d/init.d/mysql start
mysqlcheck --all-databases -r #repair
mysqlcheck --all-databases -a #analyze
mysqlcheck --all-databases -o #optimize
mysqlcheck -A --auto-repair
but again i have same problem,repair and optimize from phpmyadmun
i have below log:
131030 19:03:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 2002124 user: 'user_new'
131030 19:03:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 2002123 user: 'user_new'
131030 19:03:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 2002122 user: 'user_new'
131030 19:03:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 2002121 user: 'user_new'
131030 19:03:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 2002120 user: 'user_new'
131030 19:03:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 2002119 user: 'user_new'
131030 19:03:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 2002117 user: 'user_new'
131030 19:03:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 2002116 user: 'user_new'
131030 19:03:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 2002114 user: 'user_new'
131030 19:03:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 2002113 user: 'user_new'
131030 19:03:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 2002112 user: 'user_new'
131030 19:03:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 2002111 user: 'user_new'
131030 19:03:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 2002110 user: 'user_new'
131030 19:03:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 2002109 user: 'user_new'
131030 19:03:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 2002108 user: 'user_new'
131030 19:03:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 2002106 user: 'user_new'
131030 19:03:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 2002105 user: 'user_new'
131030 19:03:51 [Warning] /usr/sbin/mysqld: Forcing close of thread 2002104 user: 'user_new'
131030 23:01:01 [Warning] /usr/sbin/mysqld: Forcing close of thread 12 user: 'root'
131030 23:01:01 [Warning] /usr/sbin/mysqld: Forcing close of thread 10 user: 'root'
131030 23:01:01 [Warning] /usr/sbin/mysqld: Forcing close of thread 8 user: 'root'
131030 19:59:36 InnoDB: Starting shutdown...
131030 19:59:38 InnoDB: Shutdown completed; log sequence number 940323341
131030 19:59:38 [Note] /usr/sbin/mysqld: Shutdown complete
Please help me.
Thanks.