Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 2

Displaying posts with tag: application performance (reset)

Hands on with JetProfiler
+0 Vote Up -0Vote Down

Jet Profiler is a great MySQL  profiler. As the world of operating systems is getting more and more mixed, Jet Profiler offers a huge advantage: It is a Java based application and therefore able to run on Windows, Max OS X as well as on Linux.

Most of the time Java based applications tend to be very slow, however Jet Profiler shows that Java based applications can be fast and responsive as well. Even after hours of recording the UI stays responsive. To give you a working example, I had it recording on a server and real world load.

A nice feature of Jet

  [Read more...]
Using the Query Cache effectively
+3 Vote Up -0Vote Down

Maximize your strengths, minimize your weaknesses.

You can apply this approach to many things in life, I apply it to describing and using MySQL the product, and it’s components. The Query Cache like many features in MySQL, and indeed features in many different RDBMS products (don’t get me started on Oracle *features*) have relative benefits. In one context it can be seen as ineffective, or even detrimental to your performance, however it’s course grain nature makes it both trivial to disable dynamically (SET GLOBAL query_cache_size=0;), and also easy to get basic statistics on current performance (SHOW GLOBAL STATUS LIKE ‘QCache%’;) to determine effectiveness and action appropriately.

The Query Cache is course grained, that is it is rather simple/dumb in nature. When you understand the path of execution of a query

  [Read more...]
Showing entries 1 to 2

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.