Hi Howard, I am trying to think of ideas. I have several databases with tables over 1.4G and rows still add quickly. How about available descriptors, what are these values: | Open_tables | 2738 | | Open_files | 5013 | | Open_streams | 0 | | Opened_tables | 81542 | | Questions | 31719361 | | this is a problem, I have 81542 opened tables, this sever needs more file descriptors. (I will look at this right away!, but my server is still running pretty well.)
Maybe you could include the output from show variables and show status? How fast is your SCSI drive subsystem, I assume you are using 7200 RPM SCSI drives at least? Cordially, Ken ----- Original Message ----- From: "mysql mailing list user" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 19, 2002 9:29 AM Subject: Re: Optimization And Memory Size > > You have written the following: > > I have a mysql database table that is currently 1.5G in size with well over > a > million records. It is running on a twin pentium 3 1G processor machine with > SuSE Linux version 1.4. > > Recently inserts have become VERY slow (several seconds). As I am adding > around 7K new fields a day, this is becoming a big problem. > > I recently increased the machine memory from 512K to 2G at some expense! It > made no difference. I am using the HUGE version of my.cnf as shipped. > > Anybody got any ideas how to speed things up. Why did the memory increase > not help at all??? > > Howard > > > > -------------------------------------------------------------------- - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php