hello peter, i wanted to know your insight about my problem. QUERY USED: SELECT DISTINCT MachineName FROM LogDetails WHERE NOT … MS SQL performs faster when they have the same specs though with different OS? 2) I know the memory can affect the performance but why has it not affected MS SQL much compared with MYSQL? 3) Any…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
… an amazingly useful metric for discovering periods of poor performance), and more. Analyze the distribution of service times. … are paired up. This is item #2 in my numbered list above. Let’s suppose that arrivals …the query, for example? With the text of the SQL in hand, we might be able to answer …
Post: Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
September 17, 2007 By 14 Comments
…is much larger). The other idea came to my mind is using GROUP BY WITH ROLLUP so… quite inconvenient whenever it is MySQL limitation or SQL Standard. This would be extremely useful feature and… inside MySQL. Why am I looking on reporting performance optimization ? It is for ClickAider project which is…
Comment: What to tune in MySQL Server after installation
July 27, 2008 By 118 Comments
… time I try to EDIT one of my posts, I am allowed (once) to perform the edit, but I then immediately receive this message: “WordPress database error: [You have an error in your SQL syntax… Internet Explorer (the problem occurs with either browser). What is “my SQL syntax”? Where does it “reside”? How can I “fix it…
Post: Color code your performance numbers
June 2, 2010 By 4 Comments
… percentile or 99 percentile. The problem is computing these in SQL is ugly and resource consuming. There is however a simple…. In fact I prefer to define 2 performance level. One what users would consider good performance, another what is acceptable, and basically… system has “two nines” in terms of performance – it responds with what we consider “good” performance in over 99% cases. I consider…
Post: Wow. My 6 year old MySQL Bug is finally fixed in MySQL 5.6
August 30, 2012 By 2 Comments
…responding with empty set MySQL truncates the constant, performs the lookup and only when discards results: CREATE …(even though you’re about 6 years over my expectations while reporting this bug). There are …be very loose by default. Consider running with sql_mode=strict_all_tables which will report …
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… that well. This is why it is important to test performance and scalability for your application on your hardware if you… look at the gain system shows from performance at 1 thread to the peak performance we see the number is 2.3…,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,my sql_parse,dispatch_command,do_command,do_handle_one_connection,handle…
Comment: Using LVM for MySQL Backup and Replication Setup
August 18, 2011 By 53 Comments
… replicated slave servers because of which as you can imagine performance goes for a toss and that causes slave to slow… this snapshot or the tar backup data and use another my sql instance to use that data and have analytics team to… on tar backup on another volume it wont impact our performance since it has nothing to do with slave ?? can we…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…not understand how to do that, so I generated big SQL file which contained load statements. Load of each chunk … This experiment was not really about InfoBright vs MonetDB comparison. My goal was to check how available OpenSource software is …if you want to compare or get info about air performance.
Comment: ORDER BY ... LIMIT Performance Optimization
November 2, 2006 By 100 Comments
… my case). Performance is much better. for 5 clients, 5 is OK instead of 20 in the sql. even put 100 there the performance…
