… to share. I used a nice and effective tool iiBench which has been developed by Tokutek. Though … 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22… used: ## InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group =…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of connections but yet MySQL… up to max_packet_size per connection) are all connection buffers and so if you close connection MySQL can clean them up… leak. Dealing with memory leaks is rather complicated as good tools to detect memory leaks like valgrind are too slow to…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… the Helgrind tool of the Valgrind dynamic analyzer suite. Now, Valgrind does not need much introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, which is synonymous with Valgrind itself, is relatively widely used for the MySQL server…) ==9090== Address 0x5e06270 is 0 bytes inside a block of size 800000 alloc’d ==9090== at 0x4C28FDF: malloc (vg_replace_malloc…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…-heartbeat tool, if you choose), and actual failure. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql… difficult to handle max_connections problems (the use of fixed-size connection pooling, for example, which can sometimes require application downtime…
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
… on restart a frequent problem. pt-config-diff is the tool which can help with this problem a lot, being able…: mysql> set global sort_buffer_size=DEFAULT; Query OK, 0 rows affected (0.00 sec) mysql> select @@global.sort_buffer_size; +—————————+ | @@global.sort_buffer_size…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
… root page 4, appr.key vals 306195, leaf pages 2189, size pages 2212 FIELDS: emp_no from_date [...] The second method… link: http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:generating_a_table_definition With the table definition… is to import it in our database: mysql (employees) > LOAD DATA INFILE ‘/root/recovery-tool/data/salaries.recovery’ REPLACE INTO TABLE `salaries…
Post: The tool I've been waiting for years
March 18, 2008 By 10 Comments
… so you can write real stuff. For example using this tool MySQL can easily add amount of cached data per table for….0 kbytes per file. [root@DB01 mysql]# perl /tmp/fincore –justsummarize ib_logfile1 page size: 4096 bytes 24169 pages, 94.4 Mbytes… aligned. [root@DB01 mysql]# du -h ibdata* 246G ibdata1 [root@DB01 mysql]# perl /tmp/fincore –justsummarize ibdata1 page size: 4096 bytes 0 pages…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… atomically, not just for new connections as in MySQL. This is very helpful for measurement as otherwise … query log. Installing pt-query-digest tool (as well as other tools from Percona Toolkit) is very easy, …is not much considering the fact that tmp_tbl_size variable is set to 32M on the server, …
Page: Tools
May 30, 2008 By 31 Comments
… is a great set of tools for MySQL Performance Analyses and maintainence. Must know and have for any MySQL User. mysqladmin mysqladmin extended… how MySQL performance counters increment and it can tell you a lot about server run status. mysqlreport MySQL Report is a tool which… device, their type, request size as well as queue size and response time. mpstat mpstat is a great tool to see details on…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… requirements to transfer uncompressed backup. What is about compression tool ? The classical tool used for backup compression is gzip – it exists almost… note the serious leap in compressed file size. Though in this example we used MySQL binary log file which often contains plenty of similar events, which could be the reason for so large size difference…
