… tests a database‘s ability to optimize queries for a star schema. A star schema presents some unique challenge to the database optimizer. The… is faster than InnoDB when the database is cold, but the opposite is true when the database is hot. SSB Flight #3… innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… nothing wrong with a virtual-machine approach, but for the optimal production deployment you want two identical physical boxes with at… database, a set of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT a specified set of databases and tables…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… non-trivial amount of updates to the database, all SELECT queries, even those participating in…setup and clarifies the scope of descriptors optimization. Server Configuration: [mysqld] user=root port=3306…..1024> –test=oltp.lua –oltp_tables_count=8 –oltp-table-size=1000000 –rand-init=on –report-…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…, especially if automatic upgrading was configured on machines with running database servers. We’ve now fixed it and re-released to… MySQL would re-create the test database when using rpm on server upgrade, even if the database was previously removed. Bug fixed… (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… and omitting the corresponding secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was… MySQL would re-create the test database when using rpm on server upgrade, even if the database was previously removed. Bug fixed… (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… improve to get optimal response times pt-archiver, to efficiently purge purge data from huge tables pt-table-checksum/pt-table-sync, to check… typical, real-world MySQL database administration challenges, such as: Selecting which queries you should try to optimize to get better response times…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
… deferred key creation optimization. Bug fixed #1081016. When mysqldump was used with –innodb-optimize-keys and …-create the test database when using rpm on server upgrade, even if the database was previously … in the MySQL client because the help tables were missing. Bug fixed #1041981. Other bugs …
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… software that performs non-blocking backups for InnoDB and XtraDB databases. This release is the current GA (Generally Available) stable release… crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking a full backup… are thousands of tables and slow IO then XtraBackup can spend a lot of time opening all the tablespaces. Optimization has been…
Post: Database access Optimization in Web Applications.
September 12, 2006 By 10 Comments
… you can use. Just remember avoiding accessing database is the best way you can optimize database access. This applies to anything else – if… retrieved from the database matches information you display Way to often much more information is retrieved from the database than used to… to be redesigned rather than simply adjusted – for example summary table which holds number of links per domain would do in…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… all major database brands. Q37: We have a fairly large Innodb table (150GB) that is showing poor performance for full table scans. using… run to show any table / index fragmentation, without having to run the OPTIMIZE? HT: Since OPTIMIZE rebuilds the whole table, it may last way too long for your 150 GB table! If you…
