Archive

Posts Tagged ‘MySQL’

Profiling MySQL Queries – Part 1

February 21st, 2012 No comments

You website is slow. You suspect MySQL queries are slow, but don’t know where to begin. This article, aimed at intermediate developers, will present my methodology and serve as a starting point for first-timers. I won’t go in-depth, only cover some of the basics.
Read more…

doctrine:insert-sql for MAMP users

August 10th, 2009 3 comments

One of my computers has MAMP installed. I was trying to build a database schema from a YAML file. When time came to insert the SQL using…

>php symfony doctrine:insert-sql

the following error message appeared:

>Couldn’t locate driver named mysql

MySQL worked fine on this computer for many years so a missing driver was out of the question. After some thinking I realized that the command “php” actually refers to OS X version of php and not the one that ships with MAMP. Since I was too lazy to properly configure the extensions for the OS X version, I simply pointed the “php” command to the MAMP version using the following line:

>alias php=’/Applications/MAMP/bin/php5/bin/php’

I ran the symfony command again and it worked perfectly!