Category Archive: MySQL

Mar 30

How to: Install and use MySQLTuner to Optimize your MySQL configuration / performance

How to: Install and use MySQLTuner to Optimize your MySQL configuration / performance I am writing this post mostly because there is in my opinion a much better way to install MySQLTuner on your machine that the usual apt-get install MySQLTuner. As many of you would probably already know MySQLTuner is a well known and …

Continue reading »

Feb 12

How to: Get the size of your Databases in MySQL Query Browser

How to: Get the size of your Databases in MySQL Query Browser Imagine you want to transfer data from one server to another and you need to know the size of the databases you are thinking of transfering. Unlike Microsoft SQL Server which graphical interface allows you to see the size of the database files …

Continue reading »

Dec 21

MySQL: How to list all available tables in the system

MySQL: How to list all available tables in the system Because sometimes you just need to know (the available tables are out there so you can use that list in a script). If you are running MySQL Workbench you can execute the following SQL Query and export the results to a file: select table_name from …

Continue reading »

Dec 12

How to: Install MySQL in an Ubuntu Server

How to: Install MySQL in an Ubuntu Server If you are looking into deploying MySQL as part of a “LAMP” installation or whatever flavors you like best, Ubuntu is a good OS to do so. I say that because they make the installation super easy from the command line with apt-get, it doesn’t get much simpler …

Continue reading »

Dec 10

How to: Reset the Auto Increment value for a MySQL table

How to: Reset the Auto Increment value for a MySQL table Although this is something most people won’t need to do, there are some scenarios where you want to reset the ID value you have in a column. In my case for example, I am working with WordPress and the blog ID is set based …

Continue reading »