query
>
> Just a thought, did you try running Optimize Table from the MySQL
> Administrator. I'm thinking that when you restarted it re-examined
the
> table statistics and was able to pick a better index.
> On Wed, January 17, 2007 14:31, John Anderson said:
_file_size=128M
innodb_additional_mem_pool_size=32M
innodb_thread_concurrency=16
innodb_commit_concurrency=4
innodb_flush_method=O_DIRECT
innodb_open_files=8192
innodb_sync_spin_loops=32
innodb_thread_sleep_delay=1000
innodb_autoextend_increment=1024M
innodb_file_per_table=TRUE
[client]
socket=/tmp/mysql.sock
John Anderson
Greetings,
It seems the lists.mysql.com imposes a 50KB limit on messages, so this
message will be sent in two parts. Thanks for your patience.
I'm in the process of converting most of my databases from MyISAM to
InnoDB, and I've come across the most peculiar problem. It seems that
after r
