…which supports incrementally maintaining materialized views. While writing Flexviews, I learned how to distribute the computation…under the proxy. The databases do 99.9% of the work, due to the multiple levels…distribute work over any type of compute resource which speaks SQL, but right now only MySQL…
Post: Using VIEW to reduce number of tables used
September 28, 2007 By 12 Comments
… to the same table as VIEWs are significantly less expensive and cheap to “open”. How this could work ? Say you have “post” tables… do not insert data in the view which will be invisible. The VIEW approach works for SELECT, UPDATE, DELETE queries but not for INSERT: mysql…, which does not work as it has to be different for each of the views. You could think MySQL would look at the…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
…that couldn’t be answered during the talk: Q: How do you install the tools? The manual has full details…I’m working on a server without the toolkit installed. Q: How to make the tools connect to MySQL The …from the timestamp list (the timestamp list is the view you get when first running pt-sift). Q: …
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… does not work for subselects, inline views, parts of the UNION. This is also common missunderstanding. Works on packet… caching for certain queries, which you know do not need to be cached. Counting query…’t change how it works with MySQL to add caching but you can enable query cache so it works …
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…NTP won’t work. So far for background and theory, from the practical point of view, you…mysql replication are independent from each other. Q: I installed Percona as cluster database working with Zabbix (innodb), do… remove it before going to production. Q: How would you migrate to XtradbCluster from a…
Post: Just do the math!
July 6, 2009 By 4 Comments
… page views a day you few days of history the queries there instant which gave you a confidence this approach will work… example. Before you can do the math (or say apply mathematical model) you really need to understand how things work. I like to call it having X-Ray vision. If you do not understand what is happening and you see MySQL…
Post: MySQL - to use or not to use
May 28, 2007 By 10 Comments
…Oh yes I know, it comes from the point of view market old timers try to show the value …or how to use MySQL not just if it should be used or not. There are many applications when MySQL works great… from MySQL simply so MySQL Development is continued. My point is simply you do not have to do if you do …
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
…works for SELECT only This is in works to be fixed in some of next version but it is so as of MySQL… it is impossible to tell as we do not know how much data we’ll need to sort … least an alternative view. If you want to find more information about understanding EXPLAIN output, MySQL manual EXPLAIN …
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…how much data we can comfortably put in MySQL Instance without getting in too much trouble with backups etc – because Sphinx is doing… on the memory fit diagram – understanding your working set is paramount but taking number from …. I also fully support Matt in his views of black boxes. If you want to…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
…working set is bigger than the server’s memory, or b) the workload is write-heavy. If this is the case, how…displayed by iostat is confusing, and you have to do some tedious math to get something approximating the …aggregated together in each line. I can switch the view of the same data to look at it …
