Arkadaşlar bir problem var galiba nedir. ne yapmam gerekiyor acaba.
---------------------------------------------------------------------------------------
Hello,
The user 'wwwxxx' on server Tribute has been suspended for excessive resource abuse. The database looks to have been causing server outages. Below are the logs and ways to optimize;
====================================================================================================
top - 17:54:50 up 6 days, 5:56, 1 user, load average: 21.36, 10.64, 5.12
Tasks: 248 total, 20 running, 228 sleeping, 0 stopped, 0 zombie
Cpu(s): 5.5% us, 5.5% sy, 22.1% ni, 61.8% id, 4.9% wa, 0.0% hi, 0.2% si
Mem: 4143580k total, 3972948k used, 170632k free, 245940k buffers
Swap: 6289408k total, 4320k used, 6285088k free, 2576876k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
14411 mysql 15 0 233m 196m 3420 S 151 4.9 930:42.78 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --use
| 888672 | wwwxxx_forum | localhost | wwwxxx_forums | Query | 195 | Copying to tmp table | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las |
| 888687 | wwwxxx_forum | localhost | wwwxxx_forums | Query | 188 | Copying to tmp table | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las |
| 888692 | wwwxxx_forum | localhost | wwwxxx_forums | Query | 184 | Copying to tmp table | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las |
| 888696 | wwwxxx_forum | localhost | wwwxxx_forums | Query | 182 | Copying to tmp table | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las |
| 888698 | wwwxxx_forum | localhost | wwwxxx_forums | Query | 179 | Copying to tmp table | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las |
| 888702 | wwwxxx_forum | localhost | wwwxxx_forums | Query | 176 | Copying to tmp table | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las |
| 888739 | wwwxxx_forum | localhost | wwwxxx_forums | Query | 150 | Copying to tmp table | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las |
| 888742 | wwwxxx_forum | localhost | wwwxxx_forums | Query | 149 | Copying to tmp table | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las |
| 888782 | wwwxxx_forum | localhost | wwwxxx_forums | Query | 110 | Copying to tmp table | SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.las |
====================================================================================================
First and foremost, you may need to optimize your tables. The frequency depends on the size and usage of the database, but most databases would benefit from doing something like this on a yearly basis: a) Enter your phpMyAdmin/MySQL control panel. Click on the database (not the table, the database name), and on the right hand column your tables should be listed. Scroll down till you see the “Check all” link. Click on that link, make sure all database tables are checked and then from the dropdown next to it, and carefully select “Optimize table”.
Additionally, adding indexes to your table(s) may improve performance. If you're not sure what you're doing, it's best not to modify any table; caution is recommended. There are various articles (
http://www.whenpenguinsattack.com/2006/03/11/optimizing-mysql-tables/). It may be best to google for something like [Your Software Name] MySQL indexes" for suggestions.
Wordpress Users: (
http://wordpress.org/): It is important to keep up to date with this software; vulnerabilities have been found in past versions. Regardless, installing the "Wordpress Cache" plugin can greatly reduce resource usage and improve performance (
http://wordpress.org/extend/plugins/wp-cache/). If you're not using the current version of Wordpress, keep in mind that v2.1+ is much faster than older versions.
Mambo Users: (
http://www.mamboserver.com/): As of May 2007, the current version is 4.6.2. Older versions likely have security issues. It is important to update to the current version (
http://mamboxchange.com/frs/?group_id=5), especially since Mambo/Joomla is an extremely popular exploit target due to the widespread use of this software.
Joomla Users: (
http://www.joomla.org/) As of May 2007, the current version is 1.0.12. Older versions have critical security issues, and must be upgraded to the current version (
http://dev.joomla.org/content/blogcategory/21/86/). Mambo/Joomla is an extremely popular exploit target due to the widespread use of this software. You may want to look at a plugin that optimizes the tables (
http://forum.joomla.org/index.php?topic=160051.msg771662).
osCommerce: (
http://www.oscommerce.com/). You may want to search for "oscommerce speed optimize" on Google.
Regards,
Adam D.
Network Security Administrator
http://www.hostgator.com/mailpolicy.shtml
http://www.hostgator.com/support.shtml
http://www.hostgator.com/tos.shtml
1-866-96-GATOR (42867)