Hi,thanks for the great reply.
As for the Select * from stats_sit ,....
I didn't understand the buttom line, are you suggesting to define the second index with the 3 fields?
As for the 1000 connections, we are having a great load of xml over http messages from web servers. To simulate this we use Jmeter which is a tool to simulate the load. We have a tomcat on the client side which receives the messages and passes them to our server process which then queries the MySql DataBase.
As for the stats_applications query, i need to check this out, it is weird since the name is a string - i don't understand where the numbers are from.
This is the show status result:
'Name','Engine','Version','Row_format','Rows','Avg_row_length','Data_length','Max_data_length','Index_length','Data_free','Auto_increment','Create_time','Update_time','Check_time','Collation','Checksum','Create_options','Comment'
'stats_applications','InnoDB','10','Compact','73','224','16384','0','16384','0','[
NULL]','2010-03-09 07:27:10','[NULL]','[NULL]','latin1_swedish_ci','[NULL]','',''
[\code]
As for the stats_filesystem, there is no where cause there is one line.
Is that a problem?
As for the alerts-links, what do you mean by:
Ouch! There is nothing tying the two table together! ??
Are you referring to a foreign key not defined between them?
thanks,