…MySQL 5.5.3 Starting with 5.5.3 DDL statements that modify the table metadata are executed in an isolated… > show processlist; +—-+———-+———–+——+———+——+———————————+————————————————————-+ | Id | User | Host | db…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But ….commanual safe_modeblogpercona.commanual safe_show_databaseblogpercona.commanual safe_user_createblogpercona.commanual secure_authblogpercona.commanual secure_file_privblogpercona.commanual…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… I was asked to isolate some functionalities from Mark Callaghan’s MySQL patch bundle. They were extensions adding per-user and per-table… users causing the most traffic to help you with some strategic decisions. Sample outputs: mysql> SHOW USER_STATISTICS LIKE ‘hosting2′\G *************************** 1. row *************************** User…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… but it is a lot larger problems with MySQL 5.5 with addition of user variables, stored procedures, prepared statements etc which… look at how it uses MySQL to identify potential causes. Is it working with large blobs ? Using user variables ? Prepared Statements ? memory… do in this case is see whenever you can create isolated repeatable test cases based on your application, which can illustrate…
Post: MySQL End Of Life (EOL) Policy
August 22, 2008 By 6 Comments
… you’re running MySQL in isolated environment the risk may be low). So how does EOL schedule looks ? MySQL defines Active Lifecycle and…+) Support offerings. For MySQL Community users this means only releases within Active Life Cycle will be made. For example MySQL 4.1 had… – make sure you understand MySQL Release Policy and so what to expect whenever you’re MySQL customer or community user. Shameless Plug: I…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… of time from processing accumulated backlog. The Theme of this Users Conference was surely Storage Engines both looking at number of… engine for MySQL – Innodb. Innodb Storage Engine was covered in a lot of talks, many of them done by Innodb users. I… can be removed for READ-COMMITED isolation mode which will start offering more performance benefits in MySQL 5.1 It also should…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
… keep things up given MySQL gives you so little ways to really restrict how much resources single user can consume. I have… in MySQL design, thinking little about users isolations and resource quotas and interesting enough I have not seen significant changes in fresh our MySQL… of users on single server with single MySQL server ? Well people just seems to be nice and not looking to crash MySQL/DOS…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… typically run some stable workload and we run it in isolation – nothing else is happening on the system. This is not… –mysql-user=msandbox –mysql-password=msandbox –mysql-socket=/tmp/mysql_sandbox5516.sock prepare [root@localhost msb_ps_5_5_15]# sysbench –test=oltp –db-driver=mysql –mysql…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult 28852… consider any one of these factors (schema, queries, indexing) in isolation, because they are tightly bound together, and tweaking one will…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1…=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now…
