I guess u had 2.5 million records splited into 1600 tables if iam not wrong :)
Why you split the tables to 1600 is there any specific count ?
Why you moved to merge table reason behind ?
Since 2.5 million records to 1600 is a huge count on nos of tables :( instead of one ;)
--Praj
On Tue, 14 Mar 2006 07:14:52 -0400
"Paul Halliday" <paul.halliday@stripped> wrote:
> Hi,
>
> One of the databases I use just switched to using merge tables and now
> my queries are painfully slow. One table, initially had about 2.5
> million records and now with the change this information is spread
> across about 1600 tables. A simple query, say select count(*) has gone
> from .04 to about 30 seconds, sometimes even longer.
>
> The OS is FreeBSD on a 3.1 GHz machine with a 1GB ram. Mysql is
> 4.1.15. My my.cnf currently has only one option:
>
> open_files_limit=24576
>
> If anyone could provide me with some other options I might try I would
> appreciate it.
>
> Thanks.
>
