Posts Tagged “mysql”:

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,... [Read More]
Tags: mysql database

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.... [Read More]
Tags: mysql

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]
Tags: mysql

LAMP in one command

![LAMP](/img/2017/02/lamp-mint.jpg) 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... [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... [Read More]
Tags: mysql

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... [Read More]