…questions. I answered as many as we had time for during the session, but here are all the questions with my…I believe it should all translate to the same execution plan. (I know it doesn’t though.) Why don’t you try writing…referring to is this example: WHERE (k1.keyword, k2.keyword, k3.keyword) = …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…my first post on MySQL …well, so we tried to answer that question by retrying benchmarks on various combinations of…= true innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 2000… avg(id) from sbtest$i force key (primary) select count(*) from sbtest$i WHERE k like ‘%0%’…
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
… bit RSA private key …………..+++ ……………………………………………………….+++ writing new private key to ‘key….to have a mixed cluster where some have SSL and …[brief] outage. In my case, I have an existing non…by default Other questions Will IST be encrypted if I set the…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… fashion. I also know that there is some writing that always occurs to the first file in a log file group. My questions are: What is always being written to the first file in the log file group? HT: InnoDB writes the checkpoint… showed up in “show innodb statusâ€. select * from table where id=5 show innodb status: Hash table size 10624987, used…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions. I answered as many as I could during the session, but here are all the questions with my complete answers: Q: I wasn… in the buffer pool. But the read/write split solution is intended for cases where the query load is too high for…
Post: MySQL Sizing questions
June 23, 2006 By 4 Comments
… handle my 40GB” database. There are two things which are very interesting about these questions which… already purchased. 2) There are certain cases where quick estimates actually make sense. This typically… not catastrophy if you are wrong. I should write about some techniques and formulas which you…
Comment: Impossible - possible, moving InnoDB tables between servers
March 20, 2010 By 9 Comments
…process? I‘m considering this in the context of a cluster of machines running XtraDB where we want … than query-based MySQL replication. I‘d be happy with a short write-block period on A during… steps 3-7 to get a consistent backup. I guess my question is: can XtraBackup be configured / easily patched…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…’s our most popular service). I thought I should write a blog post that will both answer their question, so I can just reply “read… from /etc/my.cnf. I‘ve seen a lot of cases where there’s a /var/lib/mysql and an /etc/my.cnf, and…’s a question of where they fall on the scale. Now I analyze these one at a time. For each query, I run EXPLAIN…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… follow up questions out of this. I had added my comments to some of the questions. HT will …of a segment are allocated from ‘fragment extents’ where any individual page can be allocated to …write load, a new flush and a checkpoint happens more than once per second. PZ: Not what this answers question…
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
… will be available soon. During my webinar, a number of attendees asked some good questions, and I wasn’t able to answer them all before the hour was up. Here are the questions and my answers…. There are always edge cases where it’s appropriate to use a stored procedure, even one that writes dynamic SQL. And it…
