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]

Reply via email to