… lot of “MySQL Community” focused keynotes. Good coverage of MySQL Alternatives including keynotes for Drizzle and MariaDB. MySQL 5.5 replaced… space – PostgreSQL, EnterpriseDB, Hadoop,Hbase, MongoDB, CouchBase providing compliments and alternatives to MySQL. The MySQL Community awards are presented by Monty…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…) The gain in performance from SQL SELECT to InnoDB Memcache fetching seems very small. Bypassing SQL parsing and opening/closing tables…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… this test run (100,000 store operations, 1,000,000 fetch operations): Standard Memcache: Storing [100,000] items: 60486 ms total… store operation was 280% higher (~1.73 ms/op) InnoDB fetch operation was 20% higher (~.06 ms/op) MySQL Select showed 27% increase over InnoDB fetch (~.09 ms/op) This replaced $cache->load() with $db->query…
Post: APC or Memcached
September 27, 2006 By 23 Comments
…” Developer, request objects from cache one by one rather than fetching all items you need for the page at once (not… at once benefiting from strong sides of each of them. APC Cache (Eaccelerator and other similar caches) is Fast but it… amount of space combined and which you only need to fetch few per page. For example search results may be good…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… some of the data would exist only on the master. Alternatively, you can filter on the slaves. Each slave downloads the… in an in-memory data store such as Memcached or APC. Store in $_SESSION only values that are ephemeral and easily…
Post: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 24, 2009 By 20 Comments
… showed horrible results forcing us to look at more performing alternatives. Innodb Hot Backup is a good working solution but it… features – extra undo slots, rollback segments etc. After considering all alternatives we decided to develop Percona Xtrabackup tool, which will use…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… you will need to look into it more later. Another alternative is to dump table with MySQLDump and load it back…” Note even if you do not use MyISAM table but fetch data to the script instead make sure to use LIMIT…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… and Innodb needs to access one of the pages being fetched does it has to wait for whole read ahead request…. Memlock is apparently unstable on Linux. O_DIRECT is an alternative but Linus hates it. What are your suggestions here? HT… very large portion of physical memory. There is also third alternative – “huge pages” which can be used for buffer pool and…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… breakage Table Locks – Table locks are not cleared until you fetch whole result set if you’re reading from tables directly… SQL commands and it can be much more efficient. Another alternative is of course to use MySQL Stored Procedures which can… … SELECT to the temporary table with auto_increment column and fetch data from this table using auto increment column ranges instead…
Comment: To UUID or not to UUID ?
March 15, 2007 By 28 Comments
… local index on the table SHA1 may be pretty good alternative, even though for our needs CRC32 works better and here… why. If we do URL lookup we always need to fetch data about it not only check if it is in…
