On Mon, Jan 24, 2011 at 6:43 PM, Gavin Towey <gtowey@stripped> wrote:
> If you show the EXPLAIN SELECT .. output, and the table structure, someone
> will be able to give a more definite answer.
Thanks for the reply Gavin. I actually did place this info in my very first
message on this thread, along with my basic table structure and server
version. Myself and others have just stopped keeping the full,
deeply-nested, quoted thread inside all subsequent messages which is why you
probably haven't seen it.
However, here is the EXPLAIN SELECT from the first message (reformatted for
possible_keys: messages_fk, employee_idx
Extra: Using where; Using temporary; Using filesort
Anyhow, having now copied these tables to another server (MySQL 5.1) and
done some tests (bumping up innodb_buffer_pool_size and playing with
innodb_flush_log_at_trx_commit for my writes and a few other knobs) it is
simply that these somewhat large tables need lots of RAM to perform well,
just as Reindl Harald originally pointed out.
Thanks again for the help everyone!