Oracle Open World Presentations

<p>
  At <a href="http://orancle.com/openworld">Oracle Open World 2011</a> there has been a large number of MySQL presentations. You can download the slides of my two presentations at <a href="http://effectivemysql.com/downloads/ExplainingTheMySQLEXPLAIN-OOW-2011.pdf">Explaining the MySQL Explain</a> and <a href="http://effectivemysql.com/downloads/ImprovingPerformanceWithBetterIndexes-OOW-2011.pdf">Improving Performance with Better Indexes</a>.
</p>

<p>
  You can find additional supporting information for these presentations in the <a href="http://effectivemysql.com/book/optimizing-sql-statements/">Effective MySQL: Optimizing SQL Statements</a> book.
</p>

<div style="clear:both">
</div>
Tagged with: Databases MySQL MySQL Events

Related Posts

Six connections and a long queue: how a TLS-inspecting proxy quietly turned HTTP/2 into HTTP/1.1

Six connections and a long queue: how a TLS-inspecting proxy quietly turned HTTP/2 into HTTP/1.1

I recently tracked down a performance problem that turned out not to be in the application, the servers, or the CDN. A corporate TLS-inspecting proxy sat between the users and the site.

Read more
How easy is it to use the VillageSQL MCP extension?

How easy is it to use the VillageSQL MCP extension?

VillageSQL published Access MySQL over MCP with vsql-mcp . The extension serves the Model Context Protocol from inside the database, so an agent talks to MySQL over Streamable HTTP without a sidecar holding a credential.

Read more
Getting VECTOR capabilities in MySQL 8.4 using VillageSQL

Getting VECTOR capabilities in MySQL 8.4 using VillageSQL

For this quick verification of the 0.0.7 development branch of VillageSQL with the new vsql-vector plugin. Recreate the VillageSQL Percona Live presentation using MySQL version 8.4 and SVECTOR. Demonstrate a more detailed example using SVECTOR(1024) string embedded data.

Read more