… very beginning of MySQL, however unless you carefully analyse and profile your queries, it might easily go unnoticed. I used it… SHOW STATUS output above, and then filters out those not matching the date range. A very inefficient approach! MySQL was unable to optimize those simple conditions to match both product id and date range by index and read…
Comment: Full text search for all MySQL Storage Engines
June 29, 2006 By 37 Comments
… last night 
11. Andrew: I have been using SPH_MATCH_ALL along with SPH_SORT_DATE_DESC/SPH_SORT_DATE… hits you will most likely miss newer posts which still matches unless you use the sort by date instead of sort… up the 200 best matches (desc by date or asc by date). As you can see the profile for sphinx to process…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… was taken though it was reached with number of sessions matching number of cores. Just 1 “Data warehourse” was used to…. Here is the graph: The CPU usage is normalized to match number of CPU cores used, so 100% in 2 cores… waiting by spinning on the spinlock wasting CPU cycles. Detailed profiling tells which one.
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… and you either can’t or don’t want to profile or debug the application to figure out what’s happening… 288124661 # This item is included in the report because it matches –limit. # Scores: Apdex = 0.97 [1.0], V/M = 19…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
… these benchmarks, I use pools of 4 connections, basically to match the number of available computing threads the Core i5 allows… MySQL is spending its time, I am planning to use profiling tools to identify the culprit but I had no time…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…/Key_read_requests. [Note: their use of 'rate' doesn't match mine; I would call this the 'miss ratio']. The problem… slow and is a problem for my application. I have profiled it with SHOW STATUS and I know it causes a…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… using ext2 filesystem and SysBench tool. Using 16K read sizes (matches Innodb page size) I could get 1.2GB/sec (80K… out other storage engines and other workloads or get some profiling results.
Comment: New MySQL Community Release Policies published
August 9, 2007 By 9 Comments
… to personally add it. 3) I’m not showing SHOW PROFILE is implemented as it should be I’m simply stating… free software I’m simply pointing out it does not matches goals of community, even those goals which were outlined by…
Comment: Opening Tables scalability
December 22, 2006 By 27 Comments
Here’s a piece of profiling data from live system, running lot of DBs without too … logins, filenames etc., mysql uses it’s own functions for matching data). As you can see those two functions alone consume…
Post: BoardReader - Forum Search Engine
November 29, 2006 By 13 Comments
… – note the graph which shows how many results were found matching this terms right from search results. It can show quite… period. Can be quite fun. Another nice feature is domain profile – by using it you can see how actively this domain…
