innodb

Tag details

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'.

Look up Offsite Link "innodb" at The Free Dictionary

Latest blogosphere posts tagged “innodb”

  • How often should you use OPTIMIZE TABLE?


    XaprbAuthority 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 ScalabilityAuthority 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 DBAAuthority 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 Authority: 110
    关于 MySQL 中的 Innodb 引擎就不多说了, 毕竟除了MyISAM 之外, 它的应用最广泛. Innodb 存储数据有两种方式: 共享表空间 和 独立表空间. 顾名思义, 共享表空间 就是把所有数据库数据放在一个或多个文件中( 这种方式的话,使用裸设备倒是很方便); ...
    1 week ago
  • How to compress your InnoDB Backup


    JortK.nlAuthority 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 BlogAuthority 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 BlogAuthority 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.nlAuthority 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

Personal attacks are NOT allowed
Please read our comment policy