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”

• How many partitions can you have ?

  
  MySQL Performance Blog — Authority: 419
  I had an interesting case recently. The customer dealing with large datawarehouse had the table which was had data merged into it with INSERT ON DUPLICATE KEY UPDATE statements. The performance was extremely slow. I turned out it is caused by hundreds of daily partitions created for this table. What is the ...
  1 day ago

• Great work Innodb Team

  
  MySQL Performance Blog — Authority: 419
  I thought I should praise Innodb team for all the work they have been doing recently. We see a lot of cool stuff happening, especially in the area of our interest which is Performance And Scalability. Innodb Plugin 1.0.4 had a lot of great performance improvements and 1.0.5/1.0.6 gets even further with long standing ...
  5 days ago

• UK2 Group announces the availability of R1Soft Continuous Data Protection (CDP) across virtual private server cloud

  
  Top 10 Dedicated Server Hosting Reviews, News and Articles — Authority: 131
  UK2 Group today announced the availability of R1Soft Continuous Data Protection® (CDP) across its extensive virtual private server cloud. VPS.NET (http://vps.net) now offers customers a more advanced level of data protection with user-ready CDP backups and individual file-restoration capabilities. VPS.NET offers an ...
  1 week ago

• Redis, Memcached, Tokyo Tyrant and MySQL comparision (rectification skip-name-resolve)

  
  ruturaj.net - ?????? ?? Home Page — Authority: 457
  My previous post Redis, Memcache, Tokyp Tyrant, MySQL comparison had a flaw as pointed out by this comment . The MySQL was taking a huge time for doing a reverse DNS lookup. I turned on the skip-name-resolve parameter in the my.cnf and the Throughput of MySQL grew considerably, almost more than double. read ...
  1 week ago

• ON DUPLICATE KEY With NULL Validation

  
  Venu Anuganti Blog — Authority: 100
  I am not sure if this is a bug or how MySQL works on validating constraints in association with ON DUPLICATE KEY (late or early checking). For example, consider the following use case (this is irrepective of storage engine and MySQL version): mysql > create table t1 ( id int not null primary key ...
  2 weeks ago

• How innodb_open_files affects performance

  
  MySQL Performance Blog — Authority: 419
  Recently I looked at table_cache sizing which showed larger table cache does not always provides the best performance. So I decided to look at yet another similar variable – innodb_open_files which defines how many files Innodb will keep open while working in innodb_file_per_table mode. Unlike MyISAM Innodb ...
  2 weeks ago

• InnoDB Tablespace Corruption

  
  Venu Anuganti Blog — Authority: 100
  Over the weekend, I experienced a strange issue (even though its not new) with the InnoDB tablespace (ibdata) corruption. When in general InnoDB crashes, it automatically recovers during the next start by rolling back/forward based on what was pending and un-flushed/un-committed changes at the time of crash. But for ...
  2 weeks ago

• InnoDB线程并发检查机制

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

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

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

• InnoDB: look after fragmentation

  
  MySQL Performance Blog — Authority: 419
  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 ...
  4 weeks ago

• XtraDB存储引擎

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

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

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

• Speaking at the LA MySQL Meetup – 18th November

  
  MySQL Performance Blog — Authority: 419
  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 ...
  5 weeks ago

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

  
  MySQL Performance Blog — Authority: 419
  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 ...
  5 weeks ago

• Version 1.1.4 of improved Cacti templates released

  
  Xaprb — Authority: 411
  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 ...
  5 weeks ago

• What do the InnoDB insert buffer statistics mean?

  
  Xaprb — Authority: 411
  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 ...
  5 weeks ago

• Deleting Data From InnoDB

  
  AF-Design — Authority: 104
  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 [...]
  6 weeks ago

Comments about innodb