… at the bug list or patch list for MySQL/InnoDB at any one point in time. The list will be long, and… unless something is completely broken. There used to be, and in some places still is a developer culture of common decency… use ext3/4 because of your post. In the second event I find your comments rather disingenuous. Do you pay license fees…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…, c_phone, n_name, c_address, c_comment order by revenue desc LIMIT 20; In-memory workload Now let’s see how… in MariaDB 5.5 and not in MySQL 5.6, is that because of a bug in MySQL 5.6 code? As MRR was used in both MySQL 5.6…
Post: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
… I believe everyone felt the energy and enthusiasm. The positive comments on the Internet certainly seem to point that direction: Florian… that it was “the best in years.” Darren Cassar called it “one of the best MySQL conferences since I started attending four… the speaker slides in a central repository so the knowledge shared in the conference will be available to all in the MySQL community. [UPDATE…
Comment: Joining many tables in MySQL - optimizer_search_depth
April 23, 2012 By 5 Comments
… above comment was written long time ago, when I was just hired at MySQL. The assumptions about what are typical MySQL may have been true then in 2004, but they are likely not true now in… investigate the potential pitfalls with the change to plan pruning in MySQL 5.6. Ideally, the server should analyze the query and…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… and tpcc-mysql, the final result is also represents the throughput (transactions per second in sysbench; NewOrder transactions Per Minute in tpcc-mysql). However, like Mark Callaghan mentioned in comments, response time is way…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… is happening here? It seems as if MySQL 5.5 has been getting much slower (in terms of qps) with the last… last year; shortly after Oracle took it over. Can you comment on why this is happenign, and if it is happening… updates made to INNOdb tables really slowed down mySQL as measured by qps, in the last 4-6 months? Best regards, Eddie
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 23, 2012 By 9 Comments
… of MySQL. 2. I am the lead author of the second and third editions of that book. I have no involvement in… Something Wrong, but that is not a topic for this comment thread. You could try our forum or consulting/support services…
Comment: MariaDB 5.3 is released as GA!
March 13, 2012 By 17 Comments
… killed MySQL completely at the moment, but it will happen someday in a way or another… Like said by others people in the comments…
Post: How to Identify Bad Queries in MySQL
January 10, 2011 By 16 Comments
… interested in knowing whether I’m missing anything, but I believe the definition of badness in this article is fairly complete. (Post comments…, which has been available in MySQL for years. This is necessary for determining whether a group of queries completed in a cluster. One… heuristic for detecting bad queries? Let me know by posting in the comments.
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…same query typed in by different developers. Supporting different comments is especially important as many application put extra information in the comments to …applications in MySQL have very large number of queries doing updates through primary key and use primary key for selects. I believe in…
