Re: Performance increased after mysqldump restoration ?

[Julien Collas]

Hi,

I have both MyISAM and InnoDB..
I ran an ANALYSE TABLE on a non-production version and all seems OK.

Here are some data I monitor (5minutes average) :

SELECT : 192 on 5 minutes
UPDATE : 14
INSERT : 2
DELETE : 15

Read Rnd Next : 124 k
Query Qcache_hits : 1,56 k
Qcache_queries_in_cache : 65 k
Threads : 1 running, 27 cached, 6 connected

Server is 16GB RAM , 2 * 4 Xeon 2,33Ghz


Here are some output of SHOW TABLE STATUS on the production db :

*************************** 178. row ***************************
Name: tax_rates
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 1
Avg_row_length: 60
Data_length: 60
Max_data_length: 281474976710655
Index_length: 2048
Data_free: 0
Auto_increment: 2
Create_time: 2008-08-12 06:03:47
Update_time: 2008-12-08 19:22:51
Check_time: 2008-12-08 19:23:34
Collation: utf8_unicode_ci
Checksum: NULL
Create_options:
Comment:

*************************** 169. row ***************************
Name: products_xsell_2
Engine: InnoDB
Version: 10
Row_format: Compact
Rows: 746909
Avg_row_length: 42
Data_length: 32047104
Max_data_length: 0
Index_length: 39944192
Data_free: 0
Auto_increment: 746625
Create_time: 2008-12-08 19:23:34
Update_time: NULL
Check_time: NULL
Collation: utf8_unicode_ci
Checksum: NULL
Create_options:
Comment: InnoDB free: 580608 kB


Here is my configuration file

sort_buffer_size=48M
read_buffer_size=24M
join_buffer_size=24M
binlog_cache_size=24M
max_connections=1000
key_buffer_size=1024M
max_allowed_packet=32M
table_cache = 32712
thread_concurrency = 16
thread_cache_size = 32
query_cache_size = 256M
tmp_table_size = 512M

Thanks for your help

--
Julien