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
Community
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
To:
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
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
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: Re:
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
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;