Find Jobs
Hire Freelancers

Expert MySQL DBA required to review Mysql DB configration and peformance

$750-1500 USD

Avslutat
Publicerad ungefär sex år sedan

$750-1500 USD

Betalning vid leverans
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

Om projektet

21 anbud
Distansprojekt
Senaste aktivitet sex år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
21 frilansar lägger i genomsnitt anbud på $1 051 USD för detta uppdrag
Använd avatar
Hi database expert here .. please get in touch so we can talk in detail
$1 482 USD Om 15 dagar
5,0 (464 omdömen)
8,5
8,5
Använd 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 Om 20 dagar
4,9 (94 omdömen)
8,3
8,3
Använd 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 Om 20 dagar
4,8 (164 omdömen)
7,3
7,3
Använd 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 Om 1 dag
5,0 (133 omdömen)
6,0
6,0
Använd 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 Om 10 dagar
5,0 (60 omdömen)
5,7
5,7
Använd 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 Om 14 dagar
5,0 (41 omdömen)
5,3
5,3
Använd avatar
If you award me, frst I will run some test and want to check table structures for more efficient structre
$1 000 USD Om 5 dagar
5,0 (14 omdömen)
4,2
4,2
Använd 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 Om 20 dagar
5,0 (1 omdöme)
2,6
2,6
Använd avatar
A proposal has not yet been provided
$1 250 USD Om 10 dagar
0,0 (0 omdömen)
0,0
0,0
Använd 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 Om 20 dagar
0,0 (0 omdömen)
0,0
0,0
Använd 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 Om 20 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
A proposal has not yet been provided
$833 USD Om 20 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
i understand your mysql configuration and i can help you to achieve very good performance by providing good advice.
$1 250 USD Om 15 dagar
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för AUSTRALIA
Pacific Pines, Australia
5,0
19
Verifierad betalningsmetod
Medlem sedan mars 20, 2011

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.