… to segment. Fortunately InnoDB internally has mechanism to support multiple rollback segments – and Yasufumi just made patch … –mysql-host localhost –mysql-port 3306 –mysql-socket /data/vadim/benchwork/var/mysql_benchwork.sock –mysql-user user –mysql-password –mysql-db sbtest –mysql-table-…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
…) 12200 MySQL Query Cache (TCP/IP) 9900 MySQL Query Cache (Unix Socket) 13500 Selecting from table (TCP/IP) 5100 Selecting from table (Unix Socket… Query Cache if TCP/IP socket is used, but if Unix Socket is used to connect to MySQL MySQL Query Cache will be faster… not however forget about other benefits of Memcache – distributed caching, support of time to live (so you do not get cache…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… all long options that a program supports. # If you want to know which options a program supports, run the program # with the… = 3306 socket = /tmp/mysql.sock #tmpdir =/mysql_tmp/ # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock bind…
Post: check-unused-keys: A tool to interact with INDEX_STATISTICS
June 26, 2009 By 10 Comments
… adoption of Google’s User Statistics Patch**, the need for supporting scripts has become clear. To that end, we’ve created… password of the MySQL user -i, –port=
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…’ ‘–enable-assembler’ ‘–enable-local-infile’ ‘–with-mysqld-user=mysql‘ ‘–with-unix-socket-path=/var/lib/mysql/mysql.sock’ ‘–with-pic’ ‘–prefix=/’ ‘–with-extra-charsets… disable it. “innodb†is only available with the patch supporting that feature. Can be changed at run time with both…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… indexes, changing data type, converting data to different character set – MySQL master-master replication especially accompanied by MMM can be very… with one of our MySQL support customers as they were upgrading their application and mysql schema. We deployed and used MySQL Master-Master replication…) and they must be executed on db2 so better use mysql file socket, or real IP of the node, but not virtual…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
… and latency sensitive. What many people do not realize is MySQL has to deal with multiple logs and perform multiple flushes… (depending on file system and configuration) more synchronous IO operations – MySQL binary logs are not preallocated as Innodb logs are which… rather interesting to see DRBD to have direct support for Infiniband or Dolphin interconnect sockets which are getting low cost these days…
Comment: Review of MySQL 5.6 Defaults Changes
October 9, 2012 By 10 Comments
… from there. Systems with many CPUs, say 40 in four sockets or 80 in 8 using CPUs like the Xeon E7… I presume to be Percona’s target audience. James Day, MySQL Senior Principal Support Engineer, Oracle.
