Title: Database problem Last modified: August 31, 2016 --- # Database problem * [Mr. Deb](https://wordpress.org/support/users/silumant/) * (@silumant) * [10 years, 1 month ago](https://wordpress.org/support/topic/database-problem-46/) * Hello Developer of this Beautiful Theme, * My website is: 911loyalservice.com I am using this theme for last 6 months. Now I have 20+ posts, 20 plugins & 80+ page and I am in multi domain shared host- gatore hosting. * Now I am facing a problem of using toot much resources in my hosting. My site becoming slow & unresponsive. The I/O, entry process & CPU usages become high. The hosting support team says it is database problem, some query is taking too much time to execute(more than 20 seconds) & go to sleep. When I was using your very previous version of theme there was no such issue. * SO Can you tell me that this issue is not from your Theme? Just for curiosity I thought this problem may be due to theme database. So can you please assure me that this problem i not from your Theme. OR may be this problem is due to the TYPES plugin & Redux frame work. (I observe sudden increase of cpu usages when I activate this plugins. * Can you tell me any suggestion for this. Thanks Viewing 9 replies - 1 through 9 (of 9 total) * Theme Author [shufflehound](https://wordpress.org/support/users/shufflehound/) * (@shufflehound) * [10 years, 1 month ago](https://wordpress.org/support/topic/database-problem-46/#post-7049437) * 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](https://wordpress.org/plugins/better-delete-revision/) to delete them and see if website works faster. * Also do you use PHP 7? * Thread Starter [Mr. Deb](https://wordpress.org/support/users/silumant/) * (@silumant) * [10 years, 1 month ago](https://wordpress.org/support/topic/database-problem-46/#post-7049472) * 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. * Theme Author [shufflehound](https://wordpress.org/support/users/shufflehound/) * (@shufflehound) * [10 years, 1 month ago](https://wordpress.org/support/topic/database-problem-46/#post-7049477) * 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. * Thread Starter [Mr. Deb](https://wordpress.org/support/users/silumant/) * (@silumant) * [10 years, 1 month ago](https://wordpress.org/support/topic/database-problem-46/#post-7049486) * 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. * Theme Author [shufflehound](https://wordpress.org/support/users/shufflehound/) * (@shufflehound) * [10 years, 1 month ago](https://wordpress.org/support/topic/database-problem-46/#post-7049699) * Hello, * Sorry for our late response. * You can try any version in last 3 months. Also there is a [plugin](https://wordpress.org/plugins/p3-profiler/), which can find what slows down your website. * Thread Starter [Mr. Deb](https://wordpress.org/support/users/silumant/) * (@silumant) * [10 years, 1 month ago](https://wordpress.org/support/topic/database-problem-46/#post-7049700) * 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/](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.) * Theme Author [shufflehound](https://wordpress.org/support/users/shufflehound/) * (@shufflehound) * [10 years, 1 month ago](https://wordpress.org/support/topic/database-problem-46/#post-7049702) * 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. * Thread Starter [Mr. Deb](https://wordpress.org/support/users/silumant/) * (@silumant) * [10 years, 1 month ago](https://wordpress.org/support/topic/database-problem-46/#post-7049703) * 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 * Theme Author [shufflehound](https://wordpress.org/support/users/shufflehound/) * (@shufflehound) * [10 years, 1 month ago](https://wordpress.org/support/topic/database-problem-46/#post-7049704) * 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. Viewing 9 replies - 1 through 9 (of 9 total) The topic ‘Database problem’ is closed to new replies. * ![](https://i0.wp.com/themes.svn.wordpress.org/maskitto-light/3.4.0/screenshot. png) * Maskitto Light * [Support Threads](https://wordpress.org/support/theme/maskitto-light/) * [Active Topics](https://wordpress.org/support/theme/maskitto-light/active/) * [Unresolved Topics](https://wordpress.org/support/theme/maskitto-light/unresolved/) * [Reviews](https://wordpress.org/support/theme/maskitto-light/reviews/) ## Tags * [database problem](https://wordpress.org/support/topic-tag/database-problem/) * 9 replies * 2 participants * Last reply from: [shufflehound](https://wordpress.org/support/users/shufflehound/) * Last activity: [10 years, 1 month ago](https://wordpress.org/support/topic/database-problem-46/#post-7049704) * Status: not resolved