mysql performance issue. pls help..

--000e0cd5cca6d9009b04789f3f48
Content-Type: text/plain; charset=ISO-8859-1

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

--000e0cd5cca6d9009b04789f3f48--

Re: mysql performance issue. pls help..

--0016364ee8d4ebdd6904789ff4d5
Content-Type: text/plain; charset=ISO-8859-1

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

--0016364ee8d4ebdd6904789ff4d5--