Lengkap

optimize Database to prevent slow MySQL queries

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`);

Kemahiran: Pentadbiran Pangkalan Data, Linux, MySQL, PHP, Wordpress

Lihat lagi: building xml files mysql queries, optimize database phpbb3, database online form mysql, optimize mysql queries, optimize phpbb3 mysql queries, optimize mysql queries script, optimize mysql queries phpbb3, steps optimize slow mysql query, whm mysql slow sql queries log, mysql database running slow, find slow mysql query optimize, godaddy mysql optimize database, optimize database mysql, mysql slow sql queries, resolve generated slow mysql queries, mysql database write slow, magento slow mysql queries, slow mysql queries wordpress, fix and optimize database queries in existing app, mysql optimize database

Tentang Majikan:
( 2 ulasan ) Milano, Italy

ID Projek: #17726688

Dianugerahkan kepada:

codinglogics

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 dalam 3 hari
(453 Ulasan)
7.5

16 pekerja bebas membida secara purata €157 untuk pekerjaan ini

coolguyinus2004

Ok the insert statement you have is wrong which has Update statement on Duplicate key so it checks the whole table for duplicate key and insert or update [login to view URL] there is more inserts in a minute then it will be a big is Lagi

€277 EUR dalam 3 hari
(349 Ulasan)
7.7
anmoltech

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 Lagi

€111 EUR dalam 3 hari
(163 Ulasan)
6.2
etechnodroid1515

Hello Client, Hope you are doing great! I have gone through your requirement and understand it very well. I’m expert in this can I get this done for you starting right away no problem. Please let us discuss m Lagi

€233 EUR dalam 15 hari
(111 Ulasan)
6.3
jamesmartin81

I have experience of Website in PHP, Laravel, CodeIgnitor, Wordpress, Opencart, Woocommerce . We also have experience of making Android,Window and iphone application with ionic & phonegap. Benefits in working with us Lagi

€43 EUR dalam sehari
(94 Ulasan)
5.6
mdubey

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 pro Lagi

€150 EUR dalam 5 hari
(54 Ulasan)
5.3
humrobo

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 Lagi

€155 EUR dalam 3 hari
(30 Ulasan)
5.7
businesstogether

Hi, I can start work on your project immediately once you confirm me and i am also open for further discussion if you want. I have 8+ years in web design & development with good experience in following skills ... Lagi

€200 EUR dalam 3 hari
(7 Ulasan)
4.6
RushService

Feel fee to contact me for optimize [login to view URL] me message to discuss further more details .We provide the commments,images,videos,demos and live sessions in order to help the [login to view URL] payment only after the Lagi

€150 EUR dalam 3 hari
(8 Ulasan)
4.2
arjun366333

Ready to start the work to optimize the database of your wordpress or woccomerce webite to run it smooth over the server ,please check my recent similar work ,we can discuss more over chat,tanks regards Arjun S. Lagi

€111 EUR dalam 3 hari
(19 Ulasan)
4.6
rohit554ITHUB

Hello, I have 6+  years of experience in PHP, WordPress  & Codeigniter. I Read your job description, I'm interested in your job.  we feel that we are suitable for the job.  As a senior WordPress expert, I'll be glad t Lagi

€200 EUR dalam 3 hari
(13 Ulasan)
4.0
limillion819

Hello sir. I am very interested in your proposal. I can instantly help you with your starting project with a successful completion. As a professional software developer, I ensure for a perfect ongoing project. You Lagi

€250 EUR dalam 3 hari
(7 Ulasan)
3.7
khhussnain

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 dalam 2 hari
(2 Ulasan)
1.7
scotstyris

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 m Lagi

€30 EUR dalam 2 hari
(2 Ulasan)
1.2
swappitweb

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 Lagi

€250 EUR dalam 7 hari
(4 Ulasan)
1.0
techfinity5

"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 si Lagi

€208 EUR dalam 7 hari
(0 Ulasan)
0.0