Mohamed Badri wrote:
Hi,
just had a problem with a myisam table who reached 4GB of data,
I increased the number of rows by doing :
ALTER TABLE foo MAX_ROWS=10
This is EXACTLY what you want:
http://www.peerfear.org/rss/permalink/2004/10/16/MySQLAndALTERTABLEGuiltyAsCharged
thank you for the links,
I can't change system variables at runtime, so the only choice I have
is, probably, to stop mysql server set variables and then
run another ALTER TABLE. ;-(
I'm going to siwtch to mysql4 as soon as possible.
Selon Kevin A. Burton [EMAIL PROTECTED]:
Mohamed Badri
Mohamed Badri wrote:
thank you for the links,
I can't change system variables at runtime, so the only choice I have
is, probably, to stop mysql server set variables and then
run another ALTER TABLE. ;-(
I'm going to siwtch to mysql4 as soon as possible.
OH!... yeah... if you're on a 4 ver of
Hi Franz,
Check out
MAX_ROWS = #
and
AVG_ROW_LENGTH = #
options in http://www.mysql.com/doc/en/CREATE_TABLE.html
Set MAX_ROWS to a very very large number
You can set these with ALTER TABLE. See section 6.5.4 ALTER TABLE
Syntax using table options at the end. Use the MAX_ROWS
parameter and set
Hi!
On Nov 22, Robert Citek wrote:
Hello Sergei,
In going through the archives I found this message which is similar to an
issue I am currently having. You mention to Consult the manual for
details. I've check through the on-line manual:
http://www.mysql.com/doc/en/index.html
Hello Sergei,
In going through the archives I found this message which is similar to an
issue I am currently having. You mention to Consult the manual for
details. I've check through the on-line manual:
http://www.mysql.com/doc/en/index.html
specifically,
http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html
Repair with keycache - The repair code is using creating keys one by one
through the key cache. This is much slower than Repair by sorting.
It is going to take a long time to build an index on a table that big,
especially if you still have
Hello Jennifer,
Thanks for your reply.
At 02:07 PM 11/21/2002 -0800, Jennifer Goodie wrote:
http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html
I guess I have an older/different version of the doc's. I was using the
version that came with the Windows install of MySQL. Thanks for the URL.
At 04:41 PM 11/21/2002 -0600, Robert Citek wrote:
So, now I know that repair with keycache is slower than repair by
sorting. What can I do about that? That is, how can I make the repair
use sorting? I would have thought they would be part of the alter table
... syntax, but I haven't seen
Mike Baranski writes:
Question about this, when I do mysqladmin processlist, I get Repair with keycache as
the state, what exactly is this? Can this be optomized?
Mike.
P.S. Thanks for the gcc3 patch!
You are welcome !!
The above means that REPAIR table is using keycache. There is
10 matches
Mail list logo