List:General Discussion« Previous MessageNext Message »
From:Paul Halliday Date:March 14 2006 11:14am
Subject:Merge tables.
View as plain text  
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.
Thread
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