Re: Sending data in processlist

[CD Ben]

Hi James,
As you suggested the following changes are made but there are same problem.
innodb_buffer_pool_size=2000M
( innodb_buffer_pool_size / _ram ) = 2000M / 16384M = 0.12%
innodb_buffer_pool_reads=10025
(table_open_cache, innodb_open_files and table_definition_cache) all are 7000 now
innodb_log_buffer_size=50M
log_slow_queries = ON
slow_query_log = ON
thread_cache_size=0

Unable to set long_query_time = 2 its shows always 10.000000

I just want to tell you why I am using table1.....table7000
My application actually collect data current machines status for every hour and stored in each table (like tesr1,test2 etc.) and there are 7000 machines.

One more thing in my application i am using WCF function where every hour execute that function. The function use parrallel process each time send 50 record to process. In my application log the error show thread termrnated.

Then I see in mysql processlist there are the "sending data" status.