… Percona Monitoring Plugins 1.0.3 for MySQL — high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your… Utilities. Also the following Cacti graphs need to be recreated: MySQL “MySQL Threads”, Linux “Network Traffic”. A new tarball is available from downloads… of Percona’s Remote DBA installation and setup of these tools are included with our services. You can find links to…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… many customers on Linux that we end up scripting mostly Linux-centric things, so a little tweaking to the tools might be needed…’s so special about the collect tool? Isn’t [insert your favorite OS's awesome tool that Linux doesn't have] better? What…. There are many things that can cause a stall in MySQL, and they usually begin microscopically and get worse over time…
Post: Basic performance and diagnostic tools on Solaris
February 14, 2011 By 7 Comments
… has been written about tools to inspect Linux systems, and much has been written about Solaris’s Big Important Tools such as DTrace. But I don’t recall seeing much in the MySQL blogs about basic tools to find… a quick list of some key tools. Many of the tools you’re used to from Linux will work, although sometimes they output…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
… common questions I get asked is which Linux distribution I would use for a MySQL database server. Bearing the responsibility for someone… MySQL won’t be much different whether one or another distribution is used. All use common Linux kernel – the heart of Linux operating… the other end there are Debian and Ubuntu. Both use tool called dpkg for package management. There isn’t a month…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
… is a simple but powerful way to profile MySQL memory usage; the Massif tool from Valgrind. An excerpt from the Massif manual… setting is VG_N_SEGMENTS in coregrind/m_aspacemgr/aspacemgr-linux.c (when you see ‘Valgrind: FATAL: VG_N_SEGMENTS is…) 0x728DAA: Log_event::read_log_event(st_io_cache*, st_mysql_mutex*, Format_description_log_event const*) (in /usr/local/percona…
Post: Meet Percona at Southeast Linux Fest
June 7, 2012 By Leave a Comment
Percona will be at Southeast Linux Fest tomorrow and Saturday. We’re supporting the event, and … both be speaking: Peter about optimizing MySQL configuration, and I will talk about inspecting MySQL‘s performance and scalability via TCP packet headers. In addition, the entire Percona Toolkit and Online Tools team (me…
Post: Be productive with the MySQL command line
December 21, 2012 By 14 Comments
…below are only available for Unix/Linux. Using pager Most of the graphical tools paginate results, which is very handy… by using the pager command: mysql> pager more PAGER set to ‘more’ mysql> select title from sakila.film; +—————————–+ | title | +—————————–+ …
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
… with MySQL you might need to deal with RAID recovery every so…login via SSH it can be recovered as any generic Linux server. When you restart the system RAID5 volume which … Test (different hard drive vendors have different versions) such tools would often have a functionality to scan hard drive …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… I would like to see MySQL memory consumption plotted. I use “VSZ” columns from “ps” output on Linux. It helps me to… leak. Dealing with memory leaks is rather complicated as good tools to detect memory leaks like valgrind are too slow to… and fixed. This is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can help us…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
…about the way MySQL handles connections, allocating one thread per connection to the server. MySQL is a … particular has had excellent threading support practically forever; Linux has very good threading now, but that wasn…’s not what it’s designed for. Wrong tool, wrong use, NotABug. I’m thinking of …
