… in products based on Open Core models. But in my opinion Open Core is not Open Source, and the Open Source model is something… product. For example, I believe there is no way a closed-source software product will ever be deployed in a Facebook… and Kickfire, two companies that based their products on a closed-source version of MySQL… and you know their fate – sold…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… InnoDB Memcache fetching seems very small. Bypassing SQL parsing and opening/closing tables only gains 20% in performance? Why? In comparison Handlersocket…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… of grade between Open Source only and proprietary only software. Remember in MySQL early days before there was single close source extension… getting traction (and Tokutek is actually moving to Open Core more than complete Open Source model) – Continuent, InfiniDB, Infobright all companies which…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 11, 2013 By 13 Comments
… do in the future. Remember, aside from discussions about open source, open core, closed source – if you run a company that is supposed… that works. So MariaDB could profit most from TokuDB going open source. At any rate, there are already three well established…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… hardware and dataset sizes, including the ones that are as close as possible to Dimitri’s environment. To put a long…, the more general descriptors optimization in Percona Server showed fairly close results in our tests. In Dimitri’s tests Percona Server…_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
…, InnoDB scans trx_list (i.e. the list of currently open transactions) and copies IDs of transactions that have not yet… read-only transactions are not added to the list of open transactions. Since they don’t modify any data, it is… “trx descriptors” optimization in Percona Server 5.5 is fairly close in terms of scalability, while the cost of the trx…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… replace Innodb for a number of use cases. The first “open core” plans are announced for MySQL Server – the online backup… [QSP] 2010 The deal between Oracle and Sun is now closed after overcoming a number of bottlenecks, including strong opposition by… planned GA release. Percona releases GA version of Percona Xtrabackup – open source alternative to Innodb Hot backup. MySQL 5.1.46…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… HDD-only setup, but it doesn’t even really come close to the numbers obtained with vCache. There may be ways… max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 10240 max_allowed_packet = 16M binlog_cache_size = 16M…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… is, like you it or not, that close source vendors are struggling, and open source have some chances to survive with a…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… to keep open file descriptor when table is open – open table is purely logical state and appropriate .ibd file may be open or closed. Furthermore… open files was, which is not surprising as logical operation of opening file is rather fast on local file system – one can open/close file hundreds of thousands times per second. To verify this I tried doing “open table” test for only…
