… incrementally maintaining materialized views. While writing Flexviews, I learned how to…output. There is no external locking or synchronization required. If a… SQL, but right now only MySQL storage nodes are supported. Amdahl… `aggregation_tmp#74082863` ; Edit *MIN/MAX are only distributable in INSERT…
Post: XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo
March 2, 2009 By 10 Comments
…Here is a list of enhancements: Move to MySQL 5.1.31 Scalability fix — ability…write-intentional workloads. See benchmark results. Scalability fix — replaced page_hash mutex to page_hash read-write lock… in the XtraDB io patches: innodb_ibuf_max_size — Restrict innodb-insert-buffer size…
Post: Edge-case behavior of INSERT...ODKU
October 27, 2012 By 6 Comments
…being defined first. So, MySQL checks our INSERT, … | Variable_name | Value | +—————————-+——-+ | Handler_rollback | 1 | | Handler_write | 1 | +—————————-+——-+ Ok, so we …to the auto-increment max value, which is the… second all trying to lock and update the …
Post: Another scalability fix in XtraDB
January 23, 2009 By 13 Comments
…after 8 connections, si I decided to test MySQL-5.1.30 with standard InnoDB. It was …shared read lock is enough – and we replaced page_hash mutex to page_hash read-write lock. The new… for reference InnoDB was run with next parameters: –max_connections=3000 \ –table_cache=2048 \ –query_cache_size=0…
Post: Adaptive flushing in MySQL 5.6
September 4, 2012 By 8 Comments
…’s see what the result we are getting in MySQL 5.5 ( MySQL 5.5.27): As you can see there is… system is kind of locked up, not being able to process queries. So, how it is changed in MySQL 5.6.6… innodb_read_io_threads = 16 innodb_write_io_threads = 16 innodb_io_capacity = 20000 innodb_max_io_capacity = 40000 innodb_buffer_pool…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…’ ‘Key_read_requests’, ’1552507′ ‘Key_reads’, ’1654′ ‘Key_write_requests’, ’114303′ ‘Key_writes‘, ’1346′ ‘Max_used_connections’, ’651′ ‘Not_flushed_delayed_rows’, ’0…_log_group_home_dir=/var/log/mysql innodb_log_arch_dir=/var/log/mysql innodb_table_locks=0 innodb_buffer_pool_size=1800M…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… # The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock bind-address=10.234.94.71 skip-locking key_buffer_size = 2000M max_allowed…_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next…] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
… (ms) | write: latency (ms) iops | iops min avg max sdev | iops min avg max sdev … file) takes and holds the lock in a shared mode if…write ratio has even a more drastic effect on ext3 + snapshot performance. “randomio” might not be a good representation of what MySQL…
Post: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
…, every time current binary log gets close to max_binlog_size in size, new binary log is…log files older than expire_logs_days are removed. &LOCK_log mutex is held for the duration of… files), then write operations in MySQL will suffer since that very same mutex is used inside MYSQL_LOG::write() call….
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… physical, 48 bits virtual power management: I tested MySQL-5.1.30 with InnoDB plugin, Xtradb-…_buffer_size=1M max_allowed_packet=1M max_connections=3000 max_heap_table_size=64M max_prepared_stmt_count=…_locks and to buffer_pool mutex (in rel2). Conclusion: As read-only workload seems fine, read-write…
