Database problem

Hello,

Huge issue can be page and post revisions which can use lot of space and slow down your database.
You can use this plugin to delete them and see if website works faster.

Also do you use PHP 7?

Thank you friend for Replaying ,

I am already using a word-press optimizer plugin : WP-Optimize And this plugin delete all page & post revisions. I am also using WP Fastest Cache plugin (As I noticed that Wp Total cache & WP super cache are not good). My PHP version is 5.4 now.

As you say I am going to use your recommended plugin. Also I am thinking about upgrading my PHP to 5.6.

I guess this may be due to current version TYPEs plugin. Should I downgrade this plugin.

Please replay with any recommended solution.

WP-Optimize is also good alternative, you can keep using it.

PHP 5.6 vs 5.4 will not give you much of the performance increase. You should consider PHP 7 which can be about 200% faster.

It can be TYPES plugin and you can try to downgrade it and see if that helps.

My hosting support team said me that their server do not support PHP 7.( I upgraded my php to 5.6, just trying to see)

If I downgrade the type plugin is there will be any issue in my theme design.
Can you say which version of type plugin will be good or I have to do trial & error. (I am using Wp-Rollback plugin & here it shows many versions).

I have no page & post revisions. I have optimized my site by both WP-Optimie plugin & by using the MyPhpAdmin option in c-panel.

This issue happend to me 8 to 10 times in past 6 month. I have observed my server cpu usages while installing the theme & its necessary plugin. I have noticed high cpu usages when installing Types & Redux frame work. While I was in VPS hosting in Arvixe, I also faced many downtime due to high cpu usuages.

Hello,

Sorry for our late response.

You can try any version in last 3 months.
Also there is a plugin, which can find what slows down your website.

Its Ok, at least you replay. Thanks.

I did not change any version of Types plugin (because after changing, website speeds decreases very much)

I have already used P3 plugins. It did not help. I have optimise my database in phpMyAdmin, but it did not help too. I have disabed all plugins & tried, Reinstall the theme.

I am not facing any database connection error. The main problem is, sometimes some query are taking more time to execute, and go to sleep( specially when little traffics come, or I do work in my dashboard). I used Query moniter plugin, found some query which are taking more times. I found one article :
https://css-tricks.com/finding-and-fixing-slow-wordpress-database-queries/

But I do not understand how to fix these slow queries. I mean how to use my phpMyAdmin to solve these slow query. If you show me how to use phpMyAdmin in this problem, I would be grateful to you. I think this article can help, because I am facing exactly this problem.

Also for some days I am using Debug plugin. And I am getting many error whenever I tried to do anything in my wordpress work, i.e: create posts, edit pages, install/uninstall plugins etc.

The errors are like:

Error Number :-

8
Error String :-

Undefined offset: 0
Error File :-

/home/a911lojp/public_html/wp-content/themes/maskitto-light/single.php
Error Line :-

13

(After it, there is a Very Long message which can not be type here. This error occured, when I tried to reinstall your theme)

And sometimes this message:
Error Number :-

2048
Error String :-

call_user_func_array() expects parameter 1 to be a valid callback, non-static method WP_Feed_Cache::create() should not be called statically
Error File :-

/home/a911lojp/public_html/wp-includes/SimplePie/Registry.php

and these

Error String :-

has_cap was called with an argument that is deprecated since version 2.0! Usage of user levels by plugins and themes is deprecated. Use roles and capabilities instead.
Error File :-

/home/a911lojp/public_html/wp-includes/functions.php
Error Line :-

3737
Error Context :-

function has_capversion 2.0message Usage of user levels by plugins and themes is deprecated. Use roles and capabilities instead.

There are lot of such error message.I think these messages are normal or I have to reinstall the wordpress and make website from scratch. I have done this two times with your theme hoping all will be alright. LOL

I think if I know how to optimise the slow query after finding it in query moniter, I can solve this issue. SO please help me How to use phpMyAdmin. Only some instructions will be sufficient.

(P.S- After you said that php 7 is 200% faster, I have planed to move on to siteground hosting, the greeky plan.)

We will inspect those errors and try to imitate/solve them.

PHP 7 is much faster, but it can depend on various aspects, therefore you should try to get a trial account and check it by yourself.

Do I provide you other errors message OR hese will be sufficient.

P.S: I have used your theme in other hosting with a new domain, same problem occured.(same error messages)

I have tried a new theme, called BLDR, based on your recommended plugins (i.e Types, redux frame works, site builder,) And got same errors. I guess the problems are in those plugins

In this case there isn’t a lot we can do.

If you can find exact plugin which gives those issues (by disabling and enabling plugins one by one), then you can submit it in their support forums.