… from Mark Callaghan’s MySQL patch bundle. They were extensions adding per-user and per-table accounting to the database, accessible with a… how each customer utillizes the database. Having many different users running their queries on a single database instance means they will be… be very useful. With simple MySQL SHOW command it gives you the basic statistics on the database activity broken down by users…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… papers, you’ll see a pretty extensive list of suggestions for what to monitor in MySQL. Those are only suggestions; any given… until a later date. For example, if a database isn’t owned by MySQL, you won’t have any problems until you… the database, it will fail. These things tend to happen at inconvenient times. The pmp-check-mysql-file-privs plugin checks whether MySQL…
Post: Flexviews is a working scalable database transactional memory example
May 19, 2011 By 3 Comments
… for creating materialized views for MySQL data sets. The tool is for MySQL, but the methods are database agnostic. A materialized view is… specific points in time in database state, invalid database state is not possible, particularly if there are thorough database checks. Flexviews is: lock….1.1.41.7788 Also includes my own personal and extensive research into combinatorial algebra over non-distributable aggregate functions. I…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 31 Comments
As you probably know PHP “mysql” extension supported persistent connections but they were disabled in new “mysqli” extension, which is probably one of… expensive, even though they are much faster with MySQL than with most other databases. Not only connects are expensive but you also… talk now about why Persistent connections were disabled in mysqli extension. Even though you could misuse persistent connections and get poor…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… anyone can follow. A full performance audit is far more extensive than this article can cover, and might wander into Apache… we’ve generally seen just about everything people throw at databases Many people assume their application is difficult or somehow different… see what’s up with the database. The first step is to find out what MySQL instances are on the machine. It…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… well when you don’t need high concurrency from your MySQL database. When you do, the limitations on the core counts and…’s version of MySQL is probably closer to stock MySQL than it is to Percona Server. I haven’t run extensive benchmarks against… is a chance that will cause MySQL to perform slowly or unpredictably. For write-heavy databases, you are generally bound by either…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…. You also can use pretty much direct path to mysqli extension to performance critical queries if you need. I would also… it is frequently told by people with traditional database background. Things are different with MySQL. There are many successful applications, using tens… QA – it will work quite fast with almost empty database. With database growth it will however start to crawl. So developing you…
Page: Consulting for MySQL
July 31, 2006 By
… possible. Custom features and patches for MySQL We can help with developing custom features and extensions for MySQL, help fixing bugs promptly as… for your Solution with MySQL. We’re also ready to help with competitive benchmarks comparing MySQL and other databases for your application workload…
Post: MySQL Architecture meeting at Google
April 24, 2008 By 2 Comments
… at Google campus to talk about MySQL architecture mainly focusing on storage engine vendors and other extension areas. It was very interesting to see all these storage engine interface extensions which are planned for MySQL 6.0… commercial databases) as complicated beasts being overkill for most of their users. Is MySQL becoming such a beast as well ? Will MySQL be…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… database used by tons of applications written by many people over more than 5 years timeframe. It did not have any extensive… sure what application does or does not do with the database. Database is production critical with serious role in serious company so… to keep this into account. We move database to MySQL 5.1 As the database size is relatively small we do mysqldump and…
