MySQL Database Optimization

I have a server that is sending data to a database. Whenever the server gets to a certain amount of users hte data becomes larger and for some reason it lags the entire server and crashes it. It works fine up until a certain number of users join the server.

I need someone to go in and optimize it and make it stop crashing and lagging.

Skills: Linux, MySQL, PHP, Smarty PHP

See more: optimize mysql, database optimization, php mysql optimize, optimization database, server crashing, mysql join, optimize php mysql, mysql optimize, optimize database mysql, tbjason, php sending mysql, php free scripts bulk sms mysql number database, optimize database, mysql data optimization, mysql crashing php, mysql need optimize, faa tail number database mysql, join mysql php, making database mysql number fields phpmotion, mysql crashing, optimize mysql php, php database join, mysql certain number, optimize mysql server, need optimize mysql

About the Employer:
( 25 reviews ) Minneapolis, United States

Project ID: #5224331

28 freelancers are bidding on average $142 for this job


Hi there, I have over 7 years experience working on HTML, Wordpress, Magento, Database administration, OpenCart, Website Design, Logo / Banner Design Joomla, CSS and Linux Administration. I have read the project descri More

$185 USD in 3 days
(333 Reviews)

I can optimize your mysql server to work properly on high traffic time. I will complete this work in 2 days. I will be available online from 1 am UTC/GMT to 5 pm UTC/GMT, fulltime individual freelancer. Looking for More

$64 USD in 2 days
(656 Reviews)

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 !!)... you can never go wrong choosing me :) I look forward to your reply. More

$309 USD in 2 days
(474 Reviews)

Do you have error log enabled on your control panel ? Is it possible to send me that file so I can understand what query makes the situation to freeze the server

$189 USD in 7 days
(191 Reviews)

Dear sir >Please give me the url and db access to view , we can fix this issue very quick > Please check our freelancer profile [url removed, login to view] - that evidences our works. > We open to op More

$57 USD in 2 days
(163 Reviews)

It seems there is a bad script which overload data and db crashes. I do not think it require optimization of database. Optimizing database may loose data as it require to delete data from database to minimize overload. More

$200 USD in 7 days
(72 Reviews)

Hello I too had that problem once and solved it,. Looking forward to work with you. Thanks and Regards Froiden .....................

$103 USD in 3 days
(140 Reviews)

I can help you. Do you have root access to your server?. I'm looking forwards to your response. Thank you.

$100 USD in 2 days
(83 Reviews)

Hello tbJason, I have gone through your outsourced requirement "MySQL Database Optimization" and have analyzed that I have right credentials (Linux, MySQL, PHP, Smarty PHP) to execute your esteemed project. === More

$147 USD in 1 day
(53 Reviews)

Hello, I can help you,i m ready to start now. i m available in skype and gtalk. please add me in kype. My pseudo : mohsensehili1 Thanks

$111 USD in 3 days
(58 Reviews)

I have gone through your project requirements and we have highly skilled and qualified team who own all the right credentials to execute this job in a very proficient manner as per your exact requirement

$206 USD in 3 days
(21 Reviews)

Hello, I am Red Hat Certified System Administrator / Technician with over 6 years of experience in this field, have passed Unix Level 2 exam here on Freelancer and have all reviews positive - check my profile. I More

$100 USD in 1 day
(25 Reviews)

Hi I have experience with such optimizations. Working with linux systems since 15 years, and have done such a works many times. The plan is: install and start the monitoring tools which will show us the bottleneck du More

$111 USD in 3 days
(12 Reviews)

Hello, How much RAM memory does your server have? Can you paste me your MySQL server [url removed, login to view] config file? I am confident we can fine tune it there. I suspect that simply during traffic spikes your server hits it's More

$100 USD in 1 day
(19 Reviews)

Hello, We are cool team of designers & developers. We love to start the job right away & give you excellent quality Work. Looking forward to your kind respond. plz check link for few of our recent works.. More

$147 USD in 3 days
(13 Reviews)

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start thanks

$175 USD in 6 days
(13 Reviews)

Hi, I'm very interested helping you optimizing your database, I have more then 7 years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there i More

$242 USD in 5 days
(15 Reviews)

Hello TB Jason, I am John Ofagbe a professional software engineer and an expert programmer in MySQL and PHP. Your problem might be due to a bad database design. It could be that the database was not designed to be sca More

$100 USD in 2 days
(6 Reviews)

Respected Hiring Manager, After reading your requirement i am confident to solve the issue technically It would be great if you provide me details of your server host I am having good knowledge More

$147 USD in 3 days
(6 Reviews)

Hello Sir/Madam, I read the project description. I am sure that I can do this job in 1 day. Please take a deep look at my work links. 1) Paramount Pictures - Largest Hollywood Studio - [url removed, login to view] More

$103 USD in 1 day
(7 Reviews)