RE: Tuning a MySQL desktop database

2008-11-09 Thread Martin Gainty
Quiesce ALL slaves if you have master/slave DB's Once you've implemented explain plans..check any SQL statements which produce Full Table Scans If so You'll want to implement Indexes on columns for those join conditions to implement a Unique Constraint you will need to extract out the data and

Re: freeware tools for repairing myisam tables

2008-11-09 Thread Per Jessen
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 -- MySQL General Mailing List For list archives: http://lists.mysq

Re: Tuning a MySQL desktop database

2008-11-09 Thread Salah Nait-Mouloud
Hello, Here, you can get some help: http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/ Regards. Salah NAIT-MOULOUD www.echovox.com | www.m-boost.com On Sun, Nov 9, 2008 at 12:33 PM, RP Khare <[EMAIL PROTECTED] > wrote: > > We are testing MySQL

Tuning a MySQL desktop database

2008-11-09 Thread RP Khare
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 Edition installed on it. MySQL 5

Re: Improve MYSQL performance on large database

2008-11-09 Thread Salah Nait-Mouloud
Hello, Here, you can get some help: http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/ Regards. Salah NAIT-MOULOUD www.echovox.com | www.m-boost.com On Sat, Nov 8, 2008 at 7:08 AM, Guillermo Nardoni <[EMAIL PROTECTED]>wrote: > Hello everyone,