List:General Discussion« Previous MessageNext Message »
From:Prasanna Raj Date:March 14 2006 11:29am
Subject:Re: Merge tables.
View as plain text  
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 ;)


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.
Merge tables.Paul Halliday14 Mar
  • Re: Merge tables.Martijn Tonies14 Mar
  • Re: Merge tables.Prasanna Raj14 Mar
  • Re: Merge tables.Martijn Tonies14 Mar
    • Re: Merge tables.Alec.Cawley14 Mar
    • Re: Merge tables.Paul Halliday14 Mar
      • Re: Merge tables.Alec.Cawley14 Mar
        • Re: Merge tables.nigel wood14 Mar
          • Re: Merge tables.Alec.Cawley14 Mar
          • Permissions block database creationDoug Pinkerton14 Mar
            • RE: Permissions block database creationMarciano [Intercol]14 Mar
            • Re: Permissions block database creationКосов Евгений14 Mar
  • Re: Merge tables.Martijn Tonies14 Mar