Hi Shahryar, These pages may help : http://dev.mysql.com/doc/refman/5.0/en/optimization.html
The other command you may find useful is the OPTIMIZE table command documented here : http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -----Original Message----- From: Shahryar G. Hashemi [mailto:[EMAIL PROTECTED] Sent: Tuesday, 15 November 2005 8:52 AM To: mysql@lists.mysql.com Subject: MySQL 4.18 Performance Question Hello, We are running a MySQL 4.18 database as a read-only snapshot of an internal Sybase database. We have seen an increase in core tables where now we have several million records of data in the MySQL tables. Suddenly the SELECT queries we ran before which took few seconds are now taking much longer to run [10-12]. My questio is to know what performance issues are with MySQL 4.18 which we need to watch out for dealing with very large tables. Also as far as indexes is there an UPDATE STATISTICS command to make sure the indexes are performing properly? Thanks in advance. I am a Sybase/SQL Server guy who has been handed this task. So if I ask dumb question please bear with me. Yours, Shahryar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
