There is a limit, but that is really limited to the hardware you are
running it on. You need to figure out what part of your system is
bottlenecking (disk I/O, RAM, CPU, or network I/O). Perhaps you have
to little RAM and/or your mysql configuration variables are not set
optimally. Too little RAM means more disk I/O, which then kind of
compounds itself.
On Jul 18, 2005, at 3:30 PM, Ed Pauley II wrote:
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/mysql?
[EMAIL PROTECTED]
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
