… well. I believe Query Storage would benefit a lot from fast compression, such as QuickLZ. Results sets for most queries is… INFORMATION_SCHEMA tables. Self Refresh MySQL Query Cache causes not uniform performance as you get very fast responses for hits but you… make it cool again. The question is whenever anyone from “MySQL Market Players” – Oracle, MariaDB, Drizzle, Percona Server, will allocate resources to…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… of 90s when MySQL appeared on the market many web applications were simple and often not using database at all. MySQL did not… see Violin Memory appliance which can be used with MySQL to get very fast IO and so consolidate system suffering from IO… social graph or permissions). I would expect MySQL to continue to drill into Enterprise market during next few years but Web Applications…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… of customers who do click analysis, site analytics, search engine marketing, online advertising, user behavior analysis, and many similar types of… MySQL doesn’t tend to perform well on a data warehousing workload. The nested-loop joins are not all that fast… some of MySQL‘s weaknesses in some cases. Not only that, but star schemas are not intended to be fast. The star…
Post: All thouse new MySQL Storage Engines
April 17, 2008 By 8 Comments
…I’ve seen enough of marketing benchmarks at my life to really believe them. Marketing benchmarks typically show the … does a lot of primary key lookups and MySQL Cluster promises good performance and scalability. But if… with complex Joins which you need to work fast as well this may not be the right …
Post: Virident tachIOn: New player on Flash PCI-E cards market
June 15, 2010 By 19 Comments
… and it will finally bring some competition to the market, which I believe is good for the end users…which has no enough time resolution for such very fast operations) As you can see we can get … (important in question for log related activity in MySQL) I am looking forward to present results in …
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… to say the truth MySQL does not provide much of the functionality for scale out itself, besides its fast and simple replication… strong guarantees. It is same as with MySQL Replication – the reason it is fast and has low performance overhead on the master… can figure things out and even patch MySQL if needed. So MySQL went to chase Enterprise market and develop enterprise features pushing back…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…a SaaS hosted application for data mining stock market transactions,” or whatever the case may be…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… of queries matter. Some may be extremely fast, but run very often; others may be…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… number of third party storage engine presented, main marketing message – Storage Engine partnership with IBM, “Clash of … pages which do not fit in compressed space. Fast Index Creation This is another feature which I … where already which may come in MySQL 5.2 or even MySQL 5.1. I surely would like …
Post: Percona Server and XtraBackup weekly news, April 4th
April 4, 2011 By 1 Comment
… about our plans in light of developments in the market such as MySQL 5.5, MariaDB, Drizzle, etc. The short answer is that we’re very happy with Oracle’s GPL’ed MySQL releases as a baseline for Percona Server, we think that… indexes. He also improved mysqldump so indexes are created with “fast index creation” when restoring a dump, which can potentially speed…
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
… been popular for MySQL, it’s interesting to see what room we now have to scale up – cheap memory, fast storage, better… all relatively small. There are already appliances on the market which use 8 Intel SSD devices). Is a 2x or…
