Hi.
I got an error when I use alter statement to modify an innodb's table
structure. The error no is 1114 and the detail information is
ERROR 1114 (HY000): The table '#sql-4c0_1' is full.
Here is my table's structure.
mysql> show create table t1;
+---+---
No advice? Anyway after monitoring slow queries for few days, I found most
likely the following queries caused bad performance and locked table for
long time:
LIMIT 16780, 20
A big offset! Even the index is properly used.
After restricting offset value within the software, eg, return er
At 09:36 AM 11/11/2008, you wrote:
Thanks for the answer.
Maximum five users will work. The machine on which I am testing is the
minimum configuration my client has. Attached is the "My.ini" file.
.
Rohit.
> Date: Tue, 11 Nov 2008 16:21:07 +0100
> From: [EMAIL PROTECTED]
> Subject: R
I have only 3 things worth mentioning:
You might want to lower max_connections... wouldn't want someone to
actually start *using* 100 connections on a desktop box that only has
256MB RAM to begin with... it'll be in swap instantly (if it isn't
already, before you've even started MySQL).
Why InnoD
Thanks for the answer.
Maximum five users will work. The machine on which I am testing is the minimum
configuration my client has. Attached is the "My.ini" file.
.
Rohit.
> Date: Tue, 11 Nov 2008 16:21:07 +0100
> From: [EMAIL PROTECTED]
> Subject: Re: Tuning a MySQL desktop database
>
Rohit,
RP Khare wrote:
> We are testing MySQL in production environment with real data. When the
> application is ready and all tests have been conducted well, we will finally
> migrate to MySQL Enterprise.
>
> At present our application is running on a desktop machine with MySQL 5.1
> Commun
Yep.
Per Jessen wrote:
John Meyer wrote:
I'm trying to help out a friend with repairing myisam tables. Does
anybody know the best freeware solutions if CHECK TABLE and REPAIR
TABLE don't do the job?
Did you try myisamchk ?
/Per Jessen, Zürich
--
Pueblo Bicycling
http://www.
