Re: Hang while executing UPDATE against MEMORY table
Here is some variables and status:
mysql> show variables like "version%";
+-------------------------+-------------------------------+
| Variable_name | Value |
+-------------------------+-------------------------------+
| version | 5.1.22-rc-community |
| version_comment | MySQL Community Edition (GPL) |
| version_compile_machine | i686 |
| version_compile_os | redhat-linux-gnu |
+-------------------------+-------------------------------+
mysql> show status like "Threads%";
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Threads_cached | 0 |
| Threads_connected | 6 |
| Threads_created | 102 |
| Threads_running | 1 |
+-------------------+-------+
mysql> show variables like "thread%";
+-------------------+---------------------------+
| Variable_name | Value |
+-------------------+---------------------------+
| thread_cache_size | 0 |
| thread_handling | one-thread-per-connection |
| thread_stack | 196608 |
+-------------------+---------------------------+
3 rows in set (0.00 sec)
mysql> show variables like "query%";
+------------------------------+---------+
| Variable_name | Value |
+------------------------------+---------+
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 0 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
+------------------------------+---------+
Subject
Views
Written By
Posted
10305
November 28, 2007 03:56AM
5383
December 06, 2007 02:57AM
6017
June 05, 2008 03:52AM
Re: Hang while executing UPDATE against MEMORY table
5739
June 05, 2008 04:14AM
6167
June 10, 2008 05:13AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.