Tools to manage popular database systems

,,,,,,, March 31, 2023  No Comments

There are several tools available for interacting with Relational Database Management Systems (RDBMS). These tools can help you manage, query, and analyze data stored in your databases. Here’s a list of some popular tools for different RDBMS:

  1. MySQL:
    • MySQL Workbench: An official, integrated environment for MySQL database design, administration, development, and management.
    • phpMyAdmin: A widely used, web-based administration tool for MySQL and MariaDB databases.
    • SQLyog: A feature-rich, graphical tool for managing MySQL databases with a user-friendly interface.
  2. PostgreSQL:
    • pgAdmin: The most popular, open-source administration and management tool for PostgreSQL databases, available for multiple platforms.
…
How to optimize all databases and tabels on mysql server?

How to optimize all databases and tabels on mysql server?

,,,,,,, September 13, 2012  No Comments

Optimization of database tables in mysql is a process which has to be carried out regularly to make your database in good health.

According to mysql manual,

OPTIMIZE TABLE should be used if you have deleted a large part of a table or if you have made many changes to a table with variable-length rows (tables that have VARCHAR, VARBINARY, BLOB, or TEXT columns). Deleted rows are maintained in a linked list and subsequent INSERT operations reuse old row positions. You can use OPTIMIZE TABLE to reclaim the unused space and to defragment the data file.

…