Hi everyone,
I'm running MySQL 4.0.18 on Debian with a 2.6 linux kernel using ext3 as
the underlying filesystem for the database storage.
I currently have some InnoDB tables with the following structure:
Log_20060101 {
Monitor_id medium int,
Timestamp
would expect the use of thousands of tables effectively to disable
MySQL's caching capability, which is one of the biggest performance
boosters.
Alec
John McCaskey [EMAIL PROTECTED]
13/01/2006 17:20
To
MySQL mysql@lists.mysql.com
cc
Subject
Huge number of tables with InnoDB
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, January 13, 2006 9:41 AM
To: John McCaskey
Cc: MySQL
Subject: Re: Huge number of tables with InnoDB
To reply to this, I think we have to understand why you have chosen to
split the tables at all. It seems to me
performance
boosters.
Alec
"John McCaskey" [EMAIL PROTECTED]
13/01/2006 17:20
To
"MySQL" mysql@lists.mysql.com
cc
Subject
Huge number of tables with InnoDB
Hi everyone,
I'm running MySQL 4.0.18 on Debian with a 2.6 linux kernel using ext3 as
the u