… Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance …which is listed as “High-Memory Quadruple Extra Large DB Instance: 68 GB of memory, 26 ECUs (8 …,000 rows. This creates a table+index data size approximately twice as big as memory, so the …
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… waiting to finish. Also, mysql will not shut down unless a manual kill -9 is run. Our mysql db contains a mix of… programs # The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock bind-address=10.234.94.71 skip-locking key_buffer_size = 2000M… = 9216 tmp_table_size=1000M sort_buffer_size = 100M read_buffer_size = 100M read_rnd_buffer_size = 100M myisam_sort_buffer_size = 100M max_length…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… on update, and read from the db only when required. I tested with a memcached size of 1GB, 2GB, and 4GB… do. Using this application I can then compare using MySQL to using MySQL + Memcached, and then to other solutions like Tokyo Tyrant… on update, and read from the db only when required. I tested with a memcached size of 1GB, 2GB, and 4GB. For…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table_size…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp-table-size… –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp-table-size…
Comment: Choosing innodb_buffer_pool_size
March 30, 2010 By 39 Comments
… MySQL DB which is 123GB is size, there is a lot of images in the db. Historically i’ve worked mainly with smaller clustered DB‘s with NDB so an InnoDB db of this size is new… (< 28800) interactive_timeout ( 64M) tmp_table_size (> 128M) max_heap_table_size (> 128M) innodb_buffer_pool_size (>= 123G) The server itself has 16GB…
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
… Table Monitor has existed for basically forever in Innodb (the MySQL manual discusses it back in the 4.1 manual), and… itself dumps the contents of the Data dictionary to the mysql error log, which looks something like this: =========================================== 090420 12:09…, appr.key vals 1, leaf pages 1, size pages 1 FIELDS: ID DB_TRX_ID DB_ROLL_PTR FOR_NAME REF_NAME N…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… also get the table row format from the Information Schema: mysql (information_schema) > SELECT ROW_FORMAT from TABLES WHERE TABLE_SCHEMA… vals 2844513, leaf pages 6078, size pages 6120 FIELDS: emp_no from_date DB_TRX_ID DB_ROLL_PTR salary to_date INDEX….01 sec) Records: 3 Deleted: 0 Skipped: 0 Warnings: 0 mysql (employees) > select * from salaries where emp_no=10008; +——–+——–+————+————+ | emp_no…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
…db-ps-mode auto –mysql-host localhost –mysql-port 3306 –mysql-socket /data/vadim/benchwork/var/mysql_benchwork.sock –mysql-user user –mysql-password –mysql-db sbtest –mysql…
Comment: High Rate insertion with MySQL and Innodb
June 2, 2012 By 17 Comments
…=oltp –oltp-table-size=720000 –max-time=30 –max-requests=0 –mysql-table-engine=innodb –db-ps-mode=auto –mysql-engine-trx=yes –oltp-skip-trx=false –oltp-test-mode=complex –oltp-dist-type=uniform –oltp-range-size=1 –num-threads=16 –mysql-db=test –mysql-user=root –db-driver=mysql run got no more than aprox…
