June 19, 2013

Comment: Converting Character Sets

Sun, Glad to hear the script worked for you! It wasn’t deemed generally useful enough to put into the Percona Tools set (or Percona-Toolkit) :-D I’ve given it a “proper home” at https://github.com/rlowe/mysql_convert_charset for the time being … Pull Requests are welcome :) — Ryan Lowe

Post: How to recover deleted rows from an InnoDB Tablespace

…: mysql (information_schema) > SELECT ROW_FORMAT from TABLES WHERE TABLE_SCHEMA=’employees’ AND TABLE_NAME=’salaries’; +————+ | ROW_FORMAT | +————+ | Compact | +————+ ~/recovery-tool# ./page… 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: How Percona diagnoses MySQL server stalls

… post is about how to set up and use the tools. The tools are all part of the Aspersa toolkit. There are… finish these, I’ll post them on Percona.TV, our MySQL video/screencast blog site. Another interesting topic is how to…. There are many things that can cause a stall in MySQL, and they usually begin microscopically and get worse over time…

Post: Percona Toolkit 2.1 with New Online Schema Change Tool

… suite of administrative tools for MySQL. With this release we introduce a new version of pt-online-schema-change, a tool that enables…. With this new version of the tool, one of the most painful things anyone experiences with MySQL is significantly alleviated. If you… have completely redesigned and rebuilt the pt-summary and pt-mysql-summary tools. The changes are not so obvious to the user…

Post: Zero-Downtime Schema Changes In MySQL

… you say bail out, what does that mean? Does the tool clean up (i.e., remove table / triggers?) About cleanup.. What… run. will that cleanup ? Q: dose the tool exit gracefully while interupted? The tool doesn’t clean up the temporary table or…_x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I would…

Post: MySQL Configuration Wizard Updated

… sanity/safety options to prevent common problems MySQL users run into because of too-permissive MySQL behaviors. These are the kinds of… that Drizzle fixes — and should be fixed by default in MySQL — but never will be because they might break applications that… the comments. We hope this suite of free browser-based tools helps you become a more productive MySQL user and administrator!

Post: The tool I've been waiting for years

tool is simplistic but it shows how to use the function so you can write real stuff. For example using this tool MySQL… ib_log* 257M ib_logfile0 257M ib_logfile1 [root@DB01 mysql]# perl /tmp/fincore –justsummarize ib_logfile0 ib_logfile1 page size… because it is not aligned. [root@DB01 mysql]# du -h ibdata* 246G ibdata1 [root@DB01 mysql]# perl /tmp/fincore –justsummarize ibdata1 page…

Post: How Can Percona MySQL Server Development Services Help ?

… performance from your MySQL server via our Percona MySQL Consulting, Percona MySQL Support, and Percona MySQL Remote DBA services. With our MySQL Server Development Services… Open Source everything. Percona Toolkit and Other Tools – So far I’ve been writing about MySQL Server only, though this is not…-Percona Tools – Can we help you with non-Percona Tools, too? We have worked with a number of Open Source tools from the MySQL

Post: Basic performance and diagnostic tools on Solaris

…’s Big Important Tools such as DTrace. But I don’t recall seeing much in the MySQL blogs about basic tools to find…. Here’s a quick list of some key tools. Many of the tools you’re used to from Linux will work, although… preferred is top. Instead, you should use the native Solaris tool, prstat, which is more accurate. To display information about processors…

Post: Visualization tools for pt-query-digest tables

When you process MySQL slow query logs using pt-query-digest you can store …_slow_verbosity. Actually, this is a very simple and straightforward tool to browse slow queries. The web interface is AJAX-based… post reviews. Box Anemometer Anemometer is a tool for visualizing collected data from the MySQL Slow Query Log. The name comes from…