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
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
>
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.
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
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
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
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;
+---+---
