…weeks. Major features include: Multi sourced replication XtraBackup …from the previous stable release is: 3891 files changed, 473733 insertions(+), 210435 deletions…tables, the Drizzle protocol plugin, authentication from a file, MySQL UNIX socket protocol, javascript plugin, authentication via tables…
Post: Performance Schema tables stats
May 2, 2011 By 2 Comments
…single tables. Now after adding multi-tables support to sysbench, it is interesting to see what statistic we can get from …DELETE: 0 SUM_TIMER_DELETE: 0 MIN_TIMER_DELETE: 0 AVG_TIMER_DELETE: 0 MAX_TIMER_DELETE: 0 *************************** 3. row *************************** OBJECT_TYPE: TABLE …
Post: Moving Subtrees in Closure Table Hierarchies
February 14, 2011 By 7 Comments
… SQL statement: DELETE FROM TreePaths WHERE descendant IN (SELECT descendant FROM TreePaths WHERE ancestor = ‘D’) AND ancestor NOT IN (SELECT descendant FROM TreePaths WHERE… FROM clause.” We can’t DELETE and SELECT from the same table in a single query in MySQL. But we can use MySQL’s multi-table DELETE…
Post: Sysbench with support of multi-tables workload
April 29, 2011 By 3 Comments
…sysbench support for workload against multiple tables ( traditionally it used only single table). It is available from launchpad source tree lp:sysbench . …select insert delete update_index update_non_index to support different OLTP modes. Most interesting: all scripts support –oltp-tables-count=N…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
…_LOG_BIN=0 if you need to skip some statements from binary logging. This command requires SUPER Privilege and extreme care… the tables are not taken into account. The traditional pre MySQL 5.0 way to break such replication is also using multi-table update or delete statements, if you happen to replicate one table or another this would not…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’ ‘Com_create_index’, ’0′ ‘Com_create_table‘, ’31′ ‘Com_dealloc_sql’, ’0′ ‘Com_delete‘, ’348788′ ‘Com_delete_multi‘, ’1′ ‘Com_do’, ’0′ ‘Com_drop_db’, ’0′ ‘Com_drop_function’, ’0′ ‘Com_drop_index’, ’0′ ‘Com_drop_table…_file_io_threads=4 innodb_lock_wait_timeout=15 # CHANGED from 50 innodb_log_files_in_group=3 innodb_flush_log…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… world values distribution. The query looks something like this: SELECT * FROM table WHERE deleted = 0 AND group_id IN (62715996, 62716592, 62717660, 62717716…, 62744142, 62744144, 62744146) With secondary key defined on (group_id,deleted) This pattern of medium size IN lists is typical for…,ha_innobase::index_read,handler::read_range_first,handler::read_multi_range_next,QUICK_RANGE_SELECT::get _next,rr_quick,sub…
Post: Data mart or data warehouse?
July 15, 2010 By 13 Comments
…”. Data is very likely never updated or deleted in these databases and they are expected… usually multi-dimensional (OLAP) analysis as it is very hard to create a dimensional model from… consists of a central table called the fact table and additional dimension tables which contain information about …
Post: MySQL caching methods and tips
April 4, 2011 By 4 Comments
…a single request is not very efficient. Use multi_get when possible. Once again, caching entire …the duplicate items are deleted. When this happens, decreasing the counts in summary tables may not be … for maintaining summary tables must be used. Either they must be rebuilt from scratch each time (…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… TokuDB does not scale well on multi-cores even in only SELECT queries…portion of data. – Despite Inserts and Deletes are fast, updates are not …transparent backup, as it applied TABLE LOCK on copying table. When recovery logs are… producing application, it can be from simple apache logs put into mysql…
