MongoDB is a document database available for Linux, MacOS, and Windows operating systems. It offers a free, self-managed Community Edition, as well as a paid version. In this tutorial, we will see how to install the free MongoDB Community Edition…
PSequel is a free and open source SQL database management software for Linux. Using PostgresSQL, you can connect and run any SQL query in your database. It is specialized in PostgresSQL. It is written in Vala and released under GNU…
Queries is a free and open source relational database workbench software for Linux. It is written in Rust and released under GNU General Public License v3.0. Using Queries you can interact with your database. It comes with schemata, tables, views…
DBTarzan is a free and open source database viewer for Linux, MacOS and Windows. It is released under Apache 2.0 license. It supports Oracle, SQL Server, Derby, SQLite, MySQL and PostgreSQL databases. It comes with database connections editor to add, update and remove your database connections. Some other important features are foreign keys preloading, foreign key tags, copy query and log, table information and Order by. It comes with simple and easy to use GUI.
To decrease your wordpress database size follow the below steps.
1.AutoSave Interval
In wordpress when you editing a post, it automatically saves at a specific time interval. The default time is 60 seconds.To save your database just increase the time delay.To do this, Open your wp-config.php file and add the below code.
define('AUTOSAVE_INTERVAL', 500 ); // seconds
To optimize Your MySQL Database 1.Go to phpMyAdmin and select your database. 2.click check all to select all tables of the database 3.In the drop down menu, click optimize tables . 4.Done
Wordpress database includes data such as your WordPress site settings, posts, pages and comments and settings for WordPress themes and plugins that you have installed.
Using WP-DBManager plugin
Author’s Description:
Allows you to optimize database, repair database, backup database, restore database, delete backup database , drop/empty tables and run selected queries. Supports automatic scheduling of backing up and optimizing of database.
1.Download WP-DBManager plugin from http://wordpress.org/extend/plugins/wp-dbmanager/
2.upload this plugin to www.yoursite.com\wp-content\plugins\ folder.
(more…)