Find Jobs
Hire Freelancers

Expert MySQL DBA required to review Mysql DB configration and peformance

$750-1500 USD

Closed
Posted about 6 years ago

$750-1500 USD

Paid on delivery
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/[login to view URL]) 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/[login to view URL]: # cat /etc/[login to view URL] [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/[login to view URL] max_allowed_packet=1024M key_buffer_size=96G thread_cache=1024 table_cache=163840 myisam_sort_buffer_size=1024M #log_slow_queries=/var/log/[login to view URL] 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/[login to view URL] pid-file=/var/run/mysqld/[login to view URL] ###################################### ###################################### 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/[login to view URL] 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> ################################
Project ID: 16360886

About the project

21 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
21 freelancers are bidding on average $1,051 USD for this job
User Avatar
Hi database expert here .. please get in touch so we can talk in detail
$1,482 USD in 15 days
5.0 (464 reviews)
8.5
8.5
User Avatar
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 like mongo db. So we need to review first and need to do some analysis which will be offcourse paid after that we can suggest you the solution either we can optimize it or we need to move on other solution. Awaiting your response Many Thanks DH
$1,323 USD in 20 days
4.9 (94 reviews)
8.3
8.3
User Avatar
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 have done 422+ project at freelancer.com pls check my profile at -------------------------------- https://www.freelancer.com/u/mituld --------------------- So if you find my profile good we can chat for more detail Thanks
$750 USD in 20 days
4.8 (164 reviews)
7.3
7.3
User Avatar
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
5.0 (133 reviews)
6.0
6.0
User Avatar
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 details. Thanks, Muquim
$1,176 USD in 10 days
5.0 (60 reviews)
5.7
5.7
User Avatar
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 a bottleneck and change the configuration. The next day, I will find a new bottleneck and so on. I will need root access to the server and mysql. I will also need short downtime periods to restart the mysql.
$750 USD in 14 days
5.0 (41 reviews)
5.3
5.3
User Avatar
If you award me, frst I will run some test and want to check table structures for more efficient structre
$1,000 USD in 5 days
5.0 (14 reviews)
4.2
4.2
User Avatar
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 and improve its performance. Can we discuss further detail? Thank you. Qing
$1,250 USD in 20 days
5.0 (1 review)
2.6
2.6
User Avatar
A proposal has not yet been provided
$1,250 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 for seeking a good relationship and getting an
$1,250 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 benefit for the project. From the shown configuration file, I can see some obvious things lacking. No configuration has been done for thread concurrency, buffer pool and double write buffer. Depending upon what the database is being used for, there can be other optimizations possible. Looking forward to being of help to you.
$833 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$833 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i understand your mysql configuration and i can help you to achieve very good performance by providing good advice.
$1,250 USD in 15 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Pacific Pines, Australia
5.0
19
Payment method verified
Member since Mar 20, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.