List:General Discussion« Previous MessageNext Message »
From:Ilya Obshadko Date:June 16 1999 5:12pm
Subject:Re: inadequate performance (3.22.20a)
View as plain text  
On Wed, 16 Jun 1999, Sasha Pachev wrote:

> > I've noticed a strange loss in performance of Mysql (FreeBSD 3.2-STABLE,
> > Dual P-II-333). Some SELECT queries take about 40 seconds, and processor
> > load is about 98%! Maybe this is a known situation, please let me know if
> > anybody had such problems...
> > 
> Is this reproducable?

This is a stable situation :(
 
> When this happens again ( or when you reproduce it), run mysqladim
> extented-status and post the results.

+--------------------------+---------+
| Variable_name            | Value   |
+--------------------------+---------+
| Aborted_clients          | 0       |
| Aborted_connects         | 0       |
| Created_tmp_tables       | 70      |
| Delayed_insert_threads   | 0       |
| Delayed_writes           | 0       |
| Delayed_errors           | 0       |
| Flush_commands           | 1       |
| Handler_delete           | 1       |
| Handler_read_first       | 0       |
| Handler_read_key         | 275924  |
| Handler_read_next        | 4748631 |
| Handler_read_rnd         | 1494115 |
| Handler_update           | 242     |
| Handler_write            | 14904   |
| Key_blocks_used          | 599     |
| Key_read_requests        | 1121937 |
| Key_reads                | 599     |
| Key_write_requests       | 478     |
| Key_writes               | 252     |
| Max_used_connections     | 26      |
| Not_flushed_key_blocks   | 0       |
| Not_flushed_delayed_rows | 0       |
| Open_tables              | 23      |
| Open_files               | 42      |
| Open_streams             | 0       |
| Opened_tables            | 27      |
| Questions                | 6726    |
| Running_threads          | 26      |
| Slow_queries             | 2       |
| Uptime                   | 1717    |
+--------------------------+---------+


#-- Ilya Obshadko [IDO-RIPN] -------------------------------#
#-- email: ilya@stripped, ilya24@stripped -----------------#
#-- ICQ UIN: 10704338 --------------------------------------#

Thread
inadequate performance (3.22.20a)Ilya Obshadko16 Jun
  • Re: inadequate performance (3.22.20a)Dan Nelson16 Jun
    • Re: inadequate performance (3.22.20a)Ilya Obshadko16 Jun
  • Re: inadequate performance (3.22.20a)Sasha Pachev16 Jun
    • Re: inadequate performance (3.22.20a)Ilya Obshadko16 Jun
  • Re: inadequate performance (3.22.20a)Ozemail)16 Jun