Archive for the ‘ MySql ’ Category

FAQ | MySQLTuner

FAQ | MySQLTuner.

MySQLTuner

High-performance MySQL optimization script

» What can MySQLTuner do?

MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved.

It’s key to remember that MySQLTuner is a script which can assist you with your server, but it is not the solution to a badly performing MySQL server. The best performance gains come from a thorough review of the queries sent to the server, and an evaluation of the MySQL server itself. A qualified developer in your application’s programming or scripting language should be able to work with a MySQL database administrator to find improvements for your server. Once the server and application are optimized well, you may need to consider hardware upgrades to the physical server itself.

mytop – a top clone for MySQL

mytop – a top clone for MySQL.

mytop – a top clone for MySQL

About

mytop is a console-based (non-gui) tool for monitoring the threads and overall performance of a MySQL 3.22.x, 3.23.x, and 4.x server. It runs on most Unix systems (including Mac OS X) which have Perl, DBI, and Term::ReadKey installed. And with Term::ANSIColor installed you even get color. If you install Time::HiRes, you’ll get good real-time queries/second stats. As of version 0.7, it even runs on Windows (somewhat).

Links

Tested with my 5.0.77 community edition and it works very well.

pg2mysql converter (PostgreSQL to MySQL Converter)

The pg2mysql converter is an online tool to convert/migrate
existing PostgreSQL databases into MySQL. Simply dumping from Postgres
and importing to MySQL does not work because of differences in syntax and data types.
To use this converter, just create a postgres SQL dump:

pg_dump -U username -s dbname > dbname.sql

and copy and paste it into the text area below.
Click the Convert to MySQL button and the page will re-load with your new MySQL code that you can
copy out of the textarea into a text editor to save and import into your MySQL database.

Go to site