How to Optimize Your WordPress Database with One Click

Have you ever optimized your WordPress database? Optimizing your database cleans up unwanted data which reduces database size and improves performance. In this article, we will show you how to easily optimize your WordPress database with one-click.

How to optimize WordPress database

Why You Should Optimize Your WordPress Database?

If you have been using WordPress for a while, then there is probably a lot of useless data in your database such as post revisions, spam comments, trash, transient options, orphaned meta data, and so on.

This data increases your WordPress database size, which means your WordPress backups will take more disk space and time to restore.

Cleaning up this unwanted data significantly reduces your WordPress database size, which means faster backups, easier restore, and improved database performance.

Having said that, let’s see how to easily optimize your WordPress database and remove clutter.

How to Optimize Your WordPress Database

Since you will be working on your WordPress database, you need to make sure that you create a complete WordPress backup before moving forward.

Next, you need to install and activate the WP-Optimize plugin. For more details, see our step by step guide on how to install a WordPress plugin.

This plugin is built by the same team behind the popular WordPress backup plugin, UpdraftPlus.

Upon activation, the plugin will add a new menu item in your WordPress admin bar labeled WP-Optimize. Clicking on it will take you to plugin’s settings page.

WP-Optimize settings

You will see a list of operations that the plugin will perform on your database. Review them carefully and uncheck any item that you don’t want to run at the moment.

Items marked in red require more intensive database operations. If the process is interrupted during the operation, then it may corrupt data. That’s why we strongly recommend that you create a backup of your website before selecting the items in red.

After selecting the items, click on ‘Run on all selected items’ button at the top.

The plugin will now start optimizing your WordPress database and show you the progress.

That’s all, you have successfully optimized your WordPress database.

Note: If your MySQL database tables are using the InnoDB engine, then WP-Optimize will not perform database table optimization. You can perform that operation manually, using phpMyAdmin. See our beginner’s guide on WordPress database management with phpMyAdmin for detailed instructions.

We hope this article helped you optimize WordPress database. You may also want to see our ultimate guide to boost WordPress speed and performance.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

The very best Map Yet of just what could possibly be NASA’s upcoming Mars Landing Site

On the night of November 28, 1659, a Dutch astronomer named Christiaan Huygens aimed toward the sky a 22-foot telescope of his own invention, peered through its element eyepiece, and received the first known illustration—the very first map, really—of Mars. Their sketch, though crude, grabbed a dark, distinctive area function. Today, astronomers understand it as Syrtis significant.

And they’re about to get to know it much better.

At Syrtis significant’s northeastern side you’ll find probably one of the most interesting plants of geology ever observed on another earth. Its terrain—sandwiched from a large volcano and another of the biggest, earliest craters on Mars—preserves a chapter associated with the planet’s early history marked by hot, watery surroundings in which microbial life could have flourished. Now, 358 years after Hyugens first described Syrtis significant’s outlines, planetary geologists have actually charted its fascinating northeasterly province at greater quality, as well as in finer geological detail, than previously.

“People have explored the mineralogy and geology associated with the bigger area prior to, but nobody has deposit the magnifier and looked at this 1 region in close proximity,” claims Michael Bramble, the planetary geologist at Brown University whom led the mapping effort.

Their team’s map, which seems into the latest problem of the planetary technology journal Icarus, recounts the annals of Northeast Syrtis. “It’s a big action for the planetary science community,” claims UT Austin geoscientist Tim Goudge. “It assists us understand what happened here, why it’s unique, why it’s therefore mineralogically diverse.” That’s a large endorsement: not merely is Goudge unaffiliated with Bramble’s task, he’s something of the rival.

See, Northeast Syrtis is among the two many promising landing web sites currently into consideration for NASA’s Mars 2020 rover. The competing landing site is Jezero crater, home to an ancient lake whose sediments might now carry traces of past life—and Goudge is its lead mapper.

The places regarding the three most widely used internet sites of research, as proposed by attendees at most recent landing site workshop.The areas associated with three best internet sites of exploration, as proposed by attendees at the most present landing website workshop.NASA

Planetary boffins have now been deliberating over where you should secure NASA’s rover for quite some time now. And with valid reason: The site’s composition will have a major effect on the agency’s research. NASA’s next rover, that is slated to introduce in 2020, will investigate Mars’ geological history, measure the planet’s past habitability, and hunt for indications of ancient life. Crucially, it will likewise function as the very first rover to cache samples of Martian soil and rock—samples which NASA hopes to retrieve on a future mission and analyze right here on Earth.

NASA gets closer to a verdict. Northeast Syrtis and Jezero rose toward the surface of the pack simply in February, whenever some 200 planetary researchers convened at a workshop in Monrovia, California to trim the list of recommended prospects from eight to three. (Columbia Hills, a site formerly explored by NASA’s Spirit Rover, additionally made the cut, though the other web sites appear more promising).

it is possible to think about Bramble’s brand new imagery as treasure map: The grayscale image illustrates the Martian surface NASA’s rover will have to traverse to get into examples of the region’s geology, whilst the colored overlay defines the geological levels the rover can expect to locate throughout its travels. The blue indicates the oldest, cheapest levels within the region---a “basement,” Bramble claims, produced by an effect occasion almost 4-billion years ago. The clay minerals in this area suggest the presence of two one-time habitable, aqueous environments. The green overlay demarcates another geographical layer, a landscapes where in fact the mineral olivine has weathered to be carbonate. That response liberates hydrogen---a known energy source for microbial communities here on the planet. Top of the levels regarding the area, indicated in peach, are high in sulfates thought to have created whenever water percolated through these levels. An Earthly analog to the layer may be the Rio Tinto in Spain, a river whose acid waters are known to host microbial life.You can consider Bramble’s brand new imagery as a treasure map: The monochrome image illustrates the Martian landscapes NASA’s rover would have to traverse to gain access to types of the region’s geology, as the colored overlay defines the geological levels the rover can expect discover throughout its travels. The blue shows the oldest, cheapest levels within the region—a “basement,” Bramble claims, developed by a visible impact event nearly 4-billion years back. The clay minerals in this area recommend the current presence of two one-time habitable, aqueous surroundings. The green overlay demarcates the next geographical layer, a landscapes where in fact the mineral olivine has weathered to become carbonate. That reaction liberates hydrogen—a understood energy source for microbial communities right here on the planet. The upper layers of the region, indicated in peach, are abundant with sulfates thought to have formed whenever water percolated through these layers. An Earthly analog for this layer could be the Rio Tinto in Spain, a river whoever acidic waters are known to host microbial life.Bramble et al.

Though only 1 bears its title, both web sites have a home in the northeasterly reaches of Syrtis significant. (They look near for a map, but to NASA’s next rover, which, for a good time, might travel a couple of hundred meters, they could and be considered a million kilometers apart.) Jezero was once house to a river delta that each scientist we talked with described as either stunning, dazzling, or both—oh, and its own minerals may once have supported microbial life. “To the degree that ancient lakes and deltas were habitable surroundings, which we think them to now preserve traces of ancient life, Jezero is absolutely the best option among the list of staying web sites,” claims John Mustard, a planetary geologist at Brown. (Mustard is the connection involving the two web sites; he’s a coauthor on Bramble’s Northeast Syrtis paper, but when served as Goudge’s thesis advisor—small world, no?)

Northeast Syrtis alternatively, is more prone to offer NASA’s rover easy access to countless geologic environments—something the new map for the region confirms. Of specific interest will be the clay minerals in bottommost geological levels, sulfate-bearing terrains inside uppermost strata, and carbonated olivine minerals in between—all that hint at one-time habitable, aqueous environments. What’s more, they’re all readily accessible. “The regions of interest are more clustered in Northeast Syrtis,” Goudge states. Meaning NASA’s rover could conceivably start doing science here once it lands, drilling and caching examples from a array of geologic durations in a relatively tiny screen of time.

A geologic map of Jezero crater, its watershed, additionally the surrounding area. The crater basin it self seems in the bottom righthand corner associated with the image, and it is outlined in white. The dense black colored lines outline the two adjacent watersheds, from where water might have flowed to the impact crater.A geologic map of Jezero crater, its watershed, and surrounding area. The crater basin itself appears at the end righthand corner associated with image, and is outlined in white. The thick black lines outline both adjacent watersheds, from which water could have flowed in to the impact crater.Goudge et al.

That clustering will likely factor into NASA’s concluding decision. The agency’s Jet Propulsion Lab has used the map to perform 1000s of possible landing and research situations through the region. “You understand, in the event that you dropped the rover at this latitude and longitude in which would it go, just what route would it traverse, what obstacles wouldn’t it must avoid,” Mustard says. Goudge has produced comparable maps of Jezero, though at somewhat larger scales and reduced quality. He claims he and their colleagues are going to be collecting more descriptive imagery of the crater within the months ahead, which NASA may also use to model landing and traverse situations.

NASA will go with a landing website for the rover within the next few years, based mostly regarding research and guidance of planetary geologists like Bramble, Mustard, and Goudge. Barring any shocks, it will totally possible be one of many internet sites in Syrtis Major.

That is pretty poetic, if you were to think about this. Christiaan Huygens clearly knew, as he was drawing his rudimentary map a lot more than three centuries ago, that future generations would go on to chart the outer lining of Mars alongside planets in increasingly depth. He might even have guessed we’d seek them out searching for life. (Like a lot of his contemporaries, Huygens was a big believer in extraterrestrials.) But exactly what he couldn’t have understood that November evening was that above 350 years later on, astronomers would direct their attentions back again to Syrtis Major—to the fringes regarding the dark mark he so very carefully described the very first time.

Get back to Top. Skip To: Begin of Article.

Google Wants You to Help Fix the Fake-Fact Problem It Created

Barack Obama is the king of the United States. Republicans are Nazis who clearly hate the Constitution. Dinosaurs are being used to indoctrinate both children and adults into believing that the earth is millions of years old. Women can’t love men. Fire trucks are red because Russians are red.

If you took Google for its word, you’d believe all of these “facts” as truth. Each absurd claim has appeared as a “snippet” on a Google search result—you know, those boxes above the lists of links that try to answer your questions so that you don’t have to actually click through to a website.

Thankfully, Google has changed or removed all of these snippets once they became widely known. But high-profile misfires like these have put pressure on Google to seek new ways to curb inaccurate or offensive snippets before they poison credulous minds—or embarrass the company. Many of these measures, such as algorithm tweaks or new guidelines for the workers who evaluate search results, will happen behind the scenes. But the company will also roll out an expanded feedback form for reporting inappropriate snippets, search results, and autocomplete suggestions.

There’s a lot to like about this plan. It shows that Google is taking the problem of misinformation seriously while offering up a new level of transparency in making public some criteria for removing or changing search suggestions. But these fixes only solve one part of the problem with snippets. Improving snippet accuracy does nothing to address the problem of Google cannibalizing traffic from the sources from which it strips these answers. Nor does it resolve the underlying philosophical question: When should Google try to provide “one true answer” to a question versus just delivering a list of links? After all, the easiest way to get rid of misinformation in snippets is to get rid of snippets altogether, right?

But for the future of Google’s business, the answer is not that simple. Having an authoritative answer to as many search queries as possible is increasingly important to the company as it extends its reach beyond traditional, text-based search results into the world of voice-based personal assistants. When you ask your phone or your web-connected speaker a question, you want an answer, not a list of webpages. Even in the text-based world, you often want a quick answer to settle an argument.

But it turns out that turning search results into pat answers has a cost. Last week, The Outline reported that lost about 65 percent of its traffic after Google started including its data in snippets instead of leaving it to users to click through to the site. Site founder Brian Warner said he had to lay off half his staff. This undermining isn’t just a problem for the sites that Google scrapes for information. It’s a problem for Google itself, because if the companies that gather and publish this data can’t make money and have to close, Google loses its source of data.

Meanwhile, there are some questions Google clearly shouldn’t even try to answer. For example, as of now it doesn’t show a snippet for the query, “Does God exist?” But it also stays out of questions like, “Did the Holocaust actually happen?” and “Is climate change real?”

So where should Google draw the line? Conspiracy theorists claim that because jet fuel doesn’t burn hot enough to melt steel beams, 9/11 was an inside job. When you search “can jet fuel melt steel beams,” as The Outline points out, Google displays an excerpt from a Popular Mechanics article pointing out that although it’s technically true that burning jet fuel won’t melt steel, the beams that held up the World Trade Center buildings didn’t need to melt in order to collapse.

That’s useful information, but why is Google willing to combat 9/11 conspiracy theories but not Holocaust denialism? Perhaps the company would argue that explaining the historical evidence of the Holocaust is too complex to fit into a snippet (and indeed, Google doesn’t try to provide a definitive answer to the broader question “was 9/11 an inside job”). But if Google is going to position itself as the arbiter of truth, it should be willing to state the facts on climate change and the Holocaust.

The feedback it gathers from users may help Google decide when to stay out of a debate entirely, but the questions the company now faces don’t have snippet-sized answers. To succeed on new computing platforms where conventional search results don’t make sense, Google has put itself in the position of becoming an arbiter of facts. That’s not a simple job, nor one it can expect to succeed at doing simply by offloading the work on you.

Go Back to Top. Skip To: Start of Article.

6 repair webpage Tips you can make use of on your own WordPress Site

Are you searching for upkeep web page tips for your WordPress site? While nobody likes adding a maintenance web page, sometimes incorporating a maintenance web page becomes unavoidable. In this essay, we shall share some imaginative examples of different types of upkeep pages. We’ll additionally explain to you just how to effortlessly include someone to your WordPress site.

repair Page Ideas for WordPress

Why so when do you want a Maintenance Page in WordPress?

Typically you are able to do most things on your own WordPress site without ever taking it straight down. But there are lots of situations when you should place your site in maintenance mode to prevent any disputes.

If you should be going WordPress from regional server to call home site, or switching in one web hosting server to some other, you will require a upkeep page.

Additionally, you will need a upkeep page in the event that you operate an on-line shop or perhaps a account website to ensure customer instructions aren’t lost and individual sessions don’t end abruptly.

How exactly to Develop A Repair Webpage in WordPress?

Initial thing you will need to do is install and trigger the WP Maintenance Mode plugin. For lots more details, see our thorough guide on how to install a WordPress plugin.

Upon activation, you will need to visit Settings » WP repair Mode page to configure plugin settings.

WP Maintenance Mode

Right here you can add a background image, choose design choices, and add your custom message to your maintenance mode web page.

For step-by-step instructions see our detail by detail guide on how best to place your WordPress site in maintenance mode.

Since you understand how to make a maintenance web page in WordPress, let’s take a good look at various kinds of maintenance pages that one may create.

Types of Repair Pages from Over The Web

Maintenance Pages are not visually noticeable to your users for a long period of the time, however they undoubtedly have an effect on how users see your brand name.

Ugly mistake pages generated by your servers can adversely impact your brand image. Alternatively, an innovative upkeep web page are unforgettable and strengthen your brand identity in user’s brain.

Check out samples of how popular makes use their maintenance mode pages to make this happen.

1. Brief and Sweet

In place of offering detailed description towards users about what’s going on, you can keep it quick and easy. This approach prevents confusion among your users and delivers the message effortlessly.

Among the best examples of this might be probably Twitter’s famous ‘Fail Whale’.

Twitter repair webpage

There are numerous variations of this famous illustration. Twitter in addition has used the Fail Whale as their overcapacity web page and 404 mistake web page for sometime.

This confused their users whilst the error message didn’t precisely communicate the issue. You need to always use a different sort of page as your 404 mistake template. Check out samples of great 404 web page examples.

Another example of short and easy is Atlassian’s maintenance page.


2. Be Compassionate

Its annoying whenever users desire to visit their favorite web site as well as can’t. You’ll want to acknowledge the inconvenience brought on by the maintenance, apologize the trouble, and promise that you are working hard to create the internet site right back as quickly as possible.

Consider this maintenance page from GitHub. It begins having an apology after which supplies a way for users to test the status.

GitHub maintenance page

3. Be Humourous and Entertaining

Downtimes are annoying, as well as your users may feel aggravated about it. Some humor can help.

This is how Product search utilized pet puns on their upkeep web page.

Product search upkeep web page

Patreon used their mascot and when you appear closely, you’ll be able to realize that the little fox possessed a little accident.

Patreon maintenance page

Tumblr utilized a photograph of planet as seen from International universe with their upkeep mode message.

Tumblr maintenance web page example

Flickr used this image because of their maintenance page.

Flickr down for upkeep message

4. Familiar Appearance

Utilizing your brand’s logo, colors, and design makes a upkeep web page far better. Unlike your live web site, user attention is far more dedicated to the message, which is good possibility to build brand name recognition.

Apple does a fantastic job using this.

Apple maintenance web page

5. Countdown for Return

Incorporating a countdown timer to your maintenance web page helps it be look more alive. It develops anticipation among your users.

However, in the event that you don’t desire to add a timer, it is possible to nevertheless include enough time whenever your website is expected become right back on the web.

Here’s an illustration for just how Etsy did it on their maintenance page.

Etsy upkeep web page

6. Progress and Updates

Most popular sites utilize Twitter during planned upkeep to keep their users updated. Some of them additionally include the status updates close to the upkeep web page.

Here’s a good example of exactly how Upwork’s adds live updates with their maintenance page.

Upwork maintenance page with status updates

Strategies for Scheduled Maintenance on your own WordPress Website

When taking care of a real time site you are losing visitors and prospective customers every minute your internet site is down. Check out tips that will help do so better.

1. See your Bing Analytics reports to find out the smallest amount of busy hours in your site then use them for maintenance.

2. Send out a contact towards email list about maintenance routine earlier. In this way you regular users will not be taken by surprise.

3. Ensure your upkeep web page provides users a faster method to get in contact using Twitter, Facebook, etc.

4. Most importantly, make sure your site is back on line at the earliest opportunity.

We hope this short article assisted you see motivation for the maintenance page. You may even want to see our guide on the best way to create breathtaking coming soon pages in WordPress.

If you liked this informative article, then please subscribe to our YouTube Channel for WordPress video lessons. There are also united states on Twitter and Facebook.

How to Add Hreflang Tags in WordPress

Do you want to add hreflang tags in your WordPress posts and pages? If you publish content in multiple languages or for different regions, then hreflang tag helps you improve SEO for those regions and languages. In this article, we will show you how to easily add hreflang tags in WordPress without writing a single line of code.

How to add hreflang tags in WordPress

What is hreflang tag?

Hreflang tag allows you to tell search engines which page to show for a particular region and language. You can also use it to define other variations of the same content in different languages.

Here is how a hreflang tag implementation looks like in plain HTML.



The hreflang tag is a combination of the language code and the region code. For example, en-us for English and the United States, fr-fr for French and France, and so on.

WordPress is available in more than 60 languages, and you can use WordPress in your own language.

Many WordPress site owners target users in different regions and languages. Some do that by creating multilingual websites, while others do that by offering some content in other languages.

Search engines can easily detect the language of a page and automatically match it to the language settings on user’s browser. However, your pages may still be competing with each other in the search results which may affect your site’s SEO.

You can implement hreflang tags to fix that. Let’s see how to easily add hreflang tags in WordPress.

Method 1: Add hreflang Tag in WordPress Using a Multilingual Plugin

The best approach to building a multilingual WordPress site is by using a multilingual plugin. A multilingual WordPress plugin allows you to easily create and manage content in multiple languages using the same WordPress core software.

These plugins will automatically take care of all technical things such as the hreflang tag, so you can focus on creating content.

We recommend using Polylang. It is a free WordPress plugin and comes with a very powerful and easy to use interface to manage multilingual content. For detailed instructions, see our guide on how to how to easily create a multilingual WordPress site.

Adding languages in Polylang

Another popular option is WPML. It is a premium WordPress plugin with an easy to use interface to create multilingual content on your website. For step by step instructions, see our guide on how to create a multilingual WordPress site with WPML.

After you have created some posts or pages in multiple languages, you need to visit them in a new browser window. Right click and select ‘View Page Source’ from your browser menu.

This will open the source code of the post or page. Now you need to look for hreflang tag to verify that it is working properly. You can also use CTRL+F (Command+F) keys to find the hreflang tag.

Method 2: Add Hreflang Tags in WordPress Without Using a Multilingual Plugin

This method is for users who are not using a multilingual plugin to manage translations on their websites.

First thing you need to do is install and activate the HREFLANG Tags Lite plugin. For more details, see our step by step guide on how to install a WordPress plugin.

Upon activation, the plugin will add a new menu item labeled HREFLANG in your WordPress admin menu. Clicking on it will take you to the plugin’s settings page.

hreflang tag plugin settings

Select the post types where you’d like to enable the plugin and then click on the save changes button to save your settings.

Next, you need to edit the post or page where you want to add the hreflang tag. On the post edit screen, you will notice a new metabox labeled HREFLANG tags.

Adding hreflang tags using a plugin

First you need to add the URL of the post that you are currently editing and then select its language. After that you need to click on the plus button to add URLs of other variations of the post and their language.

Once you are done, click on save or update button to save your post.

You can now visit your post in a browser window and view its source code. You will see the hreflang tag added to your post.

We hope this article helped you learn how to easily add hreflang tag to your WordPress site. You may also want to see our step by step WordPress SEO guide for beginners.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.