slowing mysql

Posted in: Newspaper
Post count: 69

we have our site in italy at aruba.it, recently the site goes off line or we can’t pubish the news, the hosting company said the problem is the tag div opt, here is what they wrote

“Dear customer, from the checks carried out the slowdowns on the MySQL database were caused by the plugin tagDiv Composer which executes slow queries on the wp_postmeta concatenated with multiple inner joins on the same type table: the table in question has over 1 million rows as can be seen from the MySQL database.

I translated it the best I could, thanks for any help

tony
site is studio93.it

Post count: 27744

Hi,

I recommend replacing the blocks 1-25 with flex blocks and big grid with big grid flex.
Also, please use cloud templates and after disable the tagDiv Stanrd pack plugin.
Also, please check this topic https://forum.tagdiv.com/topic/slow-website-mysql-db-is-over-1-1gb-how-can-i-reduce-the-size/

Thank you!

Post count: 69

I recommend replacing the blocks 1-25 with flex blocks and big grid with big grid flex.
where do you do this?

Post count: 27744

Hi,

You can edit the homepage with tagdiv Composer and replace the big grid with a big grid flex -> https://forum.tagdiv.com/big-grid-flex-settings/

Thank you!

Post count: 69

question in the wp_option tables the plugins with the newspapper theme do they have an initial like wp_options like akp_default_media_type, this is an old plugin I am cleaning out the old stuff, only thing we are using now is with the theme , wanted to make sure I don’t delete anything from the theme

Post count: 27744

Hello,

This akp_default_media_type, is not from the theme, so you can delete it.
Also, what I can recommend id to reduce the backups from the theme panel -> import/export -> https://i.imgur.com/Xw4uhN0.png and check after.

Thank you!

Post count: 69

thanks found this in the wp options
of_template the bigest one is that to our template

Post count: 27744

Hi,

The theme elements in the database are named with td_

Thank you!

Viewing 8 posts - 1 through 8 (of 8 total)
The forum ‘Newspaper’ is closed to new topics and replies.