9. Developing High-Speed Applications

Up to this point, the book has been focusing on how to select a MySQL storage engine, design and index your tables, and write optimal SQL; coming up later are suggestions on how to tune your MySQL storage engines. Right now, it’s time to pay attention to developing swift application software to make the most of your efficient MySQL database.

Because concurrency is so vital to good performance on a multiuser MySQL database server, this chapter begins by examining the interplay between concurrency considerations (such as locking and transaction isolation levels) and database responsiveness. After that topic has been explored, the chapter moves on to explaining how stored procedures, functions, ...

Get MySQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.