It takes more then 3 minutes to post my thread ! , you can just try to copy my thread content and post it as new thread or new post .

Your problem has nothing to do with Percona's software, it is caused by converting away from MyISAM. You didn't test this change beforehand, and you are inexperienced with configuring and administering InnoDB -- and that is the real root cause. You have a lot to learn in a very short time. You should start with Peter's blog post about what to tune in InnoDB after a default installation

http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune- in-mysql-server-after-installation/
http://www.mysqlperformanceblog.com/2007/11/01/innodb-perfor mance-optimization-basics/

Hi xaprb ,
Thanks for your reply , but i wonder if you read my my.cnf file ?

M.A.G wrote on Wed, 02 June 2010 03:53

Hi xaprb , Thanks for your reply , but i wonder if you read my my.cnf file ?

Yes, and that is where your problem lies.
If you look closely you will see that you placed all your new InnoDB settings in the [mysqld_safe] group which means that mysqld will not read them.

[mysqld]safe-show-databasedatadir = /backup/working-mysqlback_log = 20#skip-innodbskip-csvskip-blackholeskip-mrg_myisamskip-archivemax_connections = 700key_buffer = 400Mmyisam_sort_buffer_size = 64Mjoin_buffer_size = 2Mread_buffer_size = 4Msort_buffer_size = 4Mtable_cache = 10000table_definition_cache = 512long_query_time = 2thread_cache_size = 1024wait_timeout = 240connect_timeout = 160tmp_table_size = 128Mmax_heap_table_size = 128Mmax_allowed_packet = 128Mnet_buffer_length = 16384max_connect_errors = 10concurrent_insert = 4thread_concurrency = 8table_lock_wait_timeout = 30read_rnd_buffer_size = 524288bulk_insert_buffer_size = 8Mquery_cache_limit = 16Mquery_cache_size = 64Mquery_cache_type = 1query_prealloc_size = 131072query_alloc_block_size = 65536range_alloc_block_size = 4096transaction_alloc_block_size = 8192transaction_prealloc_size = 4096default-storage-engine = MyISAMmax_write_lock_count = 8low_priority_updates=1############[mysqld_safe]############nice= -10pid-file=/backup/working-mysql/mysql.pidopen_files_limit = 8192#innodb_file_per_table = 1innodb_open_files = 8048innodb_data_file_path=ibdata4:2G:autoextend:ma x:4G#innodb_buffer_pool_size = 512Minnodb_buffer_pool_size = 4Ginnodb_additional_mem_pool_size = 512Minnodb_log_file_size = 256Minnodb_log_buffer_size = 16Minnodb_thread_concurrency = 8innodb_concurrency_tickets = 500innodb_lock_wait_timeout=200innodb_flush_method = O_DIRECTinnodb_autoinc_lock_mode= 2innodb_commit_concurrency=4innodb_flush_log_at_tr x_commit=0innodb_support_xa=falseinnodb_checksums= 0innodb_doublewrite=0innodb_max_dirty_pages_pct=15 innodb_io_capacity = 10000innodb_adaptive_checkpoint = 1innodb_write_io_threads = 8innodb_read_io_threads = 8[mysqldump]quickmax_allowed_packet = 16M[myisamchk]key_buffer = 64Msort_buffer = 64Mread_buffer = 16Mwrite_buffer = 16M


Change your configuration to this:

[mysqld]safe-show-databasedatadir = /backup/working-mysqlback_log = 20#skip-innodbskip-csvskip-blackholeskip-mrg_myisamskip-archivemax_connections = 700key_buffer = 400Mmyisam_sort_buffer_size = 64Mjoin_buffer_size = 2Mread_buffer_size = 4Msort_buffer_size = 4Mtable_cache = 10000table_definition_cache = 512long_query_time = 2thread_cache_size = 1024wait_timeout = 240connect_timeout = 160tmp_table_size = 128Mmax_heap_table_size = 128Mmax_allowed_packet = 128Mnet_buffer_length = 16384max_connect_errors = 10concurrent_insert = 4thread_concurrency = 8table_lock_wait_timeout = 30read_rnd_buffer_size = 524288bulk_insert_buffer_size = 8Mquery_cache_limit = 16Mquery_cache_size = 64Mquery_cache_type = 1query_prealloc_size = 131072query_alloc_block_size = 65536range_alloc_block_size = 4096transaction_alloc_block_size = 8192transaction_prealloc_size = 4096default-storage-engine = MyISAMmax_write_lock_count = 8low_priority_updates=1#innodb_file_per_table = 1innodb_open_files = 8048innodb_data_file_path=ibdata4:2G:autoextend:ma x:4G#innodb_buffer_pool_size = 512Minnodb_buffer_pool_size = 4Ginnodb_additional_mem_pool_size = 512Minnodb_log_file_size = 256Minnodb_log_buffer_size = 16Minnodb_thread_concurrency = 8innodb_concurrency_tickets = 500innodb_lock_wait_timeout=200innodb_flush_method = O_DIRECTinnodb_autoinc_lock_mode= 2innodb_commit_concurrency=4innodb_flush_log_at_tr x_commit=0innodb_support_xa=falseinnodb_checksums= 0innodb_doublewrite=0innodb_max_dirty_pages_pct=15 innodb_io_capacity = 10000innodb_adaptive_checkpoint = 1innodb_write_io_threads = 8innodb_read_io_threads = 8[mysqld_safe]nice= -10pid-file=/backup/working-mysql/mysql.pidopen_files_limit = 8192[mysqldump]quickmax_allowed_packet = 16M[myisamchk]key_buffer = 64Msort_buffer = 64Mread_buffer = 16Mwrite_buffer = 16M


BTW: Your setting:
innodb_log_file_size = 256M
feels very big, even though you have a very high performance site you rarely need above 64M and 8MB for the log_buffer.
And your setting:
innodb_flush_log_at_trx_commit=0
I do recommend = 2 instead, it's safer and the difference is usually not noticeable.

key_buffer = 400M

that also feels very big for an InnoDB-only database.

I didn't read your my.cnf file -- you pasted WAY too much information for me to spend time reading it all. Instead, I scrolled down with the Page Down key, and saw the errors from your error log. That was enough to show me InnoDB is badly misconfigured )

Thanks for everyone who help , special thanks for sterin71 .
I'v edited my my.cnf and i will watch their for results.
I will update this thread soon .
Best Regads,
M.A.G