I have notices some slow queries showing up in my slow query log lately.
Two of these queries are relatively simple queries using the index of
their respective tables. Both of these tables are very large and I
suspect this to be the problem. This problem appears to have started
within the last couple of months. These tables grow in data daily.
Table 1
--------
Rows: 17,794,256
Index Size: 511,596,544
Table 2
--------
Rows: 43,513,707
Index Size: 1,009,502,208
Is there anything that I can do? I have optimized the tables, but it did
not appear to help. Is there a limit to MySQL efficiency and table size?
--
Ed Pauley II
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
