Olaf,
That's a very broad question depending upon your exact requirements
to be honest. So long as you've considered file size limitations and
you've opted for a decent RAID system there's not too much more to worry
about, try and buy the fastest disks possible obviously i.e. 15,000 RPM
one
Olaf,
Thanks for the detailed answer.
So basically the limitations come from the OS and the file system used.
What is the best file system to use for mysql (not considering the filesize
limitations)?
Thanks
Olaf
The "best" is probably ZFS if you really are intent on make things huge,
http:/
samchk -dv tbl_name. If your large table is read-only,
> you can use myisampack to compress it. myisampack usually compresses a table
> by at least 50%, so you can have, in effect, much bigger tables.
>
> Thanks
>
> Visolve DB Team
>
> - Original Message -----
> Fr
. myisampack usually compresses a table by at
least 50%, so you can have, in effect, much bigger tables.
Thanks
Visolve DB Team
- Original Message -
From: "Olaf Stein" <[EMAIL PROTECTED]>
To:
Sent: Friday, December 29, 2006 4:14 AM
Subject: Max size and row numbers
CPU, 8GB Ram).
I just read that the max size for a table is 256TB in a default
installation. I have basically no experience with tables that big and mine
is potentially growing to several hundred million records.
First of all, are there theoretical limitations (if the 256TB are correct I
would be
would probably prefer to call it a limitation. :)
-Original Message-
From: schlubediwup [mailto:[EMAIL PROTECTED]
Sent: Monday, May 29, 2006 8:07 AM
To: mysql@lists.mysql.com
Subject: max size of TEXT columns
hi listers,
1. environment:
[EMAIL PROTECTED] ~> uname -a
Li
At 17:06 +0200 5/29/06, schlubediwup wrote:
2. problem
according do the mysql docu TEXT/BLOB fields depend solely on the db
environment and can grow to any length:
11.4.3. The |BLOB| and |TEXT| Types
The maximum size of a |BLOB| or |TEXT| object is determined by its type, but
"d
hi listers,
1. environment:
[EMAIL PROTECTED] ~> uname -a
Linux myhost.mydomain.com 2.6.16-1.2080_2.rhfc5.cubbi_suspend2 #1 Wed
Mar 29 12:54:32 CEST 2006 i686 i686 i386 GNU/Linux
[EMAIL PROTECTED] ~>
localhost.(none)> show variables like "version%";
+-+--
Yui Hiroaki <[EMAIL PROTECTED]> wrote on 08/24/2005 12:38:18 PM:
> Thank you for your reply.
>
> > sql>create table (test title longtext)TYPE=MyISAM;
> > sql>alter table test add fulltext (title);
>
> Your SQL above does not define the word long. How much
> character can I insert into "title"
Thank you for your reply.
> sql>create table (test title longtext)TYPE=MyISAM;
> sql>alter table test add fulltext (title);
Your SQL above does not define the word long. How much
character can I insert into "title" column?
Yui
What do you expedt the number in brackets to do? I cannot find any
Yui Hiroaki <[EMAIL PROTECTED]> wrote on 24/08/2005 10:57:20:
> I created table for fulltext. I publish SQL:
>
> sql>create table (test title longtext)TYPE=MyISAM;
> sql>alter table test add fulltext title (4);
>
>
> But title is so small to insert text.
> what biggest text I can insert tit
I created table for fulltext. I publish SQL:
sql>create table (test title longtext)TYPE=MyISAM;
sql>alter table test add fulltext title (4);
But title is so small to insert text.
what biggest text I can insert title column?
When I publish SQL: alter table test add fulltext title(4294967295)
Hristo,
thank you for the bug report. I broke the
:autoextend:max:2000M
feature when I added multiple tablespaces in 4.1.1.
The bug is fixed in 4.1.8.
Unfortunately, InnoDB does not automatically add 2000 MB files if you
specify the max. You have to add additional ibdata files manually, as
explai
Pattishall http://www.friendster.com
> -Original Message-
> From: Hristo Chernev [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 18, 2004 9:14 AM
> To: [EMAIL PROTECTED]
> Subject: innodb data file grew beyond the specified max size in config
>
> Hi all
>
>
Hi all
I converted my 6GB MyISAM database to Innodb using ALTER TABLE table TYPE =
INNODB. There was no errors in the err log and database is working ok.
But after stopping mysql server It refuse to start again complaining:
041118 16:55:45 mysqld started
041118 16:55:45 [Warning] Asked for 10485
[EMAIL PROTECTED]
Subject: Re: Max size
Date: Mon, 18 Aug 2003 23:43:19 -0700
On Mon, Aug 18, 2003 at 02:33:04PM -0500, Miguel Perez wrote:
>
> I have an ibdata file that its size is 4.5GB, and it will increase
> every day the max size of the hard disk is about 330GB, the question
> is shoul
On Mon, Aug 18, 2003 at 02:33:04PM -0500, Miguel Perez wrote:
>
> I have an ibdata file that its size is 4.5GB, and it will increase
> every day the max size of the hard disk is about 330GB, the question
> is should I split this ibdata file in several files in a way that I
> can
Hi list:
I would like to know some of the best practices to manage innodb tables. I
have an ibdata file that its size is 4.5GB, and it will increase every day
the max size of the hard disk is about 330GB, the question is should I
split this ibdata file in several files in a way that I can
You can see your max table size at the row "Max datafile length:
4294967294". This means that your UsedData table's max size is 4G. If
you want to change it you have to use alter table command with the
option max_rows. For example "ALTER TABLE UsedData MAX_ROWS = 100
Hi, this is my first post here, I hope it's easily answered
I've got Mandrake Linux 9, with the ext3 file system
What is the absolute maximum table size I can have?
And what do I need to change to achive that?
I've spent half the night googling, and couldn't find a real answer
so now I th
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> On Tue, Oct 08, 2002 at 12:13:28PM -0400, Kevan
> Louou wrote:
> >
> > what is the index max size for mysql 4.0?
>
> What's the largest file your operating system will
> let you create?
>
Is your answer
On Tue, Oct 08, 2002 at 12:13:28PM -0400, Kevan Louou wrote:
>
> what is the index max size for mysql 4.0?
What's the largest file your operating system will let you create?
> is it possible to do replication with a master on linux and a slave
> on windows?
Yes.
> if yes
what is the index max size for mysql 4.0?
is it possible to do replication with a master on
linux and a slave on windows? if yes, how can I make
the slave work on linux if the master crashes?
thanks in advance
__
Post your
what is the index max size for mysql 4.0?
is it possible to do replication with a master on
linux and a slave on windows? if yes, how can I make
the slave work on linux if the master crashes?
thanks in advance
__
Post your
n the error code 136 (HA_ERR_INDEX_FILE_FULL).
I think that it is the error code that the mi_write function of myisam/
mi_write.c has returned.
Are there any method or patch which change this maximum size by the safe
method?
I also think that I will shift to Windows2000 and MySQL4.0.
What max si
My Logs get pretty hefty with my PHP MySQL site, is there a Max log size or
something that will start another log file by date or when a certain size is
reached it's cleared. Had to ask
Cheers
-Original Message-
From: Gerald Jensen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001
On Tue, 27 Feb 2001, Markus H. Maussner wrote:
> does anybody know the limitations of mysql ? i am planing to make a
> big database. with big i mean something like 1,5TB ... the hardware
> seems not to be the problem (we get a big RAID for that, and our
> sysadmin sais that our linux system can ta
hi..
does annybody know the limitations of mysql ?
i am planing to make a big database. with big i mean something like
1,5TB ...
the hardware seems not to be the problem (we get a big RAID for that, and
our sysadmin sais that our linux system can take that much hdd space
(told me something of a
28 matches
Mail list logo
