Очень высокая загрузка CPU
-
Сегодня возник следующий вопрос.
-Netxmsd очень сильно грузит систему и mysql
top - 12:17:32 up 1:16, 2 users, load average: 1.71, 1.67, 1.47
Tasks: 104 total, 2 running, 101 sleeping, 1 stopped, 0 zombie
Cpu(s): 54.6%us, 10.4%sy, 0.0%ni, 35.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 4117936k total, 197448k used, 3920488k free, 42456k buffers
Swap: 6377464k total, 0k used, 6377464k free, 71180k cachedPID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
4455 root 20 0 88112 4044 2212 S 79 0.1 10:34.03 netxmsd
4270 mysql 20 0 127m 18m 5268 S 51 0.5 7:59.36 mysqldнепонятно чем вызывается такая параноидальная активность.
Логи мускула смотрел вроде нечего страшного, нетхмс пуляет ему в табличку eventlog и все..
в логах нетхмс следующее
SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521534,52,1256808467,27,4,'Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521527,52,1256808467,27,4,''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521520,52,1256808467,27,4,''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521513,52,1256808467,27,4,''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521506,52,1256808467,27,4,''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521499,52,1256808467,27,4,''''''''''''''''''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521492,52,1256808467,27,4,''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521485,52,1256808467,27,4,''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521478,52,1256808467,27,4,'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''"): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[29-Oct-2009 12:27:47] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521535,52,1256808467,27,4,'Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521528,52,1256808467,27,4,''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521521,52,1256808467,27,4,''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521514,52,1256808467,27,4,''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521507,52,1256808467,27,4,''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521500,52,1256808467,27,4,''''''''''''''''''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521493,52,1256808467,27,4,''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521486,52,1256808467,27,4,''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''Database query failed (Query: INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (521479,52,1256808467,27,4,'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''"): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1старт нетхмс выглядит так:
/opt/netxms/bin/netxmsd -c /etc/netxmsd.conf
Using configuration file "/etc/netxmsd.conf"
Configuration file OK
[29-Oct-2009 12:32:15] Platform subagent "/opt/netxms/lib/libnsm_linux.so" successfully loaded
[29-Oct-2009 12:32:15] Database driver "/opt/netxms/lib/libnxddr_mysql.so" loaded and initialized successfully
[29-Oct-2009 12:32:15] Failed to load subnet object with id 13 from database
[29-Oct-2009 12:32:15] Failed to load subnet object with id 18 from database
[29-Oct-2009 12:32:15] Failed to load subnet object with id 23 from database
[29-Oct-2009 12:32:15] Failed to load subnet object with id 28 from database
[29-Oct-2009 12:32:15] Failed to load node object with id 12 from database
[29-Oct-2009 12:32:15] Failed to load node object with id 17 from database
[29-Oct-2009 12:32:15] Failed to load node object with id 22 from database
[29-Oct-2009 12:32:15] Failed to load node object with id 27 from database
[29-Oct-2009 12:32:15] Failed to load interface object with id 14 from database
[29-Oct-2009 12:32:15] Failed to load interface object with id 19 from database
[29-Oct-2009 12:32:15] Failed to load interface object with id 24 from database
[29-Oct-2009 12:32:15] Failed to load interface object with id 29 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 10 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 11 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 15 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 16 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 20 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 21 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 25 from database
[29-Oct-2009 12:32:15] Failed to load template object with id 26 from database
[29-Oct-2009 12:32:15] Inconsistent database: TemplateRoot object has reference to non-e xisting child object 25
[29-Oct-2009 12:32:15] Inconsistent database: TemplateRoot object has reference to non-e xisting child object 26
[29-Oct-2009 12:32:15] Listening for SNMP traps on UDP socket 0.0.0.0:162
[29-Oct-2009 12:32:15] NetXMS Server startedNetXMS Server V0.2.30 Ready
Enter "help" for command list or "down" for server shutdown
System Consolenetxmsd: [29-Oct-2009 12:32:15] Listening for client connections on TCP socket 0.0.0.0:4701
конфиг нетхмс выглядит так
#
# Sample configuration file for NetXMS server
##
# DBDriver
#
# Database driver to use
#
# UNIX example:
DBDriver = /opt/netxms/lib/libnxddr_mysql.so
#
# Windows example:
# DBDriver = mysql.ddr#
# DBServer
#
# Database server (ODBC source name for ODBC driver)
#
# Example:
DBServer = localhost#
# DBName
#
# Database name (not used by ODBC driver)
#
# Example:
DBName = ????#
# DBLogin
#
# Database user name
#
# Example:
DBLogin = ????#
# DBPassword
#
# Database name (not used by ODBC driver)
#
# Example:
DBName = ????#
# DBLogin
#
# Database user name
#
# Example:
DBLogin = ????#
# DBPassword
#
# Database user's password
#
# Example:
DBPassword = ????#
# LogFailedSQLQueries
#
# Controls logging of failed SQL queries.
# Possible values: "yes" (default) or "no".
#
# Example:
LogFailedSQLQueries = yes#
# LogFile
#
# Server's log file. To write log to syslog (or Event Log on Windows),
# use {syslog} as file name.
#
# Examples:
# LogFile = {syslog}
LogFile = /var/log/netxmsd.log
CodePage = utf8Что нибудь можете посоветовать?
-
-
Ja nekotoroe vremja nazad proboval stavit' CodePage utf8, vrode vse rabotalo. No eto bila ne poslednjaja versija, 0.2.24 mozet. Poprobuju potestirovat' poslednjuju versiju s utf8.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login