hi all this is my innodb preference. i need to change anything for increasing the db performance..
innodb_additional_mem_pool_size --> 1048576 innodb_autoextend_increment --> 8 innodb_buffer_pool_awe_mem_mb --> 0 innodb_buffer_pool_size --> 8388608 innodb_checksums --> ON innodb_commit_concurrency --> 0 innodb_concurrency_tickets --> 500 innodb_data_file_path --> ibdata1:10M:autoextend innodb_data_home_dir --> innodb_doublewrite --> ON innodb_fast_shutdown --> 1 innodb_file_io_threads --> 4 innodb_file_per_table --> OFF innodb_flush_log_at_trx_commit --> 1 innodb_flush_method --> innodb_force_recovery --> 0 innodb_lock_wait_timeout --> 50 innodb_locks_unsafe_for_binlog --> OFF innodb_log_arch_dir --> innodb_log_archive --> OFF innodb_log_buffer_size --> 1048576 innodb_log_file_size --> 5242880 innodb_log_files_in_group --> 2 innodb_log_group_home_dir --> ./ innodb_max_dirty_pages_pct --> 90 innodb_max_purge_lag --> 0 innodb_mirrored_log_groups --> 1 innodb_open_files --> 300 innodb_support_xa --> ON innodb_sync_spin_loops --> 20 innodb_table_locks --> ON innodb_thread_concurrency --> 8 innodb_thread_sleep_delay --> 10000 interactive_timeout --> 28800 thanks in advance.. Best Regards Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com On Wed, Nov 18, 2009 at 11:50 AM, F.A.I.Z.A.L <sac.fai...@gmail.com> wrote: > HI experts > > I am facing performance issue for last couple of months. it taking more > time to execute query.. > > developers created tables on myIsam and Innodb. i have a doubts whether we > can use both storage same time.. > > i have 2 thinks in my minds to check this performance. > 1. to check innodb and myisam db memory pools. > 2. to check any index are required. > > based on the above to points i plan to investigate. so please help > > I am not familiar with mysql and first time iam working with developers. > can any help to fix the problem. please assist me what i have to check now?. > > > > Best Regards > Faizal S > GSM : 9840118673 > Blog: http://oradbapro.blogspot.com >
