… file, or to a unix socket, which means you can write a script to listen on this socket and process the audit records… work (plus one commented line for switching between file and socket for output): plugin-load=AUDIT=libaudit_plugin.so audit_offsets…_file=1 audit_json_socket_name=/tmp/audit.sock #audit_json_socket=1 audit_json_log_file=/var/lib/mysql/audit.log audit…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
….162″ primitive p_mysql ocf:heartbeat:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld.pid” \ socket=”/var/run/mysqld/mysqld… Pacemaker to know if MySQL is already running. It should match the my.cnf pid_file setting. socket: The MySQL unix socket file replication_user…
Post: Rare evil MySQL Bug
November 20, 2009 By 7 Comments
… on the case you may be able to connect to MySQL through Unix Socket or TCP/IP or neither. It also looks like…[0x408b60] So as you can see accept gets pretty high socket number – probably because of large innodb_open_files I tested… used during recovery. Note the process gets accept on the socket to fail with EAGAIN (which is not well described in…
Post: check-unused-keys: A tool to interact with INDEX_STATISTICS
June 26, 2009 By 10 Comments
… password of the MySQL user -i, –port=
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
… protocol plugin, authentication from a file, MySQL UNIX socket protocol, javascript plugin, authentication via tables (similar to MySQL), RabbitMQ, regex policy, logging to syslog…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
…/IP) 12200 MySQL Query Cache (TCP/IP) 9900 MySQL Query Cache (Unix Socket) 13500 Selecting from table (TCP/IP) 5100 Selecting from table (Unix Socket) 7400… MySQL Query Cache – It performs faster than Query Cache if TCP/IP socket is used, but if Unix Socket is used to connect to MySQL MySQL…
Comment: What to tune in MySQL Server after installation
June 22, 2009 By 118 Comments
… [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those… Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 72…
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=all…’ ‘–enable-assembler’ ‘–enable-local-infile’ ‘–with-mysqld-user=mysql‘ ‘–with-unix-socket-path=/var/lib/mysql/mysql.sock’ ‘–with-pic’ ‘–prefix=/’ ‘–with-extra-charsets=all…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…= 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 …same host. # All interaction with mysqld must be made via Unix sockets or named pipes. # Note that using this option without …
Post: Poor man's query logging
November 7, 2008 By 5 Comments
Occasionally there is a need to see what queries reach MySQL. The database provides several ways to share that information with… communicate with MySQL through TCP sockets. When localhost (not to be confused with 127.0.0.1) is used as a MySQL host, this will not work since all traffic goes through a unix socket file. It’s most definitely not a MySQL log…
