You can try changing the myisam_data_pointer_size setting, but the
max_rows/avg_row_length should have worked.
Unless it's your OS restricting the mysql user to a 4GB file size. You can use ulimit or getrlimit to determine OS limits for a
user. If a user hits a limit imposed by the OS, I think it issues a segfault.
----- Original Message -----
From: "Micah Stevens" <[EMAIL PROTECTED]>
To: "JP Hindin" <[EMAIL PROTECTED]>
Cc: <mysql@lists.mysql.com>
Sent: Thursday, March 22, 2007 5:24 PM
Subject: Re: max_rows query + SegFaulting at inopportune times
Oh, I didn't see the first comment. My mistake. It's likely a 32bit
integer size limit of some sort then. 32bit = 4gbytes
-Micah
On 03/22/2007 02:08 PM, JP Hindin wrote:
Micah;
In the first eMail I mentioned that I had excluded filesystem size limits
by manually producing a 14GB tar file. If it was only that simple :)
On Thu, 22 Mar 2007, Micah Stevens wrote:
This table size is based on your filesystem limits. This is a limit of
the OS, not MySQL.
-Micah
On 03/22/2007 01:02 PM, JP Hindin wrote:
Addendum;
On Thu, 22 Mar 2007, JP Hindin wrote:
Zero improvement. I used the following CREATE:
MAX_ROWS=1000000000;
At first I thought I had spotted the obvious in the above - the MAX_ROWS I
used is smaller than the Max_data_length that resulted, presumably MySQL
being smarter than I am. So I changed the MAX_ROWS to use larger numbers,
ala:
AVG_ROW_LENGTH=224,
MAX_ROWS=200000000000;
But after creation the 'SHOW STATUS' gives the following:
Create_options: max_rows=4294967295 avg_row_length=224
My guess is that MySQL has decided 4294967295 is the maximum table size
and ALTERs nor CREATE options are able to change this imposed limit. This
would explain why my ALTERs didn't appear to work, seg fault of the client
aside.
So I suppose the question now is - if MAX_ROWS doesn't increase the table
size, what will? Where is the limit that MySQL is imposing coming from?
Again, many thanks for anyone who can enlighten me as to what MySQL is
thinking.
JP
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
