Unless you changed the default, this will be 16 MB: mysql> SHOW VARIABLES WHERE Variable_name="max_allowed_packet"; +--------------------+----------+
Sometimes, you may want to open up a second database connection, to a read slave or another database. When doing...
Take care in queries where multiple AND or OR operators are used. In doubt, always use braces to enforce precedence...
This will make MySQL log all received queries so you can see for yourself what happens on the database level...
ActiveSupport >= 3 has Date.parse('2011-02-10').beginning_of_quarter #=> 2011-01-01 Date.parse('2011-02-10').end_of_quarter...
If you upgrade to the mysql2 gem, you will run into the problem that the server's database.yml (which is...
Some advice for bulk loading many records into InnoDB and finishing before the sun burns out. Use with care.
MySQL version 5.1 comes with an alternative, faster InnoDB implementation (called "InnoDB Plugin"). Switching is easy: Stop your mysqld with...
When requests arrive at the application servers simultaneously, weird things can happen. Sometimes, this can also happen if a user...
How to call routes, make requests and try out helpers from the Rails console.
An association defined with has_many :through will return the same record multiple times if multiple join models for the...
This is for you if Passenger gives you the following useless error message. Passenger encountered the following error:\ The application...
When talking to your MySQL server via a mysql shell, you can terminate queries by ; or \G -- the latter gives...
Usually you don't need to, but when you want to see which queries your MySQL server currently needs to...
When you do a script/dbconsole -p, your MySQL shell will already be using UTF-8. When you call it yourself...
In MySQL comparing zero to a string 0 = "any string" is always true! So when you want to compare a...
Possible Reason 1: parallel_tests - running more processes than features If you run old versions of parallel_tests with more...
Though Internet Explorer 9 supports the box-shadow CSS property there is a nasty bug which sometimes prevents it from...
When selecting records in a date range, take care not to do it like this: start_date = Date.parse('2007-05...
Basically, you now need to know if your project uses a "real" time zone or :local, and if config.active_record.time_zone...
In your Cucumber features you can't really click hidden elements when using Selenium (it does work for a plain...
Add a separator between left-aligned and right-aligned items. In the separator properties, set the style to "Transparent" and...
The SQL code generated by Graticule's spherical distance computation is insufficient and can lead to NULL distances in edge...
When you have objects in your database that hold latitude and longitude and you want to find others that are...