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
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:
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
http://www.peer
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 i
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_
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
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.
>Rep
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 questio
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. Ther
10 matches
Mail list logo
