There is no variables like memory_limit in MySQL my.cnf file – therefore you can’t explicitly set the memory limit for MySQL. You have to configure your my.cnf file based on a combination of variables. These then multiple together to form the MySQL memory limit. I hope this help someone.
I just upgraded MySQL from 5.5 to 5.6 and changed all the tables in the PHPBB3 database into InnoDB tables. I did this because InnoDB is faster if you have lots of concurrent read / writes and MySQL 5.6 finally support FULLTEXT searching using InnoDB. However, I made a mistake and did the conversion to … Read more
Ubuntu 14.04 comes with both MySQL 5.5 and MySQL 5.6 and by default uses MySQL 5.5. However, you can upgrade to MySQL 5.6 by doing the following steps: Step 1 – Take a backup! Step 2 – Remove the old MySQL I recommend using ‘apt-get purge’ rather than ‘apt-get remove’ to uninstall the old MySQL … Read more
I’m just building a map of some ip addresses and need to geolocate them. I decided to use the MaxMind database. I found these two brilliant resource without which I could not have imported the databases properly. There are: http://www.dbasquare.com/2012/06/01/implementing-efficient-geo-ip-location-system-in-mysql/ http://nickbartlett.com/wordpress/using-maxmind-geo-city-lite-database-on-your-website/
I generally setup binary logs on a MySQL server where the data isn’t being replicated and I’m using daily mysql-dumps to backup the data. This allows me to recover the database to a specific point in time. However sometimes the binary logs can become very large if there are lots of changes occuring to the … Read more
There isn’t a simple command to rename a mysql database. You just need to create a new database and then rename all the tables like so: There is also an alternative method by dumping the old database and importing it again like so: I have found the second option to be alot faster both in … Read more
I rebooted an Ubuntu 12.04 server after upgrading the kernel and MySQL. However, I found that the new MySQL would not start. When I tried: sudo service start mysql I got: start: job failed to start There were no errors appearing in the /var/log/mysql/error.log and so there was no information to help debug it. I … Read more