35700 thold -> thold is tooo slow

[killshoot]

Hi all,

I've now 35700 thold.

-> PA 2.0
-> Thold 0.3.9
-> MySQL 5.0.45

Most of the time is used by thold tod do this SQL request (not complete, issued with "show processlist" into mysql):

Code: Select all

SELECT thold_data.cdef, thold_data.rra_id, thold_data.data_id, thold_data.lastread, thold_data.oldva

This request ususally need between 110 and 143 seconds.

Is it possible to do anything? I'm a SQL Noob...

Thank in advance.


Vince

With told disabled :
04/18/2008 11:15:29 AM - SYSTEM STATS: Time:27.7242 Method:spine Processes:8 Threads:12 Hosts:803 HostsPerProcess:101 DataSources:57056 RRDsProcessed:21094

With thold enabled:
04/18/2008 03:18:33 PM - SYSTEM STATS: Time:211.5512 Method:spine Processes:8 Threads:12 Hosts:803 HostsPerProcess:101 DataSources:57056 RRDsProcessed:21272


My.cnf file :

[client]
port = 3306
socket = /var/lib/mysql/mysql.sock

[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 128M
set-variable = max_connections=300
tmp_table_size = 128M

thread_concurrency = 8

log-bin=mysql-bin

server-id = 1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

[kyosanim]

on my installation this helped:

Code: Select all

ALTER TABLE `graph_templates_item` ADD INDEX ( `task_item_id` );

http://forums.cacti.net/viewtopic.php?t=24241

[killshoot]

Thank you for you answer.

I've already seen this post and add this index but without improvement

[killshoot]

ok after some investigation I can say that mysql is not the problem.

The problem come from thold. I fact thold run only with one tread thus now parallel processing from thold.

Is it possible to implement php multi-thread with thold ? I've see that it exist some strategie for php multi-threading :

http://www.alternateinterior.com/2007/0 ... n-php.html

Any idea?

[mcutting]

I have the same problem. THOLD is using a single poller, and is extremely slow. My polling takes around 20 seconds - with THOLD enabled, it's now 79s plus !