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 Artemio Stenio posted a MySQL issue he encountered. The screenshot he shared could not provide much information, so I asked him to send the mysqld-upgrade-run.log instead. See an extract of the log: 130518 15: [Read More]

ERROR 1396 (HY000): Operation CREATE USER failed

It’s still fresh in memory, so I thought of blogging it right away. A couple of minutes back while migrating on the new VPS, I had some trouble restoring it’s db. I dumped all the databases from the old VPS and restored on the new one without error warnings. I assumed everything went fine. But the site, i.e would not show up. Instead [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 accomplishing that. Try the following: apt-get install lamp-server^ Or if you like things a bit more graphical, you could do: tasksel install lamp-server If you’re installing LAMP on openSUSE then your command should be [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 and capabilities. By choosing a different technique you can gain additional speed or functionality benefits that will improve the overall functionality of your application. Each of these different techniques and suites of functionality within the [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 MySQL 3.23 with great performance | | HEAP | YES | Alias for MEMORY | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | | MERGE | YES | Collection of identical MyISAM tables | | MRG_MYISAM | YES | Alias for MERGE [Read More]