I happened upon the selectSQLText function in the MediaWiki source code and learned how to set a query timeout in either MySQL or MariaDB. Good to know!
Setting query timeout for MySQL or MariaDB
Reply
Tag Archives: query
Wikipedia: All public logs
Today I discovered this on Wikipedia: All public logs. It’s interesting to see that for something as huge as Wikipedia they still only process a command (vs query) every few seconds.
MySQL admin with Ian Gilfillan
I was doing some reading today and I came upon an old series of articles over on www.databasejournal.com by a dude called Ian Gilfillan:
- MySQL backups
- Database Replication in MySQL
- Restoring lost data from the Binary Update Log
- Optimizing MySQL: Queries and Indexes
- Optimizing MySQL: Hardware and the Mysqld Variables
- MySQL’s Query Cache
- MySQL’s Over-looked and Under-worked Slow Query Log
For the ‘type’ in SQL ‘EXPLAIN’ Ian says: from best to worst the types are: system, const, eq_ref, ref, range, index, all.
It seems this Ian Gilfillan fellow has been rather prolific.
CSS Media queries
Heard about CSS Media queries today. It’s a table of CSS media queries that can help you figure out what sort of a device you are on.