Entries Categorized as 'MySQL'

MariaDB Unknown/unsupported storage engine: InnoDB

Date March 13, 2017

I had this problem re-occurring in one of my servers. MariaDB wont start due to this error. To fix my problem, remove these log files… /var/lib/mysqld/ib_logfile0 /var/lib/mysql/ib_logfile1 /var/lib/mysql/aria_log_control ib_logfile may be 0 or 1 If you want to be safe.. just rename it to another file temporarily to see if it works. Sources for the […]

Enable Ubuntu 16.04 SSH Tunneling at Boot Time

Date September 16, 2016

I wanted to connect to a remote server and setup a tunnel for my MariaDB replication ( yes I migrated to MariaDB ), the only problem was that sometimes the net is erratic and can’t connect right away on boot time. Found a code online to check for ping reply, if it does, continue with […]

Regenerate Missing MariaDB/MySQL Config(my.cnf) File

Date August 15, 2016

I ran into this problem after upgrading/intalling MariaDB, the config file was missing.   To regenerate the config file… try executing… 1 dpkg –force-confmiss -i /var/cache/apt/archives/mysql-common*.debdpkg –force-confmiss -i /var/cache/apt/archives/mysql-common*.deb

MySQL 5.6 and Up: High Memory Usage

Date April 27, 2016

Had a problem with a fresh install of MySQL 5.7 using more than normal memory. Researching around the net, one feature that was added (5.6?) that fixed my problem was performance schema ( performance_schema ). Disabling is easy enough as adding performance_schema=0 in my.cnf config file.   Thanks to Joel Abraham for the fix.

Connecting to MySQL on a Remote Server through Port Forwarding and Reverse SSH Tunnel

Date March 9, 2016

I had a problem connecting to a remote server that has its ports blocked by the ISP. So technically, I can’t port forward my way into the server. The only way around this is to SSH connect from my remote server to my main server and access the remote server via reverse SSH tunneling. This […]

MySQL Slave Failed to Open the Relay Log

Date October 20, 2008

This problem is a little tricky, there are possible fixes that MySQL website has stated. Sad to say, the one’s I read in the forum and site didn’t fix my problem. What I encountered was that the relay-bin from my MySQL slave server has already been ‘rotated’, meaning deleted from the folder. This happens when […]

MySQL: Query Real Values from Delimiter-Separated-String-IDs

Date September 15, 2008

I had a problem in using a string-comma-separated-value returned from a query in an “IN” statement. I used the IDs from one table, concat them into a comma separated value and insert them into another table. Baaaad idea… Now when I query that value, I can’t use it directly into an “IN” statement to retrieve […]