InnoDB Error Log File is of Different Size

I’m spending a lot of time on the Facebook group of openSUSE these days. Problems & issues that people post there actually keep me investigating; something I’ve been missing for some time. Today
Read More ›



Verify MySQL version

You got to verify your MySQL version? Here’s how you can do that from the command line: SELECT version(); or SELECT @@version;
Read More ›


LAMP in one command

Ever wondered if you could install the LAMP stack (on Linux Mint/Ubuntu) with one simple command? One would say let’s do: apt-get install php5 mysql-server apache2 However, there’s a shorter way of
Read More ›


MySQL Storage Engines

Data in MySQL is stored in files (or memory) using a variety of different techniques. Each of these techniques employ different storage mechanisms, indexing facilities, locking levels and ultimately provide a range of different functions
Read More ›


Change storage engine in MySQL

You can determine a list of storage engines by using the show engines command within MySQL. mysql> show engines; +------------+---------+------------------------------------------------------------+ | Engine | Support | Comment | +------------+---------+------------------------------------------------------------+ | MyISAM | DEFAULT | Default engine as of
Read More ›