Re: Improve MYSQL performance on large database

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,

Tuning a MySQL desktop database

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

Re: Tuning a MySQL desktop database

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 in

Re: freeware tools for repairing myisam tables

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:

RE: Tuning a MySQL desktop database

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 compsite columns for those join conditions to implement a Unique Constraint you will need to extract out the