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