…my first post on MySQL …showed fairly close results in our tests. In Dimitri’s tests Percona Server scalability is somewhere in between of MySQL…speed (and thus, faster inter-process/node communication). Results: First of …use following queries: select avg(id) from sbtest$i force key (primary…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…process, notice that the server-id has changed on our server 2: And that’s the loop ! The event for server-id…forget to change the server-id in my.cnf. You change the server-id interactively, this is an …the active master (mysql 1) is changed to the position returned by SHOW MASTER STATUS on mysql 4 (…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… InnoDB tables, it’s safe. My first thought was, you can’t…slave, I just stopped the replication processes. This is safe to do …show binlog events in ‘mysql-bin.000007′\G *************************** 1. row *************************** Log_name: mysql-bin.000007 Pos: 4 Event_type: Format_desc Server_id…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
MySQL 5.6 is GA! Now we have new things to play with and in my personal opinion the most interesting one is the new Global Transaction ID… process …Value | +—————+——-+ | gtid_executed | | +—————+——-+ slave1 > show global variables like ‘gtid_purged’; …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…remove (or still use for processing). Of course you will …mysql> select * from information_schema.global_temporary_tables \G *************************** 1. row *************************** SESSION_ID: 7234 TABLE_SCHEMA: test TABLE_NAME: my…it is least intrusive. Run SHOW ENGINE INNODB STATUS and look…
Post: How to use a smartphone for two-factor authentication with Percona Server for MySQL
February 24, 2013 By Leave a Comment
…id=”attachment_13192″ align=”alignright” width=”300″] You can use a smartphone for two-factor authentication with Percona Server for MySQL…mysql> INSTALL PLUGIN auth_pam SONAME ‘auth_pam.so’; 2. Configure PAM for mysqld process…my smartphone in Authentificator application) mysql -…but to show a Percona…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…25 /proc/cpuinfo power management: processor : 7 vendor_id : GenuineIntel cpu family : 6 model : 15 model…1′ and ‘uptime’. That shows me what processes are running, but it also shows me load average, …mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…process) and is able to hash split up to 50GB/hour of input data on my…id` (`date_id`), KEY `flight_id` (`flight_id`), KEY `origin_airport_id` (`origin_airport_id`), KEY `dest_airport_id` (`dest_airport_id… 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… open by any process). First be sure to run SHOW ENGINE InnoDB STATUS at least once. Then see what MySQL process ID is: garfield ~ # ps ax | grep [m]ysqld 11886 ? Ssl 0:01 /usr/sbin/mysqld –defaults-file=/etc/mysql/my.cnf In my case the process ID is 11886, so I will be using it…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
…show how to count the number of unique words, an how many times those words appear in a document. Set based processing…my method. Likely current network technologies can not support such a degree. mysql> select min(id),max(id) from words; +———+———+ | min(id) | max(id) | …
