Optimize WordPress from the database

About a month ago I was having space problems on my website. That is easily solved: by ordering the files, folders and images of FTP. Now, when that is not enough, we must start to review other aspects.

It is known that WordPress is a savage resource devourer and that if the hosting is not very good and it is good optimized, can bring difficulties over time.

MySQL data bases are a solid platform to use on websites, but if they are not maintained and errors are prevented, they can fail catastrophically . Sometimes maintenance is as easy as optimizing tables .

When we write a post, it is saved in the database. There will be saved waiting for someone to visit us: when someone enters the blog in WordPress a series of actions is triggered from PHP to be able to show us the information stored in MySQL .

If you are to modify your blog a lot, delete many comments, write many post, edit, delete post, install plugins that use the database, or use statistics plugins in your WordPress; surely after this you can save about 2Mb of space in the database, this is because 'optimize a database' eliminates the information that does not work and 'compresses' another. It is not only the fact of eliminating 2Mb of dead information, it is rather that that information bothers and can cause problems.

If you are someone who knows about this, you will say: this child speaks giladas. But I try to explain it easily, ok? Let's continue.

WordPress (as it was already said), it does not always erase all the information: if we delete a post, it will stop showing, but it may still be written in the database. So also with the comments. There are certain plugins that use the database (especially the forums, statistics, etc.) which sometimes are poorly optimized and can annoy; also when one deactivates or deletes them (using ftp), it must be taken into account that what was in the database was not deleted, it must be done manually.

How is a database made up? ? I'll explain it very simple:

Taking into account this model, we must know that: within each MySQL server databases (for users), within of each of them there are tables, in these the information is saved. A plugin can create several tables (for example: one for post, another for comments, etc.), and we can optimize or delete individual tables.

How can WordPress be optimized from the database?

First of all, it is necessary to do maintenance tasks in the blog: delete the queue of spam in Askimet, delete the comments that are to moderate (or approve them, as appropriate), delete post and pages, uninstall plugins, etc.

Once we did all of that, there are two paths; although before attempting either, is highly recommended to make a backup :

Manual Optimization from PHPMyAdmin : let's go to our PHPMyAdmin (or SQL server), I asked your hosting provider how to access the. Once there, we will select the corresponding database, and we will see a list of 'tables'. Let's go down everything and click on "select all". Then, we will look for the option 'optimize' (look at the drop-down menu).

This process may take several minutes, so it is not recommended that you close the browser and avoid losing the connection.

Easy option, is to use plugins:

Optimize DB : it's simple, easy and fast. It prevents us from doing the work by hand, it shows the size of each table and how much can be optimized. It works with a simple click

DB-Manager : optimizes and also has other functions such as backup, repair, etc.

I also recommend reading : ] How to make WordPress work better ?, Optimize MySQL for WordPress and a special for WordPRess Mu (interesting) .

NOTICE : this publication is from two years ago or more. If it's a code or a plugin it might not work in the latest versions of WordPress, and if it's a news story it might be obsolete. Then do not say we have not warned you.

Loading …

That may also help you:

Between Blogs – The best of the Week

WordPress Help belongs to the blog network Between Blogs and as I do not want to miss out on what might be the best posts in the whole blogosphere here you have best of the week in Between Blogs :


  • Resident Evil: Extinction : Bocabit analyzes … with his particular style, the latest installment of this new edition of Resident Evil in the cinema. [19659005] What will not go in WordPress 2.7 : After having tried the most anticipated version of WordPress, a few days ago we did compilation of what will not go in the 2.7 update of this content creation and management system. [19659007] Things that do not work and that nobody complains about : SoyPlastic denounces what others are silent, those realities that should not be such.
  • Free Photography Course : LimiteNet the new incarnation of Buscando Libertad does not report a fantastic free resource for lovers of photography.
  • Win prizes worth $ 6,000 in CiberPrensa : Ciberprensa has been chosen as one of the 50 blogs of the promotion HP Magic GiveAway thanks to which we can win products from HP, Microsoft and more worth more than $ 6.00
  • Nokia 5800 free for $ 249 with Yoigo : Yoiggers one of the surprises of Entre Blogs, tells us about this marvel of Nokia mobile, helping us save money if we do portability.

What you read is an original content of WordPress Help – Resources, themes, plugins and tutorials in Spanish and published Fernando Tellado first here: Between Blogs – The best of the Week

WordPress 2.7 RC 9965

We are almost on the verge of the final version of WordPress 2.7 because in the update tonight the version indicator shows that we are already in the RC (ready to publish version), specifically the RC .9965 (almost RC 1).

There is less left, surely this week the definitive version finally comes out. Changes since the previous Beta 3 ?, none that have appreciated at this time. If I can say that everything is fine, without failures.

Show the latest registered users • WordPress Help

With this trick we are going to get a little closer to converting WordPress into a portal system being able to show – as do others CMS more oriented in this sense – the ] last users that have registered in your blog .

You just have to paste the following code in the place of your template where you want the list to appear, usually in sidebar.php : [19659002] In this case the last 5 registered users will be shown, if you want to change it you just have to change the number of the SQL query that makes the code.

We are already in WordPress 2.7 • WordPress Help

Quiet, the final version of WordPress 2.7 has not yet arrived but, encouraged by the stability of each of the preliminary versions that we have been testing, I just updated WordPress Help to version 2.7 of WordPress, at this moment the edition ßeta 3 build 9948 as you can imagine near the definitive version already.

The process, as usual, has been simple and fast ( less than 1 minute) and everything works perfectly … unless you detect something that is not fine and I have not noticed.

Plugins? because I only had to do the retouching a Simple Tags and the only one that has not worked in any way is Imaset . The perfect rest, not all take advantage of the drag and drop functions of the new editor, for example, but they work perfectly and without problems.

Come on, this is scary, absolutely recommendable.

What other blogs about WordPress do you read on a daily basis? • WordPress Help

Today when I reviewed my subscriptions to RSS feeds I realized that there are not many blogs about WordPress to read daily and especially the lack I have noted in Hispanic blogs that deal with this topic and that, among all, we could generate an even larger community of users to share solutions, tricks or news about this CMS that

When Guille and a server decided to create WordPress Help it was partly because of that finding that the Spanish WordPress sphere was somehow orphaned of content, at least not as what We read in Anglo-Saxon blogs, and with that idea we created a blog that dealt exclusively with WordPress.

Now, of course, we are not alone, and it is a pride to share information and reading with other great blogs every day. So on WordPress, even if it is not exclusively. And to encourage this feeling of community I would like each of us to present the blogs we read "on a daily basis" to learn more about WordPress both in other languages ​​and in our language.

Of course, I start …

En Español:

  1. Anieto2K
  2. Xybernéticos
  3. BlogPocket
  4. Carrero
  5. Digizen
  6. Mangas Verdes
  7. Inkilino

In other languages:

  1. WordPress Max
  2. ] Blog Perfume
  3. WordPress Hacks
  4. Lorelle on WordPress
  5. WP Candy
  6. WP Fun
  7. Alex King

Well now it's your turn to tell us what your blog posts about WordPress are, which you read daily.

Note: as there is comment moderation when there is more than one link your comment will not come out instantly but I will approve it as fast as I can … as always

NOTICE : This publication is from two years ago or more. If it's a code or a plugin it might not work in the latest versions of WordPress, and if it's a news story it might be obsolete. Then do not say that we have not warned you.

Loading …

What will not go in WordPress 2.7

There is more information about the news and features of WordPress that will not come out with version 2.7 and that they will be postponed for the next version, WordPress 2.8 . They are as follows:

  • Some shortcodes by default, perhaps the most popular WordPress.com 10
  • Support for oEmbed associated with shortcodes
  • A better interface of user for post reviews, and perhaps even an optional field to show what has changed in each revision
  • Support for OAuth
  • GeoData for posts, comments, attachments, etc. [19659003] User interface for duplicate posts Tags in other taxonomies ( Ticket 6387 )
  • Template tags that do in the gallery what ma.tt already has in his blog
  • Code highlighting Codepress for template editing (this will be milk)
  • Menu editor
  • Tags unbalanced in tags more and nextpage ( Ticket 6297 )
  • Sitemaps by default
  • Auto-current Importers
  • post_type for galleries
  • Version system in template editions
  • Links to documentation for the functions used in the template that is being edited
  • MPTT for hierarchies

I find the template editor with code highlighting especially interesting, which would eliminate the need to use external editors most of the time, something already requested some time ago by users .

The entry What will not go in WordPress 2.7 published it first Fernando Tellado in Help WordPress . Do not copy content, do not say anything good about you to your readers.

Check if your blog is online or not • WordPress Help

There are times when the host where our blog goes down or there are errors in the database or in the DNS of the domain . Errors that can be repaired, but only if we notice on time or if someone notifies us in time of it. For our luck there is ServerMojo a great service that will check every certain state of our server. We can ask ServerMojo to monitor our database, or our DNS, or our server or even a specific page of our blog.

The service is quite simple and will notify us by mail, Twitter or IM if it detects that something is not working as it should, and so we can solve it more quickly.

Of course, there are also more options: BasicState Ezine Monitor ] Montastic and many more. It is only a question that you find your ideal service and begin to know the times that your server falls and leaves without access to all your visits …

Disables all plugins from hit

There are times when it may be necessary to quickly deactivate all your plugins . For example, before an update, when one of them suspects that is interfering in the blog or causing an error but you do not know what it is, and more possible issues. Let's not say if the situation reaches a point where you can not even access your administration panel.

Let's see what options we have:

Disable plugins from the Administration Panel

From WordPress 2.5 you have the possibility to check the boxes next to the plugins and deactivate them all at once

It helps you to disable plugins one by one as well to deactivate them all. Then you can activate one by one.

Disable plugins from FTP

This method is ideal for those occasions when you can not access your administration panel or want an ultra-fast action.

The process is very simple, you just have to rename the folder ' plugins ' located in ' ] wp-content 'and all will be disabled. Then you can create another folder ' plugins ' and add plugins one by one until you find the culprit.

Another possibility is to change the name of specific plugin folders or even delete them, any of these actions also will disable – most of the time – the plugin.

Disable plugins from PHPmyAdmin

Go to phpMyAdmin and choose the database of your WordPress blog. Once you have selected it, click on the SQL button to open the SQL command window. Paste the following SQL command and execute it:

That's it, your plugins are immediately disabled when you run the command. [19659025] And what systems do you use or do you find more interesting ?, it's more, do you know any more tricks to disable plugins?

NOTICE : this publication is from two years ago or more. If it's a code or a plugin it might not work in the latest versions of WordPress, and if it's a news story it might be obsolete. Then do not say we have not warned you.

Loading …

That may also help you:

Art and Science of CSS – Free Book

The people of SitePoint are giving away the eBook The Art & Science of CSS for 14 days. To get it you just have to do the following:

  1. Follow them on your Twitter then they will follow you too
  2. A few minutes later you receive a direct message from your Twitter with the download link direct from the book.

What you read is an original content of WordPress Help – Resources, themes, plugins and tutorials in Spanish and published Fernando Tellado first here: Art and Science of CSS – Free Book