…below will be ignored and # overridden by the content of the master.info file, unless you shutdown… and instead use CHANGE MASTER TO (see above) # # required unique id between 2 and 2^32 – 1 # … when connecting # to the master – required #master-user = # # The password the slave will authenticate with…
Comment: To UUID or not to UUID ?
March 14, 2007 By 28 Comments
… you use Wikipedia definition: http://en.wikipedia.org/wiki/Globally_Unique_Identifier but I see what you really mean by following… would instead use mapping table and use integer keys for users themselves, because these are much faster. 2) You’re describing… bad idea. If you use SHA1 as “natural” unique keys based on object contents you can design application differently and get better…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… on variables, or look for content in the Percona documentation or forums… safe_show_databaseblogpercona.commanual safe_user_createblogpercona.commanual secure_authblogpercona.commanual…_sizeblogpercona.commanual tx_isolationblogpercona.commanual unique_checksblogpercona.commanual updatable_views_with…
Comment: COUNT(*) vs COUNT(col)
April 25, 2007 By 41 Comments
… a copy of the PK column comment_ID with a unique index: mysql> show create table wp_comments\G *************************** 1. row *************************** Table… NOT NULL default ’0000-00-00 00:00:00′, `comment_content` text NOT NULL, `comment_karma` int(11) NOT NULL default… ’0′, `user_id` bigint(20) NOT NULL default ’0′, `rajid` bigint(20) unsigned default NULL, PRIMARY KEY (`comment_ID`), UNIQUE KEY `rajidx…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… to do read-write splitting without breaking the user experience, how to take online non-blocking backups,… time is money your application is not as unique as you think, and we already know a… of the server’s configuration and performance and contents. I’m looking for characteristics that are much…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
…( airport_id int auto_increment primary key, unique key(airport_code) ) as select Origin as `…, which can be confirmed by examining the contents of the date dimension: mysql> select count(*), min…can be improved significantly: $ cat shards.ini [default] user=mysql db=ontime password= port=5029 column…
Post: XtraDB: The Top 10 enhancements
August 13, 2009 By 5 Comments
…, XtraDB diagnostics include the ability to see the contents of the buffer pool (see docs), and InnoDB…best measured in hours and days – this restricts users to using very small transaction log files (innodb… allows you to delay the writing of non-unique secondary index pages, which can often lead to…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
…components may be different depending on your unique applications. For example for application containing a… larger as there will be some syncronization contention while accessing shared memory cache which does…which is APC alternative which supports caching user data both on disk and in shared memory…
