… Flexviews (the primary purpose of FlexCDC). Feed search engines like Sphinx or Solr only the rows that change. Feed third party…`.`demo`. mysql> select * from flexviews.test_demo\G *************************** 1. row *************************** dml_type: 1 uow_id: 10 fv$server_id: 999 c1: 2 c2: 2…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… KB physical id : 1 siblings : 4 core id : 3 cpu cores : 4 fpu : yes fpu_exception : yes cpuid level : 10 wp : yes… /path/to/slow.log By default, this outputs the top 10 most expensive queries, in total execution time. By the way… (we may suggest caching, or tell the customer to evaluate Sphinx, or something like that.) In the common case, though, a…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…schema changes, use of replication, caching, using memcached, sphinx, implementing proper web caching etc. These changes …even virtual) rented server which would usually have 1-2GB of memory may be couple of … one server optimizing your application very modest 10% does not give you much benefit – you …
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…other marketing costs. If your downtime cost is under $10/h, you can stop reading this document, you … most common questions, I might have missed some. 1. What level of HA do you need? Since …indexes might be replaced by another search engine like Sphinx in order to remove the restriction. There is …
Post: Getting around optimizer limitations with an IN() list
January 9, 2010 By 9 Comments
… y BETWEEN 50 AND 60 AND col_a = ‘set1′; +———-+ | count(*) | +———-+ | 1 | +———-+ 1 row in set (0.00 sec) SELECT count(*) FROM coordinates….69,33.79,33.93,34.62,34.78,35.10,35.41,36.62,36.93,37.17,38.93… want to do these types of queries, you should give Sphinx a try.
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… aspects why I’m especially interested about it is Sphinx which is currently implemented as storage engine for …bad is Parallel query. Reporting with group by over 10.000.000 of rows in real time is …. I’m saying about Prepared Statements in MySQL 4.1 which came without query cache support but even …
Post: UDF -vs- MySQL Stored Function
September 6, 2010 By 8 Comments
… lot of data before pushing it to sphinx – MySQL did not have a function to… really – building the index, which was taking 10 minutes, was now taking 16 minutes. Then… where author != ltrim_junk(author); +———-+ | count(*) | +———-+ | 28335 | +———-+ 1 row in set (6.63 sec) mysql> …
Post: New Keynote Speakers and Sponsors and Applications Open for DotOrg Pavilion for Percona Live MySQL Conference and Expo
January 22, 2013 By Leave a Comment
…was enthusiastically received by more than 1,000 attendees, many of whom …, Drizzle, and MySQL Sandbox. Applications close February 10. Sponsors I’m pleased to …Exhibitors: Akiban, Altoros, Booking.com, Codership, PalominoDB, Pythian, Sphinx, ScaleArc, STEC, Tokutek • Media Sponsors: Database Trends …
