… multicast node still needs to bind to the Galera replication port, and of course that needs to be bound to the… *:4567 (LISTEN) mysqld 17493 mysql 20u IPv4 39685 0t0 TCP *:3306 (LISTEN) Now, let’s re-do our above test: # 2…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… results Configurations and how to run benchmark: [mysqld] user=root port=3306 innodb_buffer_pool_size = 30G innodb_flush_method = O_DIRECT… -D host=127.0.0.1 -D user=root -D port=3306 -D password= -D maxid1=100000001 -c config/MyConfig.properties -l… -D host=127.0.0.1 -D user=root -D port=3306 -D password= -D maxid1=100000001 -c config/MyConfig.properties -csvstats…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…: Master_Host: 127.0.0.1 Master_User: test Master_Port: 3306 Connect_Retry: 60 Master_Log_File: Read_Master_Log_Pos… specify the master-user, master-password, master-host and master-port in the my.cnf file? # cat my.cnf [...] master-user… master-password=rsandbox master-host=127.0.0.1 master-port=35301 [...] Let’s disconnect the slave: mysql> stop slave; Query…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… = 4000 innodb_use_native_aio=0 #not innodb options (fixed) port = 3306 back_log = 50 max_connections = 2000 max_prepared_stmt_count…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… the scope of descriptors optimization. Server Configuration: [mysqld] user=root port=3306 innodb_status_file=0 innodb_data_file_path=ibdata1:100M…
Comment: Percona Server 5.5.30 with TokuDB for MySQL
April 25, 2013 By 26 Comments
…-7.0.1-tokudp� ‘ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 MySQL Community Server (GPL)
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…. 120619 13:21:19 [Note] Server hostname (bind-address): ‘(null)’; port: 3306 120619 13:21:19 [Note] – ‘(null)’ resolves to ’0.0… PXC. We will have MySQL listening on 3306 and 3307. If we connect to port 3306, we will connect to pxc-onenode, so…-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3306 –mysql-user=sbtest –mysql-password=sbpass –oltp-table-size=10000…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…_password port = 3306 socket = /tmp/mysql.sock #tmpdir =/mysql_tmp/ # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket… the master’s port number (3306 by default). # # Example: # # CHANGE MASTER TO MASTER_HOST=’125.564.12.1′, MASTER_PORT=3306, # MASTER_USER=’joe…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
… on a server with roughly 50MB/s of traffic on port 3306, system load of about 10, and 8 CPU cores. The… and representative subset of clients tcpdump a modulo of incoming ports (including port 3306, because we must capture the responses from mysqld) #1… used. tcpdump -i eth0 -s 65535 -x -n -q -tttt ‘port 3306 and tcp[1] & 7 == 2 and tcp[3] & 7 == 2…
Comment: Shard-Query turbo charges Infobright community edition (ICE)
October 5, 2012 By 23 Comments
…’=>’root’, ‘password’=>”, ‘db’=>’test’, ‘port‘=>3306 ), ‘shard2′ => array( ‘host’=>’192.168.1.101′, ‘user’=>’root’, ‘password’=>”, ‘db’=>’test’, ‘port‘=>3306 ) ); $params = array(‘gearman’=>’localhost…’=>’root’, ‘password’=>”, ‘db’=>’test’, ‘port‘=>3306 ), ‘shard2′ => array( ‘host’=>’192.168.1.101′, ‘user’=>’root’, ‘password’=>”, ‘db’=>’test’, ‘port‘=>3306 ) ); $params = array(‘gearman’=>’localhost…
