…execution time) of the query on which the view is based. The SQL features used in the query on which the view is…query execution time. It may be possible, therefore, to refresh an MV based on a query that takes 45 minutes to execute…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
Post: On Good Instrumentation
May 31, 2010 By 1 Comment
…is what called availability) and we want it to serve them with certain response time, which is what is…queries taking 30 seconds it is clearly slow queries. If it is 10.000 queries executed and total response time is 4 sec I know it is…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
…Query will execute queries in parallel over all of these machines. With enough machines, massive parallelism is…is a list of the queries, followed by a response time table recording the actual response times for each query. The queries…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
… baselines for comparison. First is speed of PHP Associative array. This is to show kind of peak… times. Examining MySQL full query logs from many applications seeing several exactly same queries executed during page load is… work and results will be wrong. So what is about results and how we can use…
Post: Caching could be the last thing you want to do
July 24, 2010 By 14 Comments
… PHP ecommerce package which makes me want to voice a recurring mistake I see in how many web applications are architected. What is… understand every execution plan of every query? If you don’t, set long_query_time=0 and use mk-query-digest to capture queries. Run… by only optimizing what is necessary to meet your goals.” – a quote from Justin’s slides on instrumentation-for-php. In…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…is wall time, the second exec time, the third parse time). $ echo “select count(*) from ontime_fact;” | ./run_query Array ( [count(*)] => 135125787 ) 1 rows returned (0.084244966506958s, 0.078309059143066s, 0.0059359073638916s) Execute…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is changes – …What is really bad is Parallel query. Reporting with group by over 10.000.000 of rows in real time is…. These would include support for query timeouts, parallel query execution, CONNECT BY support and various performance…
Post: Drop table performance
April 20, 2011 By 22 Comments
….com/bug.php?id=51325 and http://bugs.mysql.com/bug.php?id=56332…mutex, which prevents other queries from executing. So, this is a problem for a server…is also supposed to fix this problem. I ran a small benchmark to see what…_time int(11) NOT NULL, end_time int(11) NOT NULL, PRIMARY KEY (begin_time)) …
Comment: Why MySQL could be slow with large tables ?
November 13, 2010 By 139 Comments
… i have is PHP / MYSQL with a VPS with 768MB RAM. The total size of the MySQL is Just around 650 MB. What iam using to login check with this simple query “SELECT useremail,password FROM… it takes few minutes or else , it times out. My Max script execution time in PHP is set to 30 Secs. Any idea to improve…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…performance > critical queries if you need. Nice but using prepare/execute is more consistent with what I’ve…is wrong, but it’s not as common. > I would also note for many PHP applications abstraction layer is…of the time – yes – I agree. Learning to use query and external caching of result sets is …
