… InnoDB tables and indexes. This can be useful to examine whether you’d benefit from “defragmenting” your MySQL database with OPTIMIZE TABLE, although… nicely to give an overview of fragmentation. It’s an initial draft, and if you find issues with it I would like… top of the code listing. The output looks like this: TABLE INDEX TOT_PAGES FREE_PAGES PCT_FULL art.link_out104…
Post: INFORMATION_SCHEMA tables in the InnoDB pluggable storage engine
May 24, 2008 By Leave a Comment
…tables that show some status information about InnoDB. Here are the tables: mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE ‘INNODB%’; +—————————————-+ | Tables…fragmentation etc. Beware that selecting from the tables…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
…table with simple structure: mysql> show create table dt2 \G *************************** 1. row *************************** Table: dt2 Create Table: CREATE TABLE…table structures (ie longer rows) also may affect results, not to mention tables with fragmented… data (including fragmentation) to find…
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
…profile (often together with strace) are great tools for MySQL Performance analyses. Too many people end tuning …first is finding the free region of required size, which can get expensive if virtual memory gets fragmented. … – if you have small table or LIMIT 10 in full table scan query you well may …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…at Users Conference but I’m just starting find bits of time from processing accumulated backlog. The…tables, such as what is the average size pages were compressed to for data and for various indexes. How many “fragmented…where already which may come in MySQL 5.2 or even MySQL 5.1. I surely would like…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… Block size: 4096 Fragment size: 4096 Reserved GDT blocks: 316 Blocks per group: 32768 Fragments per group: …buy a little bit of time before they find more permanent solution. Maximum mount count: -1 … same as you would every so often check MySQL tables for corruption. To change those options you can…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…of concurrent writes to about 6 tables, what version of Innodb/MySQL would you recommend? I’ve been…helped us greatly to spot scalability problems and find fixes for them. The work continues. I …1 MB. Then a full table scan would be fast. Maybe the table has become fragmented? Or maybe you have…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…might find it interesting. In many cases what I find good or bad would base of my MySQL use… changed since last read in table ‘t’” error message. If you find Falcon or Innodb behavior better …not found much information about is regarding handling fragmentation – what happens on row updates, are they …
Page: Tools
May 30, 2008 By 31 Comments
… just need to find they are there. Percona Toolkit Percona Toolkit is a great set of tools for MySQL Performance Analyses and… Innodb tables. Very nice to watch what happens to server in the real time. filefrag filefrag is the fool to check fragmentation of the file. Ever wondered how fragmented your tablespace or table on the file level ? iostat…
Post: Just do the math!
July 6, 2009 By 4 Comments
… to the whole year worth of data you find things not working any more with response times… the temporary table – the number of rows MySQL can insert/update depends on whenever temporary table can be kept…this number can be affected a lot by file fragmentation, on other hand there is also caching which…
