June 19, 2013

Post: Implementing SchemaSpy in your MySQL environment

June 4, 2013 By 2 Comments

…’s also designed to help resolve the obtuse errors that …I find it convenient to set it up on crontab …: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127….name=”parent” comments=”Parent table”>
name=”parent_id” primaryKey=”true”>

name…

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

Post: Ultimate MySQL variable and status reference list

January 8, 2011 By 4 Comments

…MySQL…set_connectionblogpercona.commanual character_set_databaseblogpercona.commanual character_set_filesystemblogpercona.commanual character_set_resultsblogpercona.commanual character_set_serverblogpercona.commanual character_set_systemblogpercona.commanual character_sets…skip_name_resolveblogpercona…

Filed Under: Insight for DBAs, MySQL

Post: Is DNS the Achilles heel in your MySQL installation?

May 31, 2008 By 16 Comments

Do you have skip_name_resolve set in your /etc/my.cnf? If not, consider it. DNS … need to set skip_name_resolve in your my.cnf file and restart MySQL. But before you do that, run the following command: mysql> SELECT user, host FROM mysql…

Filed Under: Insight for DBAs Tagged With:

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

… than what’s included. For example, the absence of skip-name-resolve is easy to miss, as is the absence of innodb…_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456… the mysql.* tables, running mk-duplicate-key-checker to find redundant indexes, and so on. As with settings and status, these set the…

Filed Under: Insight for Developers Tagged With:

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

… from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1. row *************************** Name: ontime_fact Engine…=512K read-rnd-buffer-size=1M skip-host-cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT_TRANS_TABLES symbolic…=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set up a cluster from 1…

Filed Under: MySQL

Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80

February 25, 2013 By 10 Comments

…assigned, usually together with a host name. While there, you could also …resolving dependencies… looking for inter-conflicts… Targets (4): libaio-0.3.109-6 libmysqlclient-5.5.30-1 mysql…MySQL system tables… OK Filling help tables… OK [...more setup information, please read...] [Optional] Set…

Filed Under: Hardware and Storage, Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , ,

Post: MySQL 5.5.8 and Percona Server: being adaptive

December 20, 2010 By 25 Comments

… scalability issue. Let’s see how MySQL performance changes for the last workload if we set innodb_buffer_pool_instances=8 or…: [client] socket=/var/lib/mysql/mysql.sock [mysqld] core basedir=/usr/local/mysql user=root socket=/var/lib/mysql/mysql.sock skip-grant-tables server…=500 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=10000 [mysql] socket=/tmp/mysql.sock (post edited by Fred Linhoss)

Filed Under: Benchmarks, MySQL Tagged With: , ,

Post: Sharing an auto_increment value across multiple MySQL tables

October 4, 2010 By 9 Comments

… insert does two operations to get the value: UPDATE option2 SET id=@id:=id+1; SELECT @id; So which is better… availability zone. Ping times are ~0.5ms between nodes. –skip-name resolve is enabled on the server. There is some skew from…

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

Post: Percona XtraDB Cluster reference architecture with HaProxy

June 20, 2012 By 63 Comments

…] – ‘(null)’ resolves to ’0.0.0.0′; 120619 13:21:19 [Note] – ‘(null)’ resolves to ‘::’; …mysql> show global status like ‘wsrep_cluster_size’; +——————–+——-+ | Variable_name | Value | +——————–+——-+ | wsrep_cluster_size | 3 | +——————–+——-+ 1 row in set…

Filed Under: MySQL, Percona Software, XtraDB Cluster Tagged With:

Post: Test Drive of Solid

September 22, 2006 By 5 Comments

…mysql> begin; mysql> update test2 set names=’mysql‘ where id=1; Session 2: mysql> begin; mysql> update test2 set names=’Solid’ where id=2; Session 1: mysql> update test2 set names…be resolved in further versions. Test 5: UPDATE / SELECT FOR UPDATE in OPTIMISTIC mode Solid optimistic: Session1: mysql>…

Filed Under: Uncategorized Tagged With: ,
« Older Posts