… query comment consists of key value pairs: SELECT 1; – File: index.php Line: 118 Function: fullCachePage request_id: ABC session_id: XYZ… by web page: mk-query-digest /var/lib/mysql/slow –embedded-attributes ‘^– [^n]+’,’(w+): ([^t]+)’ –filter ‘$event->{File} && $event->{File} =~ m/index/’
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… on disk: 42GB (with indexes) # du -sh * 203M ibdata1 128M ib_logfile0 128M ib_logfile1 988K mysql 2.1G ontime1 2.1G…=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1… config for 20 shards (adjust to your number of nodes) php genconfig 20 > shards.ini Running the test For best performance…
Comment: Recovering from a bad UPDATE statement
October 21, 2012 By 5 Comments
… mysqlbinlog, you can see: http://bugs.mysql.com/bug.php?id=65178, or http://mysql.taobao.org/index.php/Patch_source_code#Add_flashback_feature…
Comment: Learning about MySQL Table Fragmentation
May 11, 2008 By 20 Comments
… to MySQL: http://bugs.mysql.com/bug.php?id=36588 Originally we had this discussion in our Forums: http://www.webyog.com/forums//index.php…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… OpenSource projects such as PostgreSQL (plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is changes – now… saying about XA which were released in MySQL 5.0 without consistent work with MySQL close Partner – Innobase to ensure Group Commit… inside who can figure things out and even patch MySQL if needed. So MySQL went to chase Enterprise market and develop enterprise…
Page: Consulting for MySQL
July 31, 2006 By
…, troubleshooting MySQL Replication performance problems. MySQL Operations and Administration Assistance with MySQL Server installation and configuration, working out Operations practices – MySQL Security, MySQL Upgrades, Backup… application performance issues lie outside of MySQL. We’re ready to work with you on PHP code optimization, Server Side caching, load… solution ? We can help with fine tuning MySQL build in Full Text Search indexing or help you with selecting and customizing alternative…
Comment: Why MySQL could be slow with large tables ?
August 22, 2010 By 141 Comments
Eddie, this depends on 1. Your MY.CONF settings http://www.notesbit.com/index.php/web-mysql/mysql/mysql-tuning-optimizing-my-cnf-file/ 2. The type of table it is — is it MYISAM or INNODB? For InnoDB, you may also fix the INNODB specific settings.
Comment: 5.4 in-memory tpcc-like load
April 14, 2010 By 11 Comments
… run several tests of a disk-bounded TPC-C on MySQL 5.4 both with and without O_DIRECT, and also… same MySQL and on 2 MySQL on the same machine. I collected several HW statistics, and reported everything here: http://relationalcloud.com/index.php…
Post: Life Beyond MySQL
September 27, 2006 By 3 Comments
… be doing some Web projects on my own, besides doing MySQL Consulting. I think some people thought I am just using… peers. At this point we have some 20GB of data indexes and few hundred megs of new data per day. We… what this size is developed on – it uses Linux/Apache/PHP/MySQL of course plus Sphinx for full text search.
Comment: Why MySQL could be slow with large tables ?
December 3, 2010 By 141 Comments
Peter, I have MYSQL database performance issue and I have updated the MYSQL Performance blog as below link. Please provide your view on this and its very urgent and critical. http://forum.percona.com/index.php/t/1639/ Thanks Mohammed.
