…the benchmark. There was some discussion in the comments and I promised to follow up with more… as hash indexes are faster than a b-tree index. Also accessing pages from the buffer …datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… first MySQL user conference independently organized by MySQL AB. It was called the “MySQL Users Conference” and took place at the Double Tree hotel… available for MySQL. Facebook mentions they have over 1,800 MySQL Servers. MySQL Enterprise provides Monthly Rapid Updates [MRU] while Community MySQL versions updated… moments do you have from you attending MySQL Conference over last 10 years. Please leave comment and share your experiences! Thank you…
Post: Bug#12704861
November 20, 2011 By 1 Comment
…be a very serious problem that is fixed in MySQL 5.1.60. I’ll repeat here the full… new BLOB pages could have overwritten clustered index B-tree leaf pages that were freed during the update. If…=FALSE) to avoid leaking pages. row_build(): Correct a comment, and add a debug assertion that a record that…
Post: Moving Subtrees in Closure Table Hierarchies
February 14, 2011 By 18 Comments
… need to store hierarchical data, such as threaded comments, personnel org charts, or nested bill-of-materials. …In Closure Table, we store every path in a tree, not only direct parent-child references, but also … table in a single query in MySQL. But we can use MySQL‘s multi-table DELETE syntax, to …
Post: New MySQL Community Release Policies published
August 9, 2007 By 9 Comments
… to MySQL Community Release Policies. I knew about them a bit in advance but now they are public I can comment a… built from the same tree but as goal was reached process slowed down a lot. Submitting patches to MySQL 5.2 now… hesitations they will be available. Not to mention as Source Tree is available you can rebuild and rename binaries same as…
Post: Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T
January 12, 2007 By 37 Comments
… has posted comments about them since more than a year ago. Great news are MySQL finally released new Community release – MySQL 5.0… yet, coming of the same tree as MySQL Enterprise. To help those who would like to use MySQL Community version but does not… (Links removed) We added one more RPM to stantard MySQL RPMs – MySQL-microslow-5.0.33-0.glibc23.x86_64.rpm This…
Post: Making MySQL Replication Parallel
January 30, 2007 By 1 Comment
… idea, the problem is however implementing it right without changing MySQL Replication semantics – which is – Slave database state corresponds to master… of the database which never existed on master. As I commented in Kevins blog the problem is very simple to illustrate… many application without serious code complications. If MySQL would not implement it it might be nice feature to hack into community tree.
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… insertions happen in the “end” of index tree. I’ve updated column to have bunch… in terms of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row …Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: 1 row in set (0.00 sec) …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…up questions out of this. I had added my comments to some of the questions. HT will stand …block of 64 pages, 16 kB each. Each B-tree index in InnoDB occupies two SEGMENTs. One segment …throughput? HT: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… B-Tree does not fit into memory. As benchmark software I tried iiBench, which you can take there https://launchpad.net/mysql-patch/mytools What makes fractal indexes so interesting is the amount of IO operations to update index tree is… need to read data, and in this case – read previous comment. – The version we tested did not yet support recovery logs…
