Free up MySQL Space in WordPress – Delete Akismet Logs

Author posted by Jitendra on Posted on under category Categories Web Technology and tagged as Tags , with 1 Comment on Free up MySQL Space in WordPress – Delete Akismet Logs

Free up MySQL Space in Wordpress – Delete unused Akismet Logs

Akismet is owsome plugin to protect your WordPress site from the spams. However, before writing this article, i was checking the space used by the database. I was so surprised when i saw that the table named “wp_commentmeta” was having more than 11k records using 20MB of the space.

After some time, i found that Akismet uses that table as a log to display the reports about spam. Spams are automatically deleted by akismet, but entry for every spam was maintained in that table.

When i run below query to find the orphan comments meta :

Select * FROM wp_commentmeta WHERE comment_id NOT IN
(SELECT comment_id FROM wp_comments)

There were nearly 10k records which were orphans. To free up the memory, i run below query

DELETE FROM wp_commentmeta WHERE comment_id NOT IN
(SELECT comment_id FROM wp_comments)

With the help of above query, i free up nearlly 18MB of space.

Please leave your valuable feedback over the same problem.

Servlet, Hibernate, jQuery and Ajax based google like chat

Servlet, Hibernate, jQuery and Ajax based google like chat with source code

Hi, In this article, my aim is to create an application which uses the concept of Hibernate in Servlet with Ajax support of Jquery.
Below figure can give you the idea of final look and feel of the complete application:

Servlet, Hibernate, jQuery and Ajax based google like chat
Servlet, Hibernate, jQuery and Ajax based google like chat

Continue reading “Servlet, Hibernate, jQuery and Ajax based google like chat”

Install MySQL and Query Browser in Ubuntu

Author posted by Jitendra on Posted on under category Categories Linux and tagged as Tags , , , , with 12 Comments on Install MySQL and Query Browser in Ubuntu

To open the Terminal, go to Application > Accessories > Terminal

Open terminal in ubuntu
Open terminal in ubuntu

Type the following command at terminal.

  • $sudo apt-get install mysql-server
console screen look like during downloading the mysql in Ubuntu
console screen look like during downloading the mysql in Ubuntu

  • mysql comes with no root password. To set the root password, type:

$mysqladmin -u root password your-new-password

$sudo /etc/init.d/mysql restart

  • Install mysql query browser

$sudo apt-get install mysql-query-browser

  • After installing, go to Applications > Programming > MySQL Query Browser to connect to mysql as shown below.
open mysql query browser in ubuntu
open mysql query browser in ubuntu

Enter Server Hostname, Username and Password. Click on Connect and MySQL is now installed on Ubuntu.

Connect to MySQL using Query Browser in Ubuntu
Connect to MySQL using Query Browser in Ubuntu