innodb

Welcome to the 'innodb' tag page at Technorati. This page features content from the farthest reaches of the Blogosphere that authors have "tagged" with 'innodb'.

Latest blogosphere posts tagged “innodb”

• InnoDB线程并发检查机制

  
  NinGoo.net — Authority: 116
  Author: NinGoo posted on NinGoo.net InnoDB在接受MySQL线程调用能时，有一个并发线程的检查机制，通过 innodb_thread_concurrency 参数进行控制。如果参数设置大于0，则表示检查机制开启，允许进入的线程数就是参数的值。等于0则禁用并发检查。 ...
  1 week ago

• 从show innodb status看XtraDB的增强特性

  
  NinGoo.net — Authority: 116
  Author: NinGoo posted on NinGoo.net XtraDB存储引擎相对于标准的InnoDB引擎做了很多的改进，从show innodb status的结果可以初步看到部分增强的特性。下面是一个XtraDB测试环境(Linux)的结果： root@(none) 11:25:18>show innodb status\G*************************** 1. ...
  1 week ago

• InnoDB: look after fragmentation

  
  MySQL Performance Blog — Authority: 538
  One problem made me puzzled for couple hours, but it was really interesting to figure out whats going on. So let me introduce problem at first. The table is PLAIN TEXT CODE: CREATE TABLE `c` (   `tracker_id` int ( 10 ) unsigned NOT NULL,   `username` char ( 20 ) character set latin1 ...
  1 week ago

• XtraDB存储引擎

  
  NinGoo.net — Authority: 116
  Author: NinGoo posted on NinGoo.net XtraDB存储引擎是 percona 公司对于innodb存储引擎进行改进加强后的产品，第一个版本为 1.0.2-1 ，发布于2008年底。XtraDB兼容innodb的所有特性，并且在IO性能，锁性能，内存管理等多个方面进行了增强。 ...
  1 week ago

• I’m a Postgres user, as it turns out

  
  Xaprb — Authority: 120
  Someone recently posted this to an email list as a sample of an interesting SHOW INNODB STATUS output: mysql> SHOW ENGINE INNODB STATUS\G _______ _______|\ /|( ____ \( ____ \| ) ( || ( \/| ( \/| | | || (_____ | (__| | | |(_____ )| __)| | | | ) || (| (___) |/\____) || ...
  1 week ago

• Speaking at the LA MySQL Meetup – 18th November

  
  MySQL Performance Blog — Authority: 538
  A recent photo from Highload.ru I said in my last post , that we’re interested in speaking at MySQL meetups, and I’m happy to say that the Los Angeles MySQL Meetup has taken us up on the offer. On November 18th, I’ll be giving an introductory talk on InnoDB/XtraDB Performance Optimization .  I will be the ...
  2 weeks ago

• State of the art: Galera – synchronous replication for InnoDB

  
  MySQL Performance Blog — Authority: 538
  First time I heard about Galera on Percona Performance Conference 2009, Seppo Jaakola was presenting “Galera: Multi-Master Synchronous MySQL Replication Clusters” . It was impressed as I personally always wanted it for InnoDB, but we had it in plans at the bottom of the list, as this is very hard to implement ...
  2 weeks ago

• Version 1.1.4 of improved Cacti templates released

  
  Xaprb — Authority: 120
  I’ve released version 1.1.4 of my improved Cacti templates . Unlike the prior release, which was solely bug fixes, this one includes new graphs in the MySQL template. Some of the graphs are of data that’s exposed in standard MySQL versions, but some of it is available only in Percona’s high-performance ...
  2 weeks ago

• What do the InnoDB insert buffer statistics mean?

  
  Xaprb — Authority: 120
  Ever seen this in SHOW INNODB STATUS and wondered what it means? -------------------------------------INSERT BUFFER AND ADAPTIVE HASH INDEX-------------------------------------Ibuf: size 1, free list len 4634, seg size 4636, I’ve never been quite sure, and Peter didn’t really clarify things himself, so I ...
  3 weeks ago

• Deleting Data From InnoDB

  
  AF-Design — Authority: 111
  Problem: We are given a large MySQL database table that no longer fits in your system’s working memory. You need to prune the data since a significant portion of this data is no longer relevant to keep in this table. Our expectation is ~75% of the data will remain in the table because of [...]
  3 weeks ago

• Foreign key constraints support in MyISAM

  
  IT answers — Authority: 457
  New Question Created by Linux - Ask the Expert
  3 weeks ago

• Training Updates

  
  MySQL Performance Blog — Authority: 538
  I wanted to provide an update on two things: Firstly, we have opened registration for InnoDB/XtraDB training in Los Angeles (Nov 18th). The second is that while I am in New York City for training (Oct 29th), I’ll be giving a (free) talk at the MySQL Meetup group there (Oct 28th). We love to speak at ...
  4 weeks ago

• MySQL InnoDB and table renaming don’t play well…

  
  Masterzen's Blog — Authority:
  At Days of Wonder we are huge fans of MySQL (and since about a year of the various Open Query , Percona , Google or other community patches), up to the point we’re using MySQL for about everything in production. But since we moved to 5.0, back 3 years ago our production databases which hold our website and ...
  4 weeks ago

• Detecting and Resolving LAMP Stack Problems – Scheduled Downtime

  
  Karl Katzke — Authority: 92
  In the last issue of my current consulting saga, Detecting and Resolving LAMP Stack Performance Problems , we talked about a Drupal site that was being brought offline every few hours due to poor tuning of the LAMP stack. With the default settings, a site isn’t going to take much before it just falls flat on it’s ...
  4 weeks ago

• Tuning for heavy writing workloads

  
  MySQL Performance Blog — Authority: 538
  For the my previous post , there was comment to suggest to test db_STRESS benchmark on XtraDB by Dimitri. And I tested and tuned for the benchmark. I will show you the tunings. It should be also tuning procedure for general heavy writing workloads. At first, . The next, to stabilize performance  and to avoid ...
  4 weeks ago

• Which adaptive should we use?

  
  MySQL Performance Blog — Authority: 538
  As you may know, InnoDB has 2 limits for unflushed modified blocks in the buffer pool. The one is from physical size of the buffer pool. And the another one is oldness of the block which is from the capacity of transaction log files. In the case of heavy updating workload, the modified ages of the many blocks are ...
  8 weeks ago

Comments about innodb