… MySQL users, vendors, and technologies. This was the first of what I hope are many such events where all members of…, and the Santa Clara Convention Center, to name just a few. Please mark your calendars now for two upcoming Percona Live events…
Post: What MySQL buffer cache hit rate should you target
June 29, 2006 By 5 Comments
… rate is looking for trouble. Well of course you can name 100% hit rate and all data fits in memory as… and 99 hits, making your hit ratio 99% for what would be 0% in many peoples mind. But what is even more important… extended -i10 -r is your friend in computing this) while there is no other IO – no matter what your hit ratio is it…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… too. We want to know what your concerns are at this stage. … [percona@db1 ~]$ mysqladmin ext -ri10 +———————————–+———————-+ | Variable_name | Value | +———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 …
Post: Should you name indexes while doing ALTER TABLE ?
May 28, 2008 By 10 Comments
… the key name or omit ? Things what you should be looking at is how MySQL names indexes automatically as well as what maintaining the indexes. Lets first speak about naming. If you do not specify index name MySQL will name… is little control over what customization user may have done. As a Summary – if is good to name your indexes manually both for…
Post: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 12 Comments
… `schema` AS table_schema, innodb_sys_tables.name AS table_name, innodb_sys_indexes.name AS index_name, cnt, dirty, hashed, ROUND(cnt * 100… real “physical” table name which identifies table down to partition, which is very helpful for analyzes of your access to partitions – you… measures. I often check these stats during warmup to see what is really getting warmed up first as well as how…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… enables you to connect the Raspberry Pi to your screen, and so follow what is happening on the console of the Raspberry… know what IP address the Raspberry Pi got (likely the first available address in your DHCP range), you can always check your router… assign a permanent DNS name (like pi.yourdomain.com) by binding the reserved IP to a DNS name in your router’s DNS…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_small –oltp-table-size=1100000 –mysql-user…} (information_schema) > select concat_ws(‘.’, t.schema, t.name, i.name) as index_name, sum(data_size)/1024/1024 as data_size_mb… now going inline with what you would expect. Lets see what is going on with buffer pool contents: INDEX_NAME DATA_SIZE_MB…
Post: SHOW OPEN TABLES - what is in your table cache
December 14, 2008 By 3 Comments
… to examine what tables do you have open right now: mysql> show open tables from test; +———-+——-+——–+————-+ | Database | Table | In_use | Name_locked… for this command is pre-flush implementation (as part of your backup routine) – instead of running FLUSH TABLES on ALL tables…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
…` tinyint(3) NOT NULL auto_increment, `name` char(40) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM; All cities_* tables… select_type: SIMPLE table: s type: const possible_keys: PRIMARY,name key: name key_len: 40 ref: const rows: 1 Extra: *************************** 2… large as you expect. Though again a lot depends on your data and queries.
Post: Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet
February 28, 2013 By 11 Comments
… Raspberry Pi: Your own MySQL Database Server , I thought what other crazy…> show variables like ‘version%’; +————————-+——————————+ | Variable_name | Value | +————————-+——————————+ | version | 5.5.29 | | version_compile_machine…
