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 often should you use OPTIMIZE TABLE?

  
  Xaprb — Authority: 409
  Many times I’ve heard people advise on “best practices” for a MySQL database. This often includes routine maintenance, such as “you should run OPTIMIZE TABLE on all of your InnoDB tables once a week to defragment them for better performance.” But this advice is unsubstantiated and could even be ...
  1 day ago

• 10x Performance Improvements in MySQL – A Case Study

  
  MySQL Expert | MySQL Performance | MySQL Scalability — Authority: 409
  The slides for my presentation at FOSDEM 2010 are now available online at slideshare . In this presentation I describe a successful client implementation with the result of 10x performance improvements. My presentation covers monitoring, reviewing and analyzing SQL, the art of indexes, improving SQL, storage engines ...
  2 days ago

• innodb_file_per_table, shrinking table spaces and the data dictionary

  
  mySQL DBA — Authority: 388
  INNODB has some irritating gotchas that makes disk space management hard. In 2002ish INNODB, added innodb_file_per_table to get around allot of these issues, but it does not fix everything. If you are running innodb_file_per_table, you will notice in your database directory db.opt - database characteristics file. ...
  5 days ago

• 迁移 Innodb 共享表空间至独立表空间 – MySQL邯郸学步

  
  ??? — Authority: 110
  关于 MySQL 中的 Innodb 引擎就不多说了, 毕竟除了MyISAM 之外, 它的应用最广泛. Innodb 存储数据有两种方式: 共享表空间 和 独立表空间. 顾名思义, 共享表空间 就是把所有数据库数据放在一个或多个文件中( 这种方式的话,使用裸设备倒是很方便); ...
  1 week ago

• How to compress your InnoDB Backup

  
  JortK.nl — Authority: 141
  Read the complete article on the MySQL Performance Blog Playing with last version of xtrabackup and compress it I noticed that gzip is unacceptable slow for both compression and decompression operations. Actually Peter wrote about it some time ago, but I wanted to review that data having some new ...
  2 weeks ago

• Why Swapping is bad for MySQL Performance ?

  
  MySQL Performance Blog — Authority: 487
  So you get MySQL or other applications using too much memory on the box or OS behaving funny and using more memory for cache and pushing application to the swap. This causes swapping and causes performance problems. This much is obvious. But how bad is it ? Should you count it same as normal Disk IO as the box is ...
  3 weeks ago

• InnoDB, InnoDB-plugin vs XtraDB on fast storage

  
  MySQL Performance Blog — Authority: 487
  To continue fun with FusionIO cards, I wanted to check how MySQL / InnoDB performs here. For benchmark I took MySQL 5.1.42 with built-in InnoDB, InnoDB-plugin 1.0.6, and XtraDB 1.0.6-9 ( InnoDB with Percona patches). As benchmark engine I used tpcc-mysql with 1000 warehouses ( which gives around 90GB of data + ...
  3 weeks ago

• Great tips to improve your MySQL performance

  
  JortK.nl — Authority: 141
  Some great articles on how to improve the performance of your MySQL Server: Optimize slow queries with mk-query-digest Use delayed flushing table_cache negative scalability How innodb_open_files affect performance Use of table_cache Thanks to MySQLPerformanceblog.com ! Related posts: Usefull MySQL ...
  4 weeks ago

Comments about innodb