Closed

Expert MySQL DBA required to review Mysql DB configration and peformance

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/[url removed, login to view]) 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/[url removed, login to view]:

# cat /etc/[url removed, login to view]

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/[url removed, login to view]

max_allowed_packet=1024M

key_buffer_size=96G

thread_cache=1024

table_cache=163840

myisam_sort_buffer_size=1024M

#log_slow_queries=/var/log/[url removed, login to view]

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/[url removed, login to view]

pid-file=/var/run/mysqld/[url removed, login to view]

######################################

######################################

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: root@localhost

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/[url removed, login to view]

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>

################################

Skills: Database Administration, Linux, MySQL, System Admin

See more: how to install mysql workbench, mysql workbench alternative, workbench mysql, mysql workbench free download, sql workbench download, mysql gui tools, mysql workbench linux, mysql workbench online, remote mysql dba, mysql dba, mysql dba expert, consultant mysql dba freelancer, javascript php mysql developers required, php installation appears missing mysql extension required wordpress, mysql dba project

About the Employer:
( 19 reviews ) Pacific Pines, Australia

Project ID: #16360886

21 freelancers are bidding on average $1051 for this job

tracersa

Hi database expert here .. please get in touch so we can talk in detail

$1482 USD in 15 days
(464 Reviews)
8.5
arhamsoftltd

Note: This is my tentative bid. Greetings, We are expert in databases and we can do analysis and provide you best solution For the Big data recommended databases are tablue or Cassandra and some other databses More

$1323 USD in 20 days
(94 Reviews)
8.3
$1323 USD in 10 days
(98 Reviews)
7.1
mituld

Hi let me help you for Expert MySQL DBA required to review Mysql DB configration and peformance i have skill ,Database Administration,Linux,MySQL,System Admin which is very suitable to your project and i More

$750 USD in 20 days
(164 Reviews)
7.3
shivmirthyusl

IT FLEX SOLUTIONS has focused exclusively on the Web Development/Designing projects with 10+ years of service. Our Web Development/Designing expertise has helped clients to create e-commerce, social networking, real-es More

$1000 USD in 20 days
(37 Reviews)
6.3
pdq

hello i work in a datacenter as a senior linix adminiatrator. lots of experience with big databases in governmental projects. we can discuss details via chat

$750 USD in 1 day
(133 Reviews)
6.0
muquimk

Hi there, I am a server and database administrator. I can help you with the best performance and optimization of the MySQL server. If you are looking an expert for your posted job then I am your man. Lets chat in deta More

$1176 USD in 10 days
(60 Reviews)
5.7
usatechsoft

please send me db HI My Notion : "No Satisfaction, No Payment" We have expertise in Web Design & Development. Please check our client reviews to determine the quality of our work.: Lets discuss in detail an More

$914 USD in 20 days
(17 Reviews)
5.7
IlyaT79

I can do this job. I have many years of Experience in MySQL optimization. You can read the reviews about similar projects in my profile. I will do this job for a few days (no more than two weeks). Every day I will find More

$750 USD in 14 days
(41 Reviews)
5.3
$764 USD in 5 days
(35 Reviews)
5.5
$777 USD in 3 days
(50 Reviews)
5.3
lntrx

If you award me, frst I will run some test and want to check table structures for more efficient structre

$1000 USD in 5 days
(14 Reviews)
4.2
khannanav

We are an exceptionally competent team with an average experience of 10+ years in various fields of Information Technology. Our DB architects and administrators are very well versed with many kind of DB servers like Or More

$1250 USD in 20 days
(9 Reviews)
4.2
MeiZhong0506

I am an expert Mysql DBA developer with over 9 years of experience. I have rich experience with huge Database management. I have just done very similar project like yours. Client asked me to manage huge Database More

$1250 USD in 20 days
(1 Review)
2.6
Anjumnaveed81

I have been doing extensive research on the performance of MySQL server and its interaction with the linux operating system. My Experience and understanding of the operating system, IO and MySQL server can be of benefi More

$833 USD in 20 days
(0 Reviews)
0.0
QaziHassamTariq

I read your requirements and I think its quite possible and doable. I am experienced in my field from 4 to 5 years as a Full Stack Developer in private and government. As I am new here, so I am charging you minimum f More

$1250 USD in 20 days
(0 Reviews)
0.0
Payal9128

i understand your mysql configuration and i can help you to achieve very good performance by providing good advice.

$1250 USD in 15 days
(0 Reviews)
0.0
$888 USD in 10 days
(0 Reviews)
0.0
Kaki08

A proposal has not yet been provided

$1250 USD in 10 days
(0 Reviews)
0.0
$1250 USD in 15 days
(0 Reviews)
0.0