Tag Archive: MySQL

May 17

Resolved: [hphp] Warning: Parameter 1 to W3_Plugin_TotalCache::ob_callback() expected to be a reference, value given in /wp-includes/functions.php on line 3282

Resolved: [hphp] Warning: Parameter 1 to W3_Plugin_TotalCache::ob_callback() expected to be a reference, value given in /wp-includes/functions.php on line 3282 As you probably know (otherwise you would probably not be here), after deciding to move form PHP to HHVM, if you are running a WordPress site and use W3 Total Cache you will encounter an endless …

Continue reading »

Sep 18

Resolved: Blank pages when using NginX with php-fpm

Resolved: Blank pages when using NginX with php-fpm As of late I have been a bit busy so keeping up with updates to the web server has been pretty much neglected. Because of that I decided to switch to the nginx.org supported distribution to get the latest updates although that means a distribution without any …

Continue reading »

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 »

Mar 30

How to: Install the MySQL Agent for NewRelic in an Ubuntu server

How to: Install the MySQL Agent for NewRelic in an Ubuntu server As part of a series of posts (How to: Install the Memcached Agent for NewRelic in an Ubuntu server and How to: Install the NginX Agent for NewRelic in an Ubuntu server) I am including instructions on how to install the MySQL monitoring agent …

Continue reading »

Feb 24

How to: Have WordPress communicate with MySQL via Socket

How to: Have WordPress communicate with MySQL via Socket As I keep looking into how to improve the performance of website one of the recurrent points mentioned is to use Linux sockets where possible. I really don’t have much experience and I can see how avoiding the TCP stack might help but I figured at …

Continue reading »

Feb 20

How to: Install, Update and Remove RubyGems

How to: Install, Update and Remove RubyGems I just had a brief experience installing a RubyGem so I thought I would share a little bit of what I learned about managing RubyGems. Similar to packages (apt-get) you can search through them, install them, remove them, and update them with simple commands. Below is a brief …

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 »

Older posts «

Fetch more items