1

How do I know the memory consumption of MySQL, and when it is reaching the memory limits of my server? I would like to know to so I can diagnose performance problems when they arise.

Maxime Pacary
  • 22,336
  • 11
  • 85
  • 113
eric
  • 1,453
  • 2
  • 20
  • 32
  • that's perhaps not the ideal way to go about identifying performance problems. Do you have particular queries that are slow? – Mitch Wheat Dec 31 '10 at 01:56
  • On what platform are you running MySQL (Windows, Ubuntu, OS X)? The mechanism for inspecting memory usage varies by operating system. – Phrogz Dec 31 '10 at 02:00
  • 3
    Is http://www.mysql.com/products/enterprise/monitor-features.html something on the lines of what you are looking for? This is usually the kind of tool used by DBA's to monitor databases. – Jagmag Dec 31 '10 at 02:00

1 Answers1

2

The simplest way to check amount of memory consumed by application is to use 'top' command on Unix and 'Performance monitor' on Windows

Vladimir Kroz
  • 5,237
  • 6
  • 39
  • 50