…mysql_fix_privilege_tables to ensure all new privileges are added, which is something I frequently see forgotten Next step is setup MySQL 5.0 to…MySQL to see what is different in the tables. It turned out one of the float columns stored “-0″ in MySQL… to the new setup. It was the time to check how …
Post: Query_cache and column level privileges
August 6, 2007 By 5 Comments
…how query_cache works with column level privileges. The question was appeared as we discovered function query_cache_send_result_to…to_client just stopped and returns to usual execution. So initial assumtion was that query against table with defined column privilege… set (0.00 sec) mysql> show global …
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 7 Comments
…your SELECT queries against multiple MySQL servers and reports on how each type of query performs… counts, checksums, column count, query execution time including execution errors and warnings. So how do you… try to use an account with only the necessary privileges. It is also important to note to run…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…case where I will add a new column to the table while a transaction in …0.000007 | | checking privileges on cached | 0.000003 | | checking permissions | 0.000005 | | sending cached result to clien | 0….how Active MQ uses MySQL when in HA mode. In HA mode there are two Active MQ servers, both try to…
Post: Knowing what pt-online-schema-change will do
November 1, 2012 By 1 Comment
…output part by part to see how it reveals that the tools is going to do something wrong, a… the tool to test the –alter statement: Altering new table… ALTER TABLE `test`.`_t_new` add column (foo… any bugs in the tool, problems with the MySQL server (privileges, etc.), or other oddities, there is a…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…how do you determine the memory consumption per connection in average? This leads to…’Com_show_collations’, ’176788′ ‘Com_show_column_types’, ’0′ ‘Com_show_create_…show_open_tables’, ’0′ ‘Com_show_privileges‘, ’0′ ‘Com_show_processlist’, ’20′…# Lowered from 32M according to MySQL innodb_additional_mem_…
