… also give internal presentations for your company or group. Sphinx search engine for RDBMS Egypt, December … 2007 Tips and Tricks on how you can speed up various things in MySQL as well as … and comparing it to the alternatives. Slides by Andrew Aksenoff, Russian Language. Download MySQL Performance …
Post: Percona Server 5.1.50-rel12.1
October 14, 2010 By 2 Comments
…time_distribution – Counts queries with very short execution times and groups them by time interval. (Oleg Tsarev) Bugs Fixed Bug #608992 – … Bug #640924 – Fixed a crash caused by innodb_doublewrite_file. (Yasufumi Kinoshita) Bug #643650 – Speeded up InnoDB shutdown when using shared memory buffer…
Comment: Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
January 14, 2008 By 14 Comments
…up you could do the following. Since you already have the counts, as long as you grouop by… does not change the counts, and you gain speed by using the limit in the subquery. SELECT grp ,… count(*) cnt FROM dt WHERE slack LIKE “a%” GROUP BY grp ORDER BY cnt DESC LIMIT 10 ) t1 GROUP BY grp WITH rollup;…
Comment: Full text search for all MySQL Storage Engines
June 28, 2006 By 37 Comments
… have found that LZF will bring me compression while the speed will not be as much affected as if using gzip… | vector2, and so on. So this means that also the speed of the search is significally improved since having a search… reversed index which might end up with 500.000 items of each word to process, group by, order by and so forth until the…
Comment: MySQL Partitioning - can save you or kill you
June 28, 2012 By 45 Comments
… FROM ObjectInstances_T where ObjectClass in (…) and ObjInstance in (…) GROUP BY ObjInstance) o2 where (o1.ObjInstance = o2.ObjInstance and o1…. secondary keys; they are possibly useless. This will greatly speed up INSERTs. > PRIMARY KEY (`ObjectClass`, `ObjInstance`, `UTCTime`), Including a time…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
… slave server in a replication environment, the process can be speed up by having prefetch threads to warm the server: replay statements and…, support, training, and custom development Release notes Documentation Developer discussion group
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… slave server in a replication environment, the process can be speed up by having prefetch threads to warm the server: replay statements and…, support, training, and custom development Release notes Documentation Developer discussion group
Comment: Speeding up GROUP BY if you want aproximate results
September 4, 2008 By 24 Comments
Hi all, I wonder if this procedure would seed up a very slow query in my application: There is a … INTERVAL query: SELECT INTERVAL(x,50,101), count(*) FROM table GROUP BY 1; Problem is: mysql can’t use an index on… there a way I can use BINARY CRC32() to speed things up? Are there better ways to solve this issue than using…
Comment: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
…. I speed up two of my greylist sql commands from around 15 min to under 2min, mainly from the order by null. I… it would default to some kind of order method for group by.
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… memcache you end up reducing number of reads from database dramatically but writes still have to happen at full speed. It also… would always give you correct counters while being very efficient. By doing these delayed updates you can not only reduce number… the views within last hour has to run rather complicated group by query ? Sure it does but it does not have to…
