… version as run by the native database interface (MySQL): mysql> select word, md5(word), md5(reverse(word)), count(*) from words2 group by 1… branches are combined with this. — AGGREGATION SQL: SELECT `word`,`md5(word)`,SUM(`count(*)`) AS `count(*)` FROM `aggregation_tmp_27656998` GROUP BY 1…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…greatest load on the server (in aggregate) and which cause the greatest latency…such as monitoring, alerting, backups, caching, reverse proxies, and high availability solutions, …
Post: Descending indexing and loose index scan
May 9, 2006 By 6 Comments
… in reverse order and it will well be. This is how MySQL will optimize indexed ORDER BY col DESC queries for example. Reverse… can workaround by having something like “reverse_date” column and using it for sort. With MySQL 5.0 you even can use… fact it was even implemented in MySQL 5.0, but only for very narrow case of aggregate queries. In general complete loose…
