Re: mysql + xmpp server +test loading - did I reach any physical limit?

[gigi kent]

Hi Rick,

I'll be dealing with those subqueries later, thank you for all the explanations.

Totally lost now... Have applied some fixes as you suggested, and now here is what percona has to say about my queries in the slow log - http://pastebin.com/1RZ9F4XE. There are no slow queries (10+ seconds) ?!

Where the slow log ran as usual:


log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 0
min_examined_row_limit = 0
log-queries-not-using-indexes

It seems like long_query_time = 0 is the only way mysql is willing to output anything meaningful on my machine.

However, nothing has changed regarding server's output: http://pastebin.com/6xC7WJet. (search for 'method took' to see the time passed between DB query initiation and catch block getting hit)



So... what is going on ? I am pretty sure these results both refer to the right DB slow logs and to the right session of testing.


PS. tig_pairs now has

PRIMARY KEY (nid, pkey),
key uid (uid),
key nid (nid),
key pkey (pkey),

You did mention that innoDB really needed a primary key,right ? I have added it like this, the other 3 keys where there already.


Thanks again!