… not want to hack wordpress to support eaccelerator cache or memcached. Well …-deterministic functions such as UUID(), RAND(), CONNECTION_ID() etc it will not be…your selects – Com_select and see how many of them are cached. Query … – You can’t change how it works with MySQL to add caching but …
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…support in replication. This post is not an explanation of what is GTID and how it works internally because there are many documents about that: http://dev.mysql… from binary log: ‘The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION =…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
… how many physical cores are connected to my bus, and because I chose to create six hash “buckets” in the table. This allows MySQL… with my method. Likely current network technologies can not support such a degree. mysql> select min(id),max(id) from words; +———+———+ | min…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…ll discuss the MySQL resource agent and the supporting configuration while … During a master switch, connections are killed on the…mysql primitive resource declaration. This primitive defines the mysql resource on each node and has many…”ms” declaration. This is how Pacemaker defines an asymmetrical…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…, make it read only or anything like it. Support for all local disk based storage engines It… to do atomic snapshot of many volumes. Lets speak a bit about how LVM and snapshotting in general … perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH …
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
…MySQL configuration, we quite often want to know how various buffer sizes are … Unlike many of the buffers that are allocated per-thread (i.e. per-connection… with pointers to blobs to support very big 14180 records 14181 ******************************************************************************/ …
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
…MySQL Master-Master replication (often in active-passive mode) is popular pattern used by many companies using MySQL…how it works ? Currently it is implemented based on Linux IP management tools and LVM for snapshot creation but we hope support…read-only user for slave connection but what if your …
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… rewrite this and MySQL Inc would provide a supported MySQL binary. (I was in the room with Monty when he detailed how long this would take). I was also the first MySQL… are “active connections” when determining a thread pool size. FYI, it was really hard to do a SHOW PROCESSLIST with so many connections.
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…that load statement is: mysql -S /tmp/mysql-ib.sock -e “… sense count of direct connected cities for different diapason of years…many records, there is query select year,count(*) as c1 from ontime group by YEAR which shows how many… to note that MonetDB supports all INSERT / UPDATE / DELETE statements…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…how each customer utillizes the database. Having many…mysql> SHOW USER_STATISTICS LIKE ‘hosting2′\G *************************** 1. row *************************** User: hosting2 Total_connections: 84 Concurrent_connections: 0 Connected…
