And here is mysqladmin extended-status:
Sat Aug 18 20:42:36 EDT 2001
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 1 |
| Aborted_connects | 4 |
| Bytes_received | 506705297 |
| Bytes_sent | 1589198590 |
| Connections | 89251 |
| Created_tmp_disk_tables | 1859 |
| Created_tmp_tables | 43029 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 12740 |
| Handler_read_first | 44655 |
| Handler_read_key | 18085689 |
| Handler_read_next | 69927645 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 17966016 |
| Handler_read_rnd_next | 2054877876 |
| Handler_update | 451180 |
| Handler_write | 4673447 |
| Key_blocks_used | 7793 |
| Key_read_requests | 71410524 |
| Key_reads | 130044 |
| Key_write_requests | 50890 |
| Key_writes | 47211 |
| Max_used_connections | 38 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 64 |
| Open_files | 104 |
| Open_streams | 0 |
| Opened_tables | 1257 |
| Questions | 3119318 |
| Select_full_join | 1877 |
| Select_full_range_join | 0 |
| Select_range | 212213 |
| Select_range_check | 0 |
| Select_scan | 770836 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 197036 |
| Sort_rows | 211230004 |
| Sort_scan | 360526 |
| Table_locks_immediate | 2789199 |
| Table_locks_waited | 6802 |
| Threads_cached | 0 |
| Threads_created | 89250 |
| Threads_connected | 4 |
| Threads_running | 2 |
| Uptime | 47612 |
+--------------------------+------------+
Key Reads/Key Requests = 0.001821 (Cache hit = 99.998179%)
Queries/second = 65.515 (/hour = 235855.347)
Slow Queries/second = 0.000 (/hour = 0.000)
Uptime = 13 hr 13 min 32 sec
Thanks for any help you can offer!!!
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
----- Original Message -----
From: "Halldor Utne" <[EMAIL PROTECTED]>
To: "Ryan Shrout" <[EMAIL PROTECTED]>
Sent: Saturday, August 18, 2001 2:52 PM
Subject: Re: MySQL Spawns Many Processes and Uses 100% CPU! PART #2
> On Sat, 18 Aug 2001, Ryan Shrout wrote:
> > CONTINUED FROM PART #1
> > While this happens, I was able to do a "mysqladmin processlist" command
and here is the result:
>
> What is your current :
> mysqladmin variables?
> mysqladmin status?
>
> You have a lot of Locked states, also querys like "%something..%" which
> is an good way to slow down the box
>
> Noticed in your email earlyer that your scsi preformance was low, but I
> assume you fixed that.
>
> Halldor
> Amd 1.2Ghz user
>
---------------------------------------------------------------------
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
