Find Jobs
Hire Freelancers

optimize Database to prevent slow MySQL queries

€30-250 EUR

Completed
Posted over 5 years ago

€30-250 EUR

Paid on delivery
I need optimize Database because is generating the slow MySQL queries and my website goind down for heavy file [login to view URL] My website is developed with wordpress/woocommerce with template Flatsome My hosting is siteground and below you can see the message about last Technical Support -------------------------- The previous error was caused by the fact that the server ran out of disk space. Most of the disk space is used by the MySQL slow log. That is the log that stores the slow MySQL queries that your sites are executing on the server. I have managed to free some disk space on the server, however I have noticed that for just a few minutes, the log size increased with more than 500MB. The size of the entire log is currently ~26GB: [/home/eshopdan/public_html]# du -sh /var/lib/mysql/[login to view URL] 26G /var/lib/mysql/[login to view URL] Below are some of the entries in that log: [/home/eshopdan/public_html]# tail -n2 /var/lib/mysql/[login to view URL] SET timestamp=1536344131; INSERT INTO `wpim_options` (`option_name`, `option_value`, `autoload`) VALUES ('_wpml_transient__wpml_st_mo_scan_in_progress', 'a:2:{s:5:\"value\";i:1;s:10:\"expiration\";i:1536344429;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`); root@[login to view URL] [/home/eshopdan/public_html]# tail -n3 /var/lib/mysql/[login to view URL] # Bytes_sent: 14 SET timestamp=1536344131; INSERT INTO `wpim_options` (`option_name`, `option_value`, `autoload`) VALUES ('_wpml_transient__wpml_st_mo_scan_in_progress', 'a:2:{s:5:\"value\";i:1;s:10:\"expiration\";i:1536344429;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`); root@[login to view URL] [/home/eshopdan/public_html]# tail -n4 /var/lib/mysql/[login to view URL] # Query_time: 1.565067 Lock_time: 0.000049 Rows_sent: 0 Rows_examined: 0 Rows_affected: 1 # Bytes_sent: 14 SET timestamp=1536344131; INSERT INTO `wpim_options` (`option_name`, `option_value`, `autoload`) VALUES ('_wpml_transient__wpml_st_mo_scan_in_progress', 'a:2:{s:5:\"value\";i:1;s:10:\"expiration\";i:1536344429;}', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`);
Project ID: 17726688

About the project

15 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
Awarded to:
User Avatar
Is it a wordpress based website that you are having? Relevant Skills and Experience I need access to phpmyadmin and to WP admin to scan and find which tables have been impacted the most
€50 EUR in 3 days
4.9 (499 reviews)
7.6
7.6
15 freelancers are bidding on average €150 EUR for this job
User Avatar
Hello, I read your all requirements regarding optimize Database to prevent slow MySQL queries and ready to work for you. I did so many projects same as you want as. I believe to provide quality services with optimum time and price. You can check my past work from my portfolio section. I have more than 7 years experience in Android Application Development, iOS application development, PHP, JavaScript, CSS, HTML, Responsive, Graphic Design, User Interface / IA, Navigation Architecture, UI/UX, jQuery, Ajax, MySQL, OOPS, MVC, Yii framework, Laravel, and WordPress. Let us connect to discuss more about project. Waiting for your positive response. Thanks and regards, Abhishek
€111 EUR in 3 days
5.0 (177 reviews)
6.9
6.9
User Avatar
Dear sir, I am very interested in this Optimizing mysql queries project. I have 8+ Year of Experience in this field and I can surely do this project , i work with my team who always looking for such type of project . so please sir try to give me one chance to prove my strength and quality of work. Actually sir money is not a matter i only want to do this project if you feel good with my work then only after you can award me and pay for this project , me and my experienced team believe in accuracy and quality of work. Trust me sir i never disappoint you at least you can give me one chance. Please check my profile in freelancer.com https://www.freelancer.com/u/mdubey.html Please message me on PM for further discussion. Thanks & Regards Mohit
€150 EUR in 5 days
4.3 (69 reviews)
6.1
6.1
User Avatar
Hi, Hope you doing well sir, I go through your project description in given detail below. I make sure you that i can help you to optimize Database to prevent slow MySQL queries as well better for you , Well i make sure you i can finalized this project for you as well better for you as per your inclined stipulation . Thanks Ashish
€155 EUR in 3 days
4.7 (30 reviews)
5.7
5.7
User Avatar
I would like to work on your database optimization project. I have experience in Wodpress database optimization. Hope to work for you Thanks in Advance
€88 EUR in 2 days
5.0 (2 reviews)
1.7
1.7
User Avatar
Hello...! Greetings! I have seen your post and I am very interested to serve you. We are the team of experienced team and developers who provides solutions and services that help enterprises rapidly launch new mobility and IoT initiatives faster, with less risk and greater success. Our work is mainly Website development, Web designing and Mobile App development. If you think that we are good at converting your ideas into reality you can definitely reach us. Hoping towards positive response.
€30 EUR in 2 days
5.0 (2 reviews)
1.2
1.2
User Avatar
We are a web developing and designing company with various other facilities such as web content and digital marketing related to all types of specializations. Additional considerations and implementations are assisted concerning the requirement of the work. We specialize in content writing and its types such as academic and blog writing for UK, US, Australia, Singapore and other countries. Our diverse functions in various fields include: 1. Website Designing 2. Website Development 3. S.E.O. & Digital Marketing 4. Android Application Development 5. iOS Application Development 6. Content Writing 7. Software Development 8. Python Development 9. Java Development 10. C# Development 11. Windows Development 12. Windows Development 13. Ionic Development 14. Angular JS Development 15. Rest Framework Development 16. Wordpress/Magento Development 17. Unity Game 18. Data Entry Our assured services *Punctual Work *24/7 Availability *Plagiarism Free Work *Uncompromized Quality
€250 EUR in 7 days
5.0 (6 reviews)
1.0
1.0
User Avatar
"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on similar requirement in past. We have right skills to work on this assignment. . We will complete the work as per requirement Also my team working on same project" We have read out every thing about your project kindly confirm"
€208 EUR in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of ITALY
Milano, Italy
5.0
2
Member since May 23, 2017

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.