2 gigs limits on MyISAM indexes?

[Frank Denis \(Jedi/Sector One\)]

  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 exactly 2 gigs.
  
  May it be related? Is there anything to do in order to recover the data
and to keep the server working?

  Best regards,
  
 -Frank.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 2 gigs limits on MyISAM indexes?

[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 exactly 2 gigs.
   May it be related? Is there anything to do in order to recover the data
   and to keep the server working?
   Best regards,
   -Frank.
   -- 
   MySQL General Mailing List
   For list archives: http://lists.mysql.com/mysql
   To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 2 gigs limits on MyISAM indexes?

[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 unauthenticated connections that never die. No
real query seems to be running any more.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 2 gigs limits on MyISAM indexes?

[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 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 unauthenticated connections that never die. No
real query seems to be running any more.
 

RE: 2 gigs limits on MyISAM indexes?

[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: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 unauthenticated connections that never die.
 No
 real query seems to be running any more.
 
 
 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/[EMAIL PROTECTED]
 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]