.bootstrap - Safe with most medications

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. Search Engine Optimization Without The Bullshit

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.

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. Forrester Research: Open Source Databases Are Cheaper
5. Optimize MySQL for Low Memory Use
6. Howto Install Oracle on Debian
7. Howto: How to Reset the MySQL Root Password
8. Executing SQL Statements from a Text File
9. MySQL Performance Monitoring and Optimization Tools
10. Optimize MySQL Performance With MySQLTuner

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:

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. Ubuntu Howto: Install Ruby and Ruby on Rails
6. Howto: Install Ruby and Rails on Debian or Ubuntu
7. Howto: Install Windows Vista Fonts in Ubuntu
8. Ubuntu Howto: Install Xen
9. Ubuntu and Ruby
10. Howto Install Fedora From a USB Flash Key Drive

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

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

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.

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

Related posts:

1. Sun acquires MySQL
2. Optimize MySQL for Low Memory Use
3. Recover (Crack) a password from a Microsoft Access Database (mdb)
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. Howto: How to Reset the MySQL Root Password
9. Executing SQL Statements from a Text File
10. Slow Query Log Analyzes Tools