…_socket=1 audit_json_log_file=/var/lib/mysql/audit.log audit_record_cmds=connect,Quit Notice the audit_offsets that I…-maint”,”host”:”localhost”,”cmd”:”Connect“,”query”:”Connect“} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL‘s behavior in a way that, once set up, is transparent to users, and the McAfee MySQL…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…percona1 corosync[1535]: [MAIN ] parse error in config: Can’t open logfile ‘/var/log/corosync.log’ for reason: Permission denied (…Could not establish cib_ro connection: Connection refused (111) Connection to cluster failed: Transport endpoint is not connected… …but MySQL is still running: [root@…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be shipped… #1131187 (Alexey Kopytov). Removed trx_list scan in read_view_open_now() which is another problem originally reported as upstream bug…
Post: Network at the Percona Live MySQL Conference and Expo
March 28, 2013 By Leave a Comment
… of MySQL community members at a single conference. The extra day added to this year’s conference means more opportunities to connect…, opportunities to network abound at the Percona Live MySQL Conference and Expo. Connect with MySQL community members in the hallways between talks. Or… jobs board where sponsors can post open positions. If you or someone you know are open for new opportunities, be sure to…
Post: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… of that post makes a connection between a free account in a cloud-based service and Open Source software. I think it… that article: “In principle, anyone who has an interest in MySQL and MariaDB surviving should contact the MariaDB foundation and ask…: If you are in the MySQL market and your product is under proprietary license (not an Open Source one) you set the…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… reported as a part of MySQL bug #49169 and can be described as follows. Whenever a connection wants to create a consistent…, InnoDB scans trx_list (i.e. the list of currently open transactions) and copies IDs of transactions that have not yet… in MySQL 5.6 boils down to the fact that read-only transactions are not added to the list of open transactions…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be shipped… #1131187 (Alexey Kopytov). Removed trx_list scan in read_view_open_now() which is another problem originally reported as upstream bug…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0… –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops… we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance issues around mutexes and… = 8 innodb_io_capacity = 5000 sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… MySQL connection pool handling system for the application level via a lightweight python app (using multi threading and internal queues) that accepted connections… open sourced as well. Regarding the 30k connections and show processlist — that reminds be of a client I supported and designed their MySQL…
