Skip to content

{ Tag Archives } MySQL

AMO Scalability: Then and Now

Struggling with scalability on AMO is nothing new but the tools we use to solve the problems have changed over time. Here is a bit of information on the performance evolution AMO has gone through. I wanted to link to the wayback machine for all our old versions, but I get “Redirect Errors” [...]

Also tagged , , , ,

When is a TINYINT(1) not a TINYINT(1)?

When you’re using CakePHP!
Turns out CakePHP considers a TINYINT(1) to be a Boolean. Judging from all the support tickets that have been filed, I’m not the first person to get taken off guard by this behavior. When I asked about it on IRC, the response was that since MySQL considers a TINYINT(1) to [...]

Also tagged , ,

If it’s a string, call it a string

This is probably well documented, but it’s a good reminder anyway. If you’ve got a column in MySQL that is textual (like a varchar), you need to make sure MySQL sees the data going into it as a string. Here’s an example I stumbled across today when I left out some quotation marks [...]

Also tagged