… long webinar on 26th of April on data recovery for MySQL. Almost every long serving DBA has been faced with the… data During this Webinar the Percona-InnoDB-Recovery-Tool will be used on Linux. To register: https://percona-events.webex.com/percona…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… System /dev/sda1 * 2048 19531775 9764864 83 Linux /dev/sda2 19531776 27920383 4194304 82 Linux swap / Solaris Partition 2 does not end… 19535039 9767488+ 83 Linux /dev/sda2 19535040 27342629 3903795 82 Linux swap / Solaris /dev/sda3 27342630 2339835119 1156246245 8e Linux LVM sda1 and…’s also a more modern – GUID partition table (GPT). The tool for the task of working with GPT is typically parted…
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… of it being unavailable on Linux which limits it practical use dramatically. fincore fincore is a tool to check how well given…
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… ib_log* 257M ib_logfile0 257M ib_logfile1 [root@DB01 mysql]# perl /tmp/fincore –justsummarize ib_logfile0 ib_logfile1 page size… log files on Linux because it is not aligned. [root@DB01 mysql]# du -h ibdata* 246G ibdata1 [root@DB01 mysql]# perl /tmp/fincore…
Post: Using MySQL Sandbox with Percona Server
February 16, 2013 By 3 Comments
… tools if you’re working with multiple versions of MySQL Servers is MySQL Sandbox which allows you to maintain many different versions of MySQL… to avoid conflicts if you’re having multiple sandboxes for MySQL, Percona Server, MariaDB of the same version, however you do…_sandbox /tmp/Percona-Server-5.5.29-rel29.4-401.Linux.x86_64.tar.gz installing and starting master installing slave…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… the lowest common denominator. We often use tools to gather a lot of the data …64 x86_64 GNU/Linux [percona@db1 ~]$ cat /etc/*release Red Hat Enterprise Linux Server release 5.2 …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…
Post: SystemTap - DTrace for Linux ?
September 14, 2009 By 17 Comments
… for Solaris I am missing it on Linux systems… It can’t be included in Linux by the same reason why ZFS…. Why I am interested in this tool, because there is no simple way under Linux to profile not CPU-bound load (for… is quite simple script that I tried to hack around MySQL ® probe process(“/usr/libexec/mysqld”).function(“*innobase*”). { printf(“s(%s…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
…-passive mode) is popular pattern used by many companies using MySQL for scale out. Most of the companies would have some… what does this tool do and how it works ? Currently it is implemented based on Linux IP management tools and LVM for snapshot… different languages etc, which makes application based fallbacks problematic. The tool also takes extra caution to prevent application mistakes. What will…
Post: MySQL Binaries availability
January 19, 2007 By 9 Comments
… tools needed to perform the build available. Furthermore there are no vendors which will create binaries for you as happens with Linux… published our build of MySQL 5.0.33 for Linux x86-64. Scott has provided builds both for Linux i386 and Windows. I guess over next few months community will establish trusted sources of MySQL Builds and…
Post: Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T
January 12, 2007 By 37 Comments
… to publish our build for MySQL 5.0.33 Community release. This build was done using “Generic Linux RPM” spec file on CentOS 4.4 (RHEL compatible) x86_64 (Links removed) We added one more RPM to stantard MySQL…/06/slow-query-log-analyzes-tools/ http://bugs.mysql.com/bug.php?id=25412 Also we propose Linux (AMD64 / Intel EM64T) binaries in…
