posted by Sakila The Librarian
on Fri 10 Jul 2009 22:00 UTC
Many of the characteristics that make MySQL so successful also apply to GlassFish and NetBeans. This talk will demonstrate how MySQL, GlassFish, and NetBeans can be used together to create quick and powerful web applications. It shares tips to boost web application development when using all of them together.
posted by Sakila The Librarian
on Fri 10 Jul 2009 22:00 UTC
DTrace is breakthrough tool for on-demand tracing and analysis of any software. As MySQL internals are open, it is possible to extract incredibly valuable information about database work - without performance overhead or even need to restart a server. This talk covers and merges knowledge and practice from both DTrace and MySQL worlds - and explains why D in DTrace means 'dynamic'.
posted by Sakila The Librarian
on Fri 10 Jul 2009 22:00 UTC
The InnoDB storage engine has been modified to use memcached as a level 2 cache, the InnoDB buffer pool being the level 1. Important reduction of the disk load and performance boost has been observed. This opens a new way of scaling out MySQL.
posted by Sakila The Librarian
on Fri 10 Jul 2009 22:00 UTC
This session will give an overview of the new set of static DTrace probes introduced in MySQL 6.0 with examples on how to use them in real-life monitoring and performance tuning tasks.
posted by Sakila The Librarian
on Fri 10 Jul 2009 22:00 UTC
A tour of External Language Stored Procedures for MySQL and how they overcome the challenges involved when using MySQL's UDFs and SQL stored procedures.
posted by Sakila The Librarian
on Fri 10 Jul 2009 22:00 UTC
The Falcon Storage Engine is designed to take advantage of multi-core computers. It is reaching GA at a time when computer performance is being increased mostly by adding more cores. Falcon's unique characteristics will be explained and contrasted with InnoDB and other MySQL storage engines.
posted by Sakila The Librarian
on Fri 10 Jul 2009 22:00 UTC
A case study of the evolution of MySQL usage, as a company moved from a scrappy startup - with the goals of finding a cheap, quick, and simple database solution - to a mature enterprise - with high availability and horizontal scalability as key requirements.
posted by Sakila The Librarian
on Fri 10 Jul 2009 22:00 UTC
Have a look at how Big Fish Games and thePlatform are using MySQL Enterprise Monitor 2.0 now to help tune and troubleshoot their applications.
posted by Sakila The Librarian
on Fri 10 Jul 2009 22:00 UTC
Query analysis can help highlight issues in the SQL in your application, but there are many ways of getting that information. Obvious choices are explain and the slow-query log, but newer solutions, such as live query monitoring, mysql proxy and DTrace provide additional benefits.
posted by Sakila The Librarian
on Fri 10 Jul 2009 22:00 UTC
In a classic case of "eat your own dogfood", MySQL.com is a key player in the beta testing of MySQL software, including Query Analyzer. In this presentation MySQL.com web developer Adam Donnison will take you through how he used Quan to improve database performance on the MySQl.com website by orders of magnitude, and why Quan was needed.
posted by Sakila The Librarian
on Fri 10 Jul 2009 22:00 UTC
Sheeri K. Cabral, a two-time winner of the MySQL Community Advocate award, passes the baton to the next generation of MySQL Community superheroes -- you! Though you cannot fly or have X-ray vision, Sheeri will explain how you can make a difference in the MySQL Community without writing a single line of code.
posted by Sakila The Librarian
on Fri 10 Jul 2009 22:00 UTC
This session will highlight some of the architectural specifics of the DB2 Storage Engine as well as discuss uses and benefits of the storage engine.
posted by Sakila The Librarian
on Fri 10 Jul 2009 22:00 UTC
This session will present the Random Query Generator, a new tool for database workload generation for the purpose of stress testing.
posted by Sakila The Librarian
on Fri 10 Jul 2009 22:00 UTC
You can run MySQL on a standard server, but there can be benefits to running MySQL within a virtualized environment. You can take advantage of the isolation it provides, or the performance gains possible by running multiple MySQL instances on one large server. This session will show you the benefits and potential issues of running MySQL in a virtualized environment.
posted by Sakila The Librarian
on Fri 10 Jul 2009 22:00 UTC
This presentation describes InnoDB on-disk file formats, the new file format management, as well as InnoDB source code structure.
posted by Sakila The Librarian
on Fri 10 Jul 2009 22:00 UTC
InnoDB is well-known and popular, but naturally there's room for improvement. There are many hard-coded constants – what happens if we turn them into command-line parameters? InnoDB is also incredibly complex, with a lot going on under the covers. What algorithms can we change to make InnoDB faster and more scalable, especially on modern hardware?
posted by Sakila The Librarian
on Fri 10 Jul 2009 22:00 UTC
Writing a custom engine can seem intimidating and creating a generic engine can be. This presentation will show how to refine the requirements to a manageable subset. We will discuss the problem addressed, the approach chosen, storage engine design and API required to implement the design. We will talk about lessons learned implementing the storage engine to improve flexibility and performance.
posted by Sakila The Librarian
on Fri 10 Jul 2009 22:00 UTC
This session will introduce DTrace, OpenSolaris's Dynamic Trace Facility, which can be used to give unprecedented access to the inner workings of MySQL. We will explore specific MySQL DTrace probes and the DTrace pid provider, which allows the gathering of information about any function within a process.
posted by Sakila The Librarian
on Fri 10 Jul 2009 22:00 UTC
In this session we present OpenLDAP/back-ndb which gives an LDAP interface to MySQL Cluster. The LDAP interface on Cluster offers some nice ways of scaling out, as well fantastic performance, and we discuss how this is done. Moreover, it is possible to simultaneously access the LDAP data using e.g SQL! A short demo will be given.
posted by Sakila The Librarian
on Fri 10 Jul 2009 22:00 UTC
Enterprise email is broken. From managing metadata to the inefficiency of multiple message storage, IT administrators have long bemoaned the task of implementing a scalable, affordable, reliable messaging architecture. Zimbra and MySQL’s combined expertise has altered the way administrators control their email servers through the development of a more effective back end for messaging architecture.