Last week the annual Percona Live Data Performance Conference was held in Santa Clara, California. This conference is a great time to catch up with the industry, and be exposed to new tools and methods for managing MySQL and MongoDB.
The highlights from this year’s sessions and tutorials centered around a few technologies:
What do I mean by ‘fix’ the the fixed object statistics? Simply gather statistics to help the optimizer.
What are ‘fixed objects’? Fixed objects are the x$ tables and associated indexes that data dictionary views are based on. In this case we are interested in the objects that make up the v$sqlstats and v$sql_bind_capture views.