CODEWITHSUNDEEP
mysqlperformancemyisampercona
Srikanth Lingala
Srikanth Lingala

Reputation: 51

MySQL - MyISAM tables Perforamce issue

Below is my setup:

One primary and Two standby setup. Application connecting to standby read-only nodes with a load balancer. We are having approx., 600 connections at any given time on both the nodes, performing SELECT. DB size - 3GB Application tables - MyISAM engine tables

Below is my configuration on both RO nodes:

MyISAM

key_buffer_size                     = 24G
myisam_sort_buffer_size             = 16M
sort_buffer_size                    = 16M
read_buffer_size                    = 32M

Network

max_allowed_packet                  = 256M # default 16M
wait_timeout                        = 28800
skip_name_resolve                   = ON
max_connections                     = 1200
max_user_connections                = 1000

Network

max_allowed_packet                  = 256M # default 16M

However, we are still facing very poor performance on RO nodes. Kindly request any advise on the tuning part.

Regards Srikanth

Upvotes: 0

Views: 79

Answers (1)

Srikanth Lingala
Srikanth Lingala

Reputation: 51

Thank you everyone.

We initially had RAM of 24GB. Which was increased to 128GB, still no luck. Moving all table to innodb solved the issue.

Upvotes: 1

Related Questions