Tag: SQL
-
How to Setup a LAMP Stack on Ubuntu 12.04 LTS
It seemed fitting that the first post on PHP Avenue should be about setting up a new server with PHP. This particular post will focus on a traditional LAMP stack (Linux, Apache, MySQL, PHP) on Ubuntu 12.04 LTS. I also intend on writing additional posts covering the setup of a…
-
Going Vanilla with MySQL
Over the last few years I’ve gotten down and dirty with MySQL’s config file, my.cnf. I read and re-read the MySQL documentation as well as any blog posts I could find on the subject. I was able to keep my connections low with caching and fought against the InnoDB buffer…
-
Drain your InnoDB Buffer Pool by moving large fields out of MySQL
This was supposed to be a “SceneKids.com the first year” post, but nothing has really changed too much since the 8 month post with the exception of expanding out with additional websites on the same platform. Instead, I’m going to discuss a dilemma I ran into with MySQL’s InnoDB data…
-
Setting up a secure MySQL server on Rackspace Cloud Servers
Recently I’ve been building out dedicated MySQL servers to combat some of the shortcomings we have encountered with hosting MySQL on Rackspace Cloud Sites (commentary on this will be saved for another post). During my research on what I could do to set up the server as securely as possible…
-
Using SQL’s IN syntax to search multiple fields
This may not be something new for anyone, but figured I’d post it anyway. I needed to check for a certain date in multiple fields, instead of listing each one out, I used IN but used the value on the left side, and listed the fields in the parenthesis. Before…
-
Issue with SQLyog Job Agent on Ubuntu
No error message, it just says that the sync had started. What sucks about this issue, is that I ran into it with a previous version of SQLyog Job Agent (sja) but was able to troubleshoot it faster because the program would dump an error message. I have been messing…