…to set in the slave but it is not set always and also users with SUPER privilege…to binary logs – the ones executed directly on the host as well as coming through replication thread. There is however a way to know…
Post: Query_cache and column level privileges
August 6, 2007 By 5 Comments
… function query_cache_send_result_to_client is called before real parsing of query, so at the moment of execution the query_cache is not able to know which columns are accessed. Looking into source code I found out that in the case when table has column level privileges – function query…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
…privilege_tables to ensure all new privileges are added, which is something I frequently see forgotten Next step is setup MySQL 5.0 to…the time to check how read traffic behaves. We stopped both slaves at the same position again and used tcpdump and mk-query-digest to…
Post: Poor man's query logging
November 7, 2008 By 5 Comments
… actually extended the slow log to, among others, include any query regardless of the execution time. The problem is that for both you need to prepare… enabling the logging before starting the database instance or, even more work, by applying the patch and rebuilding the entire database from sources. I know… done when you really need to see the queries, but can’t afford any downtime? If you are a privileged user (i.e. root…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…to know is howto track down where the bottleneck is… I’ve read Peter Z two guides but cannot really convert the gained knowledge to… ‘Com_show_open_tables’, ’0′ ‘Com_show_privileges‘, ’0′ ‘Com_show_processlist’, ’20′ ‘Com_…mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections=…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
… running bad queries or installing bad software. It is good people are nice but it may not be comforting to know you stay up just because nobody wants bring you down rather than because your systems are solid and designed to… privileges for this to happen ? Not really – you do not even need to be able to select from the table. Any user with permission to connect to…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
…to know about partial replication – you can do filtering on the Master or on the Slave. Filtering on the…you need to skip some statements from binary logging. This command requires SUPER Privilege and …differently. Instead of looking at the query and analyzing which tables this query is using. This …
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… the same type might be allocated for exampe to handle subqueries. For some special queries… would like to see. Monitor how the value changes so you know memory requirements …privilege should be able to run MySQL server out of memory MyISAM buffers. MyISAM may allocate buffer which is large enough to…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
…privilege you should be safe. It has some other neat features, for example you may configure it to remove READER role from the…query pattern it will not. MMM will detect this situation and will hold the server for administrator to…
