InnoDB support for MySQL Database Engine is not enabled in the my.cnf configuration file on XAMPP by default. If you need InnoDB features, such as one to many or many to many table relationships on foreign key constraints, or transaction-safe commands such as commit, rollback and crash recovery capabilities, you may activating innoDB support with […]
SuSE 10.2 : Installing MySQL Database Server
[for Bahasa Indonesia, please Click Here] Installing MySQL database server on SuSE Linux 10.2 (OpenSuse) should be easy as 1-2-3. Just click Yast, navigate to Software Management and then search MySQL Database Server. After Accept new installation, MySQL Database Server will be up in a few minute(s). If you get MySQL Database Server not running […]
MySQL Amazing Tips for improve, tuning and increase MySQL Performance
Berikut adalah beberapa tips untuk meningkatkan kecepatan akses database MySQL. Taken from my personal Blog. 1. Memperbaiki DNS setting dan memasukkan ip address / nama host client yang mengakses mysql kedalam file /etc/hosts di server mysql. Proses edit file /etc/hosts ini bisa dilakukan menggunakan webmin ataupun diedit langsung. Saya sendiri menggunakan webmin karena biasa melakukan […]