Re: 2 gigs limits on MyISAM indexes?

2005-01-28 Thread Mat
What Operating System are you running this on? Also, is there anything in the errorlog? Is there a limit on the size of .MYI files? I have a database that worked flawlessly until today. I can't restart it, it immediately freezes. I noticed that the .MYI file of a table has reached

Re: 2 gigs limits on MyISAM indexes?

2005-01-28 Thread Frank Denis \(Jedi/Sector One\)
On Fri, Jan 28, 2005 at 04:00:24PM +, Mat wrote: What Operating System are you running this on? Linux 2.6, 64 bits. MySQL 4.1.9. Also, is there anything in the errorlog? Nothing, but as soon as I restart the server, it enters a strange state where all slots are full with

Re: 2 gigs limits on MyISAM indexes?

2005-01-28 Thread Mat
This may be of use to you: http://dev.mysql.com/doc/mysql/en/table-size.html It appears that there is no limit in MySQL itself, but maybe in the unlying operating system. Frank Denis (Jedi/Sector One) wrote: On Fri, Jan 28, 2005 at 04:00:24PM +, Mat wrote: What Operating System are you

RE: 2 gigs limits on MyISAM indexes?

2005-01-28 Thread Donny Simonton
What does the error log say? Anything? Donny -Original Message- From: Frank Denis (Jedi/Sector One) [mailto:[EMAIL PROTECTED] Sent: Friday, January 28, 2005 10:42 AM To: Mat Cc: mysql@lists.mysql.com Subject: Re: 2 gigs limits on MyISAM indexes? On Fri, Jan 28, 2005 at 04:00