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 --------------------------------------#
