June 19, 2013

Post: Preprocessing Data

August 8, 2011 By 3 Comments

… results to a separate table. When the dashboard queries the database, it only queries the ready made results in the separate… have now improved the speed of the main page of the website as well as seriously reduce the load on the database. The… This is when you insert data into the database. Your application or the database itself (using TRIGGERs) does additional calculations or data…

Filed Under: Insight for Developers, MySQL

Post: Database problems in MySQL/PHP Applications

August 11, 2006 By 13 Comments

… not expect it to beat MySQLi in speed. It is however bad idea to use mysql_ functions directly as well – I would… make performance improvement much smaller. Notable exception being AJAX applications which may do very little work and formating, so database connection may… it is frequently told by people with traditional database background. Things are different with MySQL. There are many successful applications, using tens…

Filed Under: Insight for Developers Tagged With: , ,

Comment: Disaster: LVM Performance in Snapshot Mode

February 9, 2009 By 55 Comments

… speed. This happened one year ago. I am not sure if Z1soft has improved it or not. From my testing, the backup speed… a good for a large MySQL database. Haven’t tracked of Z1soft recent progress. I won’t choose it without seeing dramastical improvements.

Filed Under: Benchmarks, Hardware and Storage

Post: MySQL Users Conference - Innodb

May 9, 2007 By 6 Comments

…Database Egos” – Storage Engine developers showcase as one of keynotes. Today let me start with most popular transactional storage engine for MySQL…table itself) The index build speed is however not only reason… should benchmark this aspect separately. Improved Auto Increment handling Yet another…

Filed Under: Events and Announcements Tagged With:

Post: Improved InnoDB fast index creation

November 6, 2011 By 4 Comments

… Quoting the fast index creation chapter in the MySQL manual: “… you can generally speed the overall process of creating and loading an… with a dump created with –innodb-optimize-keys (the test database contained only the table I used in my previous examples… index as the clustered one. References: Peter’s post MySQL bug #57583 MySQL bug #49120 Fast Index Creation page in Percona Server…

Filed Under: Benchmarks, Insight for DBAs, MySQL

Post: New SpecJAppServer results at MySQL and Sun.

November 12, 2008 By Leave a Comment

…database 4 cores was enough. Does it mean the J2EE system got saturated before the database ? Or does it mean MySQL… rarely used so I’m curious how much speed benefit did it really provide in this case. …Tom Daly and his team in further benchmark results improvements. I guess we’ll see more of these …

Filed Under: Benchmarks

Post: SHOW INNODB STATUS walk through

July 17, 2006 By 40 Comments

…output and how to use this info to improve MySQL Performance. To start with basics SHOW INNODB STATUS…hash index Innodb builds for some pages to speed up row lookup replacing btree search with hash…16773888 Buffer pool size 262144 Free buffers 0 Database pages 258053 Modified db pages 37491 Pending …

Filed Under: Insight for DBAs Tagged With:

Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera

November 26, 2012 By 4 Comments

…-primary clusters are the remaining minority and will not allow database operations. cnf This is wserep_cluster_conf_id — the version… really just tells you if multi-threaded replication could help improve replication speed at all. Conflct Replication conflicts, as described in my…

Filed Under: MySQL, XtraDB Cluster

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… in our database directory: -rw-rw—-. 1 mysql mysql 8632 Feb 20 15:54 dir_test_innodb.frm -rw-rw—-. 1 mysql mysql 213909504 Feb….ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 16:09 FTS_00000000000000ad_STOPWORDS.ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 15… one, which discusses improving bulk insert performance. At the very bottom, the page claims that you can speed up bulk loading into…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Percona Server and XtraBackup weekly news, April 4th

April 4, 2011 By 1 Comment

…of developments in the market such as MySQL 5.5, MariaDB, Drizzle, etc. The …improved mysqldump so indexes are created with “fast index creation” when restoring a dump, which can potentially speed…probably aware, are making XtraBackup support Drizzle databases. We committed code that makes xtrabackup …

Filed Under: MySQL, Percona Software
« Older Posts
Newer Posts »