(Roberto Spadim) please let me know any english erro =] this’s a draft about everything to be done with query cache (you can disable it too query_cache_type=0)
Tag: Open Source
Active-Active Replication, Performance Improvements & Operational Enhancements – some of what’s available in the new MySQL Cluster 7.4.1 DMR
(Andrew Morgan) Oracle have just made availble the new MySQL Cluster 7.4.1 Development Milestone Release – it can be downloaded from the development release tab here. Note that this is not a GA release and so we wouldn’t recommend using it in production.
Adding or removing individual SQL modes in MySQL’s sql_mode variable
(John Embretsen) Oracle recently published the MySQL 5.7.5 Development Milestone release, a pre-production release providing numerous improvements to the MySQL server.
MySQL Workbench 6.2: It’s all about the Query
(Marcin Szalowicz) In MySQL 5.7, the Optimizer Team has been doing great work in refactoring as well as innovation with the new Cost Model. The improved Visual Explain enables the DBA to now get deeper insights into Optimizer decision making, for improved performance tuning of queries.
MySQL 5.7.5: GROUP BY respects functional dependencies!
(Roland Bouman) Today, Oracle announced the availability of the Development Milestone Release 15 of MySQL 5.7.5. The tagline for this release promises “Enhanced Database Performance and Manageability”. That may sound rather generic, the actual list of changes and improvements is simply *huge*, and i
MySQL Workbench 6.2: Spatial Data
(Marcin Szalowicz) MySQL 5.7 will include much awaited GIS support for InnoDB tables. To make it easier to quickly visualize spatial/geometry data in geographic context, Workbench 6.2 includes a viewer for resultsets containing that type of data.
MySQL Date Gotchas
(Rob Gravelle) Welcome to the second installment in a series on MySQL Gotchas. Part one addressed the MySQL Numeric Overflow Gotcha. Today’s article will explore the perils of working with dates in MySQL.
Nuances of MySQL Fabric User GRANTs
(Perry Harrington) MySQL Fabric is a new product and some folks are running into issues when trying to deploy test instances that grow beyond a single server.
Percona Server, OpenStack and the Tesora DBaaS Platform
(Tushar Katarki and Terry Erisman) Percona Server and Percona XtraDB Cluster provide high-performance alternatives for MySQL users. We have also seen rapidly growing interest in these solutions in the OpenStack community where higher performance and high availability are crucial.
Changing the DEFINER of MySQL stored routines etc.
(Hartmut Holzgraefe) The question seemed easy enough: We’ve dropped a user, now we want to change the DEFINER on all database objects that currently have it set to this dropped user?