Expert MySQL DBA required to review Mysql DB configration and peformance

For $1,500 — Ends 24 Mar 2018 (in 3 months)

I have a large mysql DB running on CentOS6.5.
DB size is around 4TB with over 400,000 tables.
Need expert advice on recommended mysql configuration (/etc/my.cnf) to achieve maximum performance.
Server specs: VM CPU:16 cores, RAM:224GB, HDD: 8TB
Please only Mysql DBA experts need to apply.
Following is the content of /etc/my.cnf:
# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_allowed_packet=1024M
key_buffer_size=96G
thread_cache=1024
table_cache=163840
myisam_sort_buffer_size=1024M
#log_slow_queries=/var/log/mysqld_slow_queries.log
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
######################################
######################################
Following is performance summary:
mysql>
mysql>
mysql>
mysql> \s
--------------
mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1
Connection id: 355548
Current database: nms
Current user:
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.1.73 Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 3 days 13 hours 44 min 46 sec
Threads: 41 Questions: 993574185 Slow queries: 3511 Opens: 2377801 Flush tables: 1 Open tables: 163746 Queries per second avg: 3218.721
--------------
mysql>
################################ - $1500.0


Sign up to apply →

Posted on freelancer.com





Know a freelancer that can do this job?

Earn lifetime commission for every freelancer you refer, by becoming an affiliate. Find out more

Share this job: