MySQL Performance Monitoring and Optimization Tools

at · Tags: , , , , , , , , , , , , ,

Tools | MySQL Performance Blog

This page contains links to various tools we found helpful to use in practice.
Some tools are written by us, others by third parties, yet another ones may be shipped with your operating system you just need to find they are there.

Related posts:

  1. MySQL Optimization and Performance Tips
  2. Optimize MySQL Performance With MySQLTuner
  3. Slow Query Log Analyzes Tools
  4. MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
  5. Sun acquires MySQL
  6. Optimize MySQL for Low Memory Use
  7. Howto: How to Reset the MySQL Root Password
  8. AMD DDR2 Linux Performance
  9. Linux Terminal Speed Performance Comparison
  10. MySQL: Remove Duplicate Entries

Comments (1)

MySQL Optimization and Performance Tips

at · Tags: , , , , , , ,

  • Store IP addresses as INT, not CHAR – by using INET_ATON to convert from a string to an integer and by using INET_NTOA to convert from an integer to a string
  • Use non-persistent connection, since they are light-weight – much faster create than compared Oracle or PostgreSQL

  • Use the right storage engine; this means for example the ARCHIVE-engine for logs and other kind of INSERT-only operations, and the MEMORY-engine for fast in-memory data that should go away on server restart

More general MySQL optimization and performance tips are available in this Slideshow.

Related posts:

  1. Optimize MySQL for Low Memory Use
  2. Optimize MySQL Performance With MySQLTuner
  3. MySQL Performance Monitoring and Optimization Tools
  4. MySQL Concatenate: Adding String At The End Of Field Data
  5. Howto: How to Reset the MySQL Root Password
  6. Linux Terminal Speed Performance Comparison
  7. MySQL: Remove Duplicate Entries
  8. MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
  9. Slow Query Log Analyzes Tools
  10. Migrate existing Ext3 filesystems to Ext4

Comments (2)

Sun acquires MySQL

at · Tags: , , , , , ,

MySQL was recently named a top IPO for 2008 by CNNMoney.com, but Sun came ahead. It will be interesting to see in what direction Sun will drive MySQL.

MySQL Logo

About MySQL

MySQL is the leading open-source database company on the planet. Its software might not have the bells and whistles of Oracle 11, but it also comes at a much cheaper price. According to the venture capitalist lunch chatter, MySQL is expected to file very soon.

Related posts:

  1. MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
  2. Ubuntu Howto: Install Oracle
  3. MySQL Optimization and Performance Tips
  4. Howto Install Oracle on Debian
  5. Optimize MySQL for Low Memory Use
  6. Forrester Research: Open Source Databases Are Cheaper
  7. Howto: How to Reset the MySQL Root Password
  8. Executing SQL Statements from a Text File
  9. MySQL: Remove Duplicate Entries
  10. MySQL 5.0 Release Candidate

Comments

Ubuntu Howto: Install Oracle

at · Tags: , , , , , , , , , , , , , , ,

Installing Oracle on Ubuntu is fairly easy, since Oracle has created a Debian and Ubuntu package repository, so it is possible to download and install the Oracle database software using apt-get and aptitude.

Howto use the Oracle Debian and Ubuntu Repository:

Add the following lines to the /etc/apt/sources.list

# Oracle Repository
deb http://oss.oracle.com/debian unstable main non-free

Update the package repository database with:

cc@ray:~$ sudo apt-get update

Now you should be able to install the following Oracle software:

  • libaio
  • oracle-xe-client
  • oracle-xe
  • oracle-xe-universal

Install the Oracle Express packages

sudo aptitude install oracle-xe oracle-xe-client

Configure using:

sudo /etc/init.d/oracle-xe configure

Access the nice Oracle web interface by pointing your Firefox to:

http://127.0.0.1:8080/apex

Updated:
The installation process might report that the Oracle packages are not gpg signed, but you should be able to install the packages anyway.

You can avoid this report by added the Oracle gpg-public key to your apt-key chain

wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | sudo apt-key add -

Read more on Oracle and Debian and Ubuntu here

Related posts:

  1. Howto Install Oracle on Debian
  2. Ubuntu Howto: Install Sun Java
  3. Howto: Create your own Debian or Ubuntu package repository
  4. Howto Install Sun Java on Debian Etch
  5. Howto: Install Ruby and Rails on Debian or Ubuntu
  6. Ubuntu Howto: Install Ruby and Ruby on Rails
  7. Howto Install Fedora From a USB Flash Key Drive
  8. Howto: Install Windows Vista Fonts in Ubuntu
  9. Ubuntu Howto: Install Xen
  10. Ubuntu and Ruby

Comments (14)

Howto Install Oracle on Debian

at · Tags: , , , , , , , , , , , , ,

Installing Oracle on Debian is fairly easy, since Oracle has created a Debian repository, so it is possible to download and install the Oracle database software using apt-get and aptitude.

Howto use the Oracle Debian Repository:

Add the following lines to the /etc/apt/sources.list

# Oracle Repository
deb http://oss.oracle.com/debian unstable main non-free

Update the package repository database with:

cc@ray:~$ sudo apt-get update

Now you should be able to install the following Oracle software:

  • libaio
  • oracle-xe-client
  • oracle-xe
  • oracle-xe-universal

Install the Oracle Express packages

sudo aptitude install oracle-xe oracle-xe-client

Configure using:

sudo /etc/init.d/oracle-xe configure

Access the nice Oracle web interface by pointing your Firefox to:

http://127.0.0.1:8080/apex

Updated:
The installation process might report that the Oracle packages are not gpg signed, but you should be able to install the packages anyway.

You can avoid this report by added the Oracle gpg-public key to your apt-key chain

wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | sudo apt-key add -

Read more on Oracle and Debian and Ubuntu here

Related posts:

  1. Ubuntu Howto: Install Oracle
  2. Howto Install Sun Java on Debian Etch
  3. Ubuntu Howto: Install Sun Java
  4. Howto: Create your own Debian or Ubuntu package repository
  5. Howto: Install Ruby and Rails on Debian or Ubuntu
  6. Howto install Java on Debian Sarge
  7. Howto Install Fedora From a USB Flash Key Drive
  8. Howto install Sun Java on Debian Sarge
  9. Howto duplicate a debian setup
  10. Howto: Write Debian Package Descriptions

Comments (4)

Forrester Research: Open Source Databases Are Cheaper

at · Tags: , , , , , , , , , , , , , ,

Open source databases can save enterprises up to 60 per cent over proprietary products, according to data collected by Forrester Research.

Noel Yuhanna, a senior analyst at Forrester covering database management systems, estimated that average savings on the total cost of ownership are about 50 per cent. The data is based on surveys and customer interviews.

Open source databases such as Enterprise DB, Ingres and MySQL do not carry licence fees, and management tools tend to be less expensive than for proprietary databases from Oracle, Microsoft and IBM.

Open source databases ’60 per cent cheaper’ @ Vnunet.com

Related posts:

  1. Nasdaq moves to open-source
  2. Skype Open Source
  3. InfraRecorder: Open Source CD Burning for Windows XP/Vista
  4. Ubuntu Howto: Install Oracle
  5. Sun acquires MySQL
  6. an ex-microsoft employee’s view on Linux and the open source community
  7. Windows Open Source Software
  8. Open Source EPJ
  9. MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
  10. Major List of Useful Open Source and Freeware Software

Comments

Oracle’s Unbreakable Linux, broken by default

at · Tags: , , , , ,

This week Oracle stated that their own Linux version (read: fork) of Red Hat’s Enterprise Linux was more refined and better than its Red Hat competitor/flavour, but according to this review, Oracle’s Unbreakable Linux seems broken by default.

Related posts:

  1. Ubuntu Howto: Install Oracle
  2. Howto Install Oracle on Debian
  3. Dell: Linux Rolls On
  4. Java default keystore password – cacerts
  5. /dev/hello_world: A Simple Introduction to Device Drivers under Linux
  6. an ex-microsoft employee’s view on Linux and the open source community
  7. Windows Developers Begin Slow Defection to Linux
  8. Linux developers considering move to Eclipse
  9. Red Hat Enterprise Linux 5 Released
  10. Giant Firewall Runs Linux

Comments

MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL

at · Tags: , , , , , , , , , , , , , ,

Today I was working on how to convert an old Microsoft Access database into a MySQL database. This convertion could be obtained by first converting the tables in the mdb-file into CSV-files (Comma Separated Values) using MDB Tools and then by importing the csv-files into MySQL using phpMyAdmin.

To export a given table from a mdb-file, we type:

mdb-export db.mdb customers >> customers.csv

In my case, since I got some danish characters, I need to force mdbtools to encode everything as ISO8859-1 instead of UTF-8, which is the default. This can be done by setting the environment variable MDB_ICONV to ISO8859-1

export MDB_ICONV="ISO8859-1"

The resulting CSV-files coult be imported into MySQL using phpMyAdmin.

MySQL Logo

Another howto on database migration ms2pg – Migrate Microsoft SQL Server Database to PostgreSQL Database.

Related posts:

  1. Sun acquires MySQL
  2. Recover (Crack) a password from a Microsoft Access Database (mdb)
  3. Optimize MySQL for Low Memory Use
  4. MySQL Performance Monitoring and Optimization Tools
  5. NO to the Microsoft Office format as an ISO standard
  6. Forrester Research: Open Source Databases Are Cheaper
  7. MySQL Optimization and Performance Tips
  8. Executing SQL Statements from a Text File
  9. Howto: How to Reset the MySQL Root Password
  10. Microsoft and the OpenDocument format

Comments (6)