Как проверить нагрузку VPS

Здравствуйте!

Как-то начали жаловаться пользователи форума vBulletin 3.8.6, что бывает ловят ошибки базы данных, сами ошибки приведены ниже. Форум уже три дня вдоль и поперек излапатил, точное решение не нашел.

Как я только не плясал с бубном так ничего и не добился ... Я в тупике :(

Что было сделано мною:

- обратился к хостеру, от которого получил ответ:

Все эти ошибки указывают на недостаток памяти ( Cannot allocate memory in )

C уважением, системный администратор

- проверил память php memory_limit=128M

Что еще можно предпринять?

У меня форум установлен на VPS,

Процессор 3000 Mhz

Оперативная память 1200 MB

Одновременно на форуме сидит не более 50 человек

Подскажите пожалуйста, что еще можно предпринять, как можно проверить нагрузку на оперативную память?

WHERE post.postid IN (0,198924,203242)

ORDER BY post.dateline;

Ошибка MySQL : Can't find file: './nazvanie/vB_editlog.frm' (errno: 12)

Номер ошибки : 1017

Дата запроса : Thursday, March 24th 2011 @ 04:13:17 PM

Дата ошибки : Thursday, March 24th 2011 @ 04:13:18 PM

Скрипт : http://nazvanie-club.ru/showthread.php?t=10565

Реферрер : http://nazvanie-club.ru/showthread.php?t=10565

IP адрес : 94.179.19.127

Имя пользователя : sabid

Имя класса : vB_Database

Версия MySQL : 5.0.51a-24+lenny4

Еще одна ошибка

Invalid SQL:

SELECT

post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,

user.*, userfield.*, usertextfield.*,

icon.title as icontitle, icon.iconpath,

avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,

spamlog.postid AS spamlog_postid,

deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,

editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,

editlog.reason AS edit_reason, editlog.hashistory,

postparsed.pagetext_html, postparsed.hasimages,

sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,

sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,

IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid

FROM vB_post AS post

LEFT JOIN vB_user AS user ON(user.userid = post.userid)

LEFT JOIN vB_userfield AS userfield ON(userfield.userid = user.userid)

LEFT JOIN vB_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

LEFT JOIN vB_icon AS icon ON(icon.iconid = post.iconid)

LEFT JOIN vB_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vB_customavatar AS customavatar ON(customavatar.userid = user.userid)

LEFT JOIN vB_spamlog AS spamlog ON(spamlog.postid = post.postid)

LEFT JOIN vB_deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')

LEFT JOIN vB_editlog AS editlog ON(editlog.postid = post.postid)

LEFT JOIN vB_postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 2)

LEFT JOIN vB_sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 1 AND sigparsed.languageid = 2)

LEFT JOIN vB_sigpic AS sigpic ON(sigpic.userid = post.userid)

WHERE post.postid IN (0,4284,200131,200132,200134,200136,200137,200138, 200140,200141,200142,200144,200148,200149,200152,2 00163,4284)

ORDER BY post.dateline;

Ошибка MySQL : Can't find file: './nazvanie/vB_deletionlog.frm' (errno: 12)

Номер ошибки : 1017

Дата запроса : Friday, March 25th 2011 @ 12:36:23 PM

Дата ошибки : Friday, March 25th 2011 @ 12:36:23 PM

Скрипт : http://nazvanie-club.ru/showthread.php?t=1071

Реферрер : http://nazvanie-club.ru/forumdisplay.php?f=2076

IP адрес : 188.138.48.20

Имя пользователя : VIC

Имя класса : vB_Database

Версия MySQL : 5.0.51a-24+lenny4

Еще одна ошибка

Warning: require_once([path]/includes/class_hook.php) [function.require-once]: failed to open stream: Cannot allocate memory in [path]/includes/init.php on line 275

Fatal error: require_once() [function.require]: Failed opening required '/var/www/nazvanie/data/www/nazvanie-club.ru/includes/class_hook.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/nazvanie/data/www/nazvanie-club.ru/includes/init.php on line 275

Еще одна ошибка

Warning: file_get_contents([path]/includes/database_error_message.html) [function.file-get-contents]: failed to open stream: Cannot allocate memory in [path]/includes/class_core.php on line 998

Warning: vB_Database::require_once([path]/includes/functions_log_error.php) [vb-database.require-once]: failed to open stream: Cannot allocate memory in [path]/includes/class_core.php on line 1000

Fatal error: vB_Database::require_once() [function.require]: Failed opening required '/var/www/nazvanie/data/www/nazvanie-club.ru/includes/functions_log_error.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/nazvanie/data/www/nazvanie-club.ru/includes/class_core.php on line 1000

Еще одна при попытке отправить личное сообщение:

Warning: require_once([path]/includes/functions_user.php) [function.require-once]: failed to open stream: Cannot allocate memory in [path]/private.php on line 134

Fatal error: require_once() [function.require]: Failed opening required '/var/www/nazvanie/data/www/nazvanie-club.ru/includes/functions_user.php' (include_path='.:/usr/share/php:/usr/share/pear') in/var/www/nazvanie/data/www/nazvanie-club.ru/private.php on line 134

Еще одна ошибка

Invalid SQL:

SELECT

post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,

user.*, userfield.*, usertextfield.*,

icon.title as icontitle, icon.iconpath,

avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,

spamlog.postid AS spamlog_postid,

deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,

editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,

editlog.reason AS edit_reason, editlog.hashistory,

postparsed.pagetext_html, postparsed.hasimages,

sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,

sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,

IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid

FROM vB_post AS post

LEFT JOIN vB_user AS user ON(user.userid = post.userid)

LEFT JOIN vB_userfield AS userfield ON(userfield.userid = user.userid)

LEFT JOIN vB_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

LEFT JOIN vB_icon AS icon ON(icon.iconid = post.iconid)

LEFT JOIN vB_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vB_customavatar AS customavatar ON(customavatar.userid = user.userid)

LEFT JOIN vB_spamlog AS spamlog ON(spamlog.postid = post.postid)

LEFT JOIN vB_deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')

LEFT JOIN vB_editlog AS editlog ON(editlog.postid = post.postid)

LEFT JOIN vB_postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 2)

LEFT JOIN vB_sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 1 AND sigparsed.languageid = 2)

LEFT JOIN vB_sigpic AS sigpic ON(sigpic.userid = post.userid)

WHERE post.postid IN (0,203630,203676,203714,203754,203757,203763,20384 0,203861)

ORDER BY post.dateline;

Ошибка MySQL : File './nazvanie/vB_postparsed.MYD' not found (Errcode: 12)

Номер ошибки : 29

Дата запроса : Friday, March 25th 2011 @ 03:48:30 PM

Дата ошибки : Friday, March 25th 2011 @ 03:48:31 PM

Скрипт : http://nazvanie-club.ru/showthread.php?p=203861

Реферрер : http://nazvanie-club.ru/search.php?searchid=36196

IP адрес : 188.138.48.20

Имя пользователя : VIC

Имя класса : vB_Database

Версия MySQL : 5.0.51a-24+lenny4