I have three tables show below which I am querying in a number of ways. e.g.
I have a report which lists number of reports provided compaired to number
which were due over the duration of the project.
I am puzzling over how to select the reports which were due and were
delivered during a week
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
So you want to mean that i can create (4TB/average_table_size) number
of tables in a linux(2.6 kernel) operating system assuming i have
that much hard disk space?
On 12/11/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
sunaram patir [EMAIL PROTECTED] wrote on 12/11/2005 12:10:52 AM:
hi
As I read the docs, yes! Is that going to be a limitation for you?
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
sunaram patir [EMAIL PROTECTED] wrote on 12/11/2005 05:50:58 AM:
So you want to mean that i can create (4TB/average_table_size) number
of tables in a linux
05:50:58 AM:
So you want to mean that i can create (4TB/average_table_size) number
of tables in a linux(2.6 kernel) operating system assuming i have
that much hard disk space?
On 12/11/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
sunaram patir [EMAIL PROTECTED] wrote
hi,
what is the maximum no of tables supported in a mysql database?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sunaram patir [EMAIL PROTECTED] wrote on 12/11/2005 12:10:52 AM:
hi,
what is the maximum no of tables supported in a mysql database?
That mostly depends on how large your hard drives are...
Except for the InnoDB engine (in default mode) and the NDB engine, all
other database engines use
The mysqlhotcopy perl script is failing fail when I try to back up
a database containing more than about 600 tables. The script appears
to be unable to lock that many tables before making the actual copy.
Have others experienced this same problem?
Is this a limitation of DBI, or of MySQL
-- max number of tables
The mysqlhotcopy perl script is failing fail when I try to back up
a database containing more than about 600 tables. The script appears
to be unable to lock that many tables before making the actual copy.
Have others experienced this same problem
(These questions are not limited by hardware, because
MdB if the need for speed is there, the revenues are too.)
MdB The numbers are:
MdB Thought-up number entries in one table:
MdB 100 000 000 000 (100 billion)
MdB Number of tables:
MdB 10 000
MdB (I could perhaps limit the number of entries to a
MdB maximum
At 13:36 +0200 28-10-2002, Victoria Reznichenko wrote:
MdB 2) How many entries can one single table have?
MdB (The absolute maximum)
There are no limits on number of rows.
What if the values for Primary Key run out? Can you use a unsigned bigint as Primary
Key?
I mean, we /have/ to store the
M,
Monday, October 28, 2002, 2:00:28 PM, you wrote:
MS At 13:36 +0200 28-10-2002, Victoria Reznichenko wrote:
MdB 2) How many entries can one single table have?
MdB (The absolute maximum)
There are no limits on number of rows.
MS What if the values for Primary Key run out?
You get Duplicate
Monday, October 28, 2002, 2:00:28 PM, you wrote:
MS At 13:36 +0200 28-10-2002, Victoria Reznichenko wrote:
MdB 2) How many entries can one single table have?
MdB (The absolute maximum)
There are no limits on number of rows.
MS What if the values for Primary Key run out?
You get Duplicate key
M,
Monday, October 28, 2002, 2:55:44 PM, you wrote:
Monday, October 28, 2002, 2:00:28 PM, you wrote:
MS At 13:36 +0200 28-10-2002, Victoria Reznichenko wrote:
MdB 2) How many entries can one single table have?
MdB (The absolute maximum)
There are no limits on number of rows.
MS What if the
is there, the revenues are too.)
The numbers are:
Thought-up number entries in one table:
100 000 000 000 (100 billion)
Number of tables:
10 000
(I could perhaps limit the number of entries to a
maximum of 9 000 000, but I need to have a hell of a
lot of tables.)
So here are the questions regarding MySQL:
1) How
Hi there!
Does anybody know whether it is possible for MySQL to handle round about 500-600
tables in one database or not (Win2k)? Where is the maximum?
I want to work with dynamically created tables.
Thanks,
Peter
Keine
Peter,
Monday, October 14, 2002, 10:38:06 AM, you wrote:
PS Does anybody know whether it is possible for MySQL to handle round about 500-600
tables in one database or not (Win2k)? Where is the maximum?
PS I want to work with dynamically created tables.
Number of tables in the database
For MySQL
http://www.webyog.com/sqlyog
- Original Message -
From: Peter Stöcker [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 14, 2002 1:08 PM
Subject: Number of tables
Hi there!
Does anybody know whether it is possible for MySQL to handle round about
500-600 tables
Hey,
On the same computer than before?
Fred
- Original Message -
From: Insanely Great [EMAIL PROTECTED]
To: Peter Stöcker [EMAIL PROTECTED]; MySQL List
[EMAIL PROTECTED]
Sent: Monday, October 14, 2002 2:08 AM
Subject: Re: Number of tables
Greetings...
I belive MySQL is powerful
Jose,
- Original Message -
From: JSL [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, September 02, 2002 11:49 PM
Subject: Maximum number of tables
- Original Message -
From: JSL [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 02, 2002 5
Subject: Maximum number of tables
Does anyone know what the maximum number of tables a
INNODB can store is?
Thanks,
José Lourenço
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
- Original Message -
From: JSL [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 02, 2002 5:05 PM
Subject: Maximum number of tables
Subject: Maximum number of tables
Does anyone know what the maximum number of tables a
INNODB can store is?
Thanks,
José
I saw in the MySQL documentation that the myISAM tables maximal size was 8
millions TB. But I couldn't find any information about the maximum number of
tables it can support. Can you give me this information ?
Thanks a lot
* Jean-Pierre Georgin
I saw in the MySQL documentation that the myISAM tables maximal size was 8
millions TB. But I couldn't find any information about the
maximum number of tables it can support. Can you give me this information
?
There is no limit in mysql, but there may be one in the OS
On Wed, 14 Aug 2002, Jean-Pierre Georgin wrote:
I saw in the MySQL documentation that the myISAM tables maximal size was 8
millions TB. But I couldn't find any information about the maximum number of
tables it can support. Can you give me this information ?
Bonjour Jean-Pierre,
each MyISAM
On Thu, 8 Aug 2002 03:02:40 -0700
Jeremy Zawodny [EMAIL PROTECTED] wrote:
btw:
I did a quick benchmark with mysql4 and its query caching running with
innodb.
Quite impressive, the app run with double the number of pages per second as
before.
Excellent. MySQL 4.0.{2,3} is working
On Fri, Aug 09, 2002 at 09:21:13PM +0200, Thomas Seifert wrote:
On Thu, 8 Aug 2002 03:02:40 -0700
Jeremy Zawodny [EMAIL PROTECTED] wrote:
Excellent. MySQL 4.0.{2,3} is working well for us too.
Is there 4.0.3 already somewhere to download?
Not yet. I believe there will be a 4.0.3 beta
On Tue, Jan 30, 2001 at 09:44:55AM -0600, johnny p. wrote:
I have several tables in my db that can potentially become *very*
large *very* quickly. I was thinking about creating a table for
each user of my database to keep data separate and allow each table
to be 4GB due to OS restrictions.
What is the largest number of table per database does MySQL support?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_4_0
/ Carsten
Carsten H. Pedersen
Keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
32 matches
Mail list logo
