…in most cases you do not know where exactly memory is allocated. This was not much of the problem in MySQL… you might want to look at Prepared_stmt_count to see how many prepared …to remove (or still use for processing). Of course you will see these tables going away if you close connection. In…
Post: How We Got Here
April 9, 2012 By 6 Comments
…planning and preparing for the MySQL conference that begins tomorrow. It seems appropriate to reflect on this process, where the open source …MySQL in production systems and know how to operate it and develop against it. These are the people who are uniquely qualified to talk about how MySQL works in…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…, will it hamper your ability to measure the ad’s value? Is it enough to know how many times the ad was clicked… to use InnoDB/XtraDB tables… Optimize For I/O It is pretty much inevitable: if you do this kind of data processing in MySQL, you’re going to end up heavily I/O bound. Listen to any of the talks at past MySQL conferences…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
…in the process when using pvcreate to initialize disk for LVM use, the two options you are interested in…to know these. Stripe unit size is the amount of data that will be written to single disk before skipping to next disk in…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
…in our data recovery service and it’s open source. I’m going to explain the full process in four different steps to…To accomplish this task we’ll use constraint_parser command. In order to use it the tool needs to know…in our hands the last step is to import it in our database: mysql…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…about how to make MySQL replication reliable, part of which is to eliminate temporary …to eliminate temporary tables. This problem may not exist for row-based replication in MySQL 5.1 and later, but most installations I know…I just stopped the replication processes. This is safe to do even when …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… don’t know how to read these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first… can decide which things to have us fix, which to fix themselves, and which to just ignore. The above process may look like a… are, means you can know when and how to break them for the client’s benefit. It’s like knowing openings in chess — the great…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
…in the MySQL …to involve us in the sales process Vendors often ask us to work with them in the sales process. For example, they might ask us to participate in…to requests from vendors who want to get to know us and vice versa. Sometimes we invite vendors to speak to…into how we strive to remain …
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
… Flexviews. It continues with an overview of how to install and run FlexCDC, and concludes with …_format=row to process SBR changes from a MySQL master. I’ll talk more about that in another blog…script will drop a .pid file so you know what process to HUP. $ ./consumer_safe.sh –ini=consumer.ini & …
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 7 Comments
…in the conclusion section of this post. This post will be focus on how to recover a single tablespace using stock MySQL…process to work. You can read more about this feature in Percona Server Documentation In the next blog post I’ll explain how to…
