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
