Innodb
Blogs are updated every hour. Blogs with voting buttons are updated as soon as an article is published.
| 0 |
This is the second blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. This blog post is aimed at the optimizer enhancement Multi Range Read (MRR). Its available in both MySQL 5.6... 0 Published 64 days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
A Story of MySQL and InnoDB at Facebook Told by Mark Callaghan: Just whetting your apetite for this interview with Mark Callaghan about MySQL, InnoDB, and his work at Facebook: Q: How do you make MySQL both “less slow” and “faster” at the same time? A: I ... 0 Published 72 days ago in
myNoSQL • NoSQL Databases and...: Profile, Details
|
| 0 |
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new o... 0 Published 73 days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
This is a time-honored topic, and there’s no shortage of articles on the topic on this blog. I wanted to write a post trying to condense and clarify those posts, as it has taken me a while to really understand this relationship. Some basic facts Mos... 0 Published 97 days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
Once upon a time, it would have been considered madness to even attempt to create 30,000 tables in InnoDB. That time is now a memory. We have customers with a lot more tables than a mere 30,000. There have historically been no tests for anything near this... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
0 |
Now that flash storage is becoming more popular, IO alignment question keeps popping up more often than it used to when all we had were rotating hard disk drives. I think the reason is very simple – when systems only had one bearing hard disk drive ... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
0 |
In the first part of this article I have showed how I align IO, now I want to share results of the benchmark that I have been running to see how much benefit can we get from a proper IO alignment on a 4-disk RAID1+0 with 64k stripe element. I haven’... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
There are two ways InnoDB can organize tablespaces. First is when all data, indexes and system buffers are stored in a single tablespace. This is typicaly one or several ibdata files. A well known innodb_file_per_table option brings the second one. Tables... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
I recently worked on a customer case where at seemingly random times, inserts would fail with Innodb error 139. This is a rather simple problem, but due to it’s nature, it may only affect you after you already have a system running in production for... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
I’ve been working with an application which does a lot of CREATE and DROP table for Innodb tables and we’ve discovered DROP TABLE can take a lot of time and when it happens a lot of other threads stall in “Opening Tables” State. ... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
0 |
In my recent benchmarks like http://www.mysqlperformanceblog.com/2010/12/21/mysql-5-5-8-and-percona-server-on-fast-flash-card-virident-tachion/, I used different innodb_buffer_pool_size, like 13GB, 52GB, 144GB for the tpcc-mysql database with size 100G. I... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
You might know if you have long running transactions you're risking having a lot of "garbage" accumulated in undo segment size which can cause performance degradation as well as increased disk space usage. Long transactions can also be bad for other re... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
I again work with the system which needs high insertion rate for data which generally fits in memory. Last time I worked with similar system it used MyISAM and the system was built using multiple tables. Using multiple key caches was the good solution a... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
Inspired by Baron’s earlier post, here is one I hear quite frequently - “If you enable innodb_file_per_table, each table is it’s own .ibd file. You can then relocate the heavy hit tables to a different location and create symlinks to th... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
Percona XtraBackup 1.5-Beta is now available for download. This release adds additional functionality to Percona XtraBackup 1.4, the current general availability version of XtraBackup. This is a beta release. Functionality Added or Changed Support for My... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
I wanted for a while to write about using MySQL Partitioning for Performance Optimization and I just got a relevant customer case to illustrate it. First you need to understand how partitions work internally. Partitions are on the low level are separate... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
Understanding how well your tables and indexes fit to buffer pool are often very helpful to understand why some queries are IO bound and others not - it may be because the tables and indexes they are accessing are not in cache, for example being washed aw... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
Erin and Mike, organizers of SF Meetup generously invited me to talk on coming SF Meetup on Dec-14 about new features in InnoDB in MySQL 5.1 and 5.5 and, what is pay attention to, when you upgrade from MySQL 5.0. Although I personally mostly in 5.1->5.5 u... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
I do not know if it is because we’re hosting a free webinar on migrating MyISAM to Innodb or some other reason but recently I see a lot of questions about migration from MyISAM to Innodb. Webinar will cover the process in a lot more details though... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
Percona XtraBackup 1.4 is now available for download. Version 1.4 fixes problems related to incremental backups. If you do incremental backups, it’s strongly recommended that you upgrade to this release. Functionality Added or Changed Incremental b... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
I occasionally get in to light arguments healthy discussions with students about whether or not to use Foreign Key constraints on InnoDB tables. My standard response has always been: “it depends on how much of a tradeoff you are willing to make fo... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
How long it may take MySQL with Innodb tables to shut down ? It can be quite a while. In default configuration innodb_fast_shutdown=ON the main job Innodb has to do to complete shutdown is flushing dirty buffers. The number of dirty buffers in the bu... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
A couple of weeks ago one of my colleagues and I worked on a data corruption case that reminded me that sometimes people make unsafe assumptions without knowing it. This one involved SAN snapshotting that was unsafe. In a nutshell, the client used SAN bl... 1 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
I recently did a quick analysis of the distribution of writes to InnoDB’s log files. On a high-traffic commodity MySQL server running Percona XtraDB for a gaming workload (mostly inserts to the “moves” table), I used strace to gather st... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
0 |
This is the first of a series of posts about business intelligence tools, particularly OLAP (or online analytical processing) tools using MySQL and other free open source software. OLAP tools are a part of the larger topic of business intelligence, a top... 1 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
There’s lots of buzz lately about the so-called “open-core” business model of Marten Mickos’s new employer. But this is nothing new. Depending on how you define it, InnoDB is “open-core,” and has been for a long time. ... 0 Published 100+ days ago in
Xaprb: Profile, Details
|
| 0 |
Details About Riak Innostore and Bitcask Backends: With the recent release 0.11.0 Riak switched the default backend storage from using embedded Innostore to Bitcask. Andy Gross and johne had a very interesting conversation about the differences between In... 0 Published 100+ days ago in
myNoSQL • NoSQL Databases and...: Profile, Details
|
| 0 |
So you're running MySQL With innodb_file_per_table option but your ibdata1 file which holds main (or system) tablespace have grown dramatically from its starting 10MB size. What could be the reason of this growth and what you can do about it ? There are ... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
I just wrote a large post on reasons for innodb main tablespace excessive growth and I thought it would make sense to explain briefly of why it is so frequently you have purge not being the problem at all and when out of no where you can see purge thre... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
Quite frequently I see people confused what table locks reported by SHOW INNODB STATUS really mean. Check this out for example: PLAIN TEXT SQL: ---TRANSACTION 0 4872, ACTIVE 32 sec, process no 7142, OS thread id 1141287232 2 LOCK struct(s), ... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
One of the things that makes a traditional transactional database hard to make highly available is a relatively slow shutdown and start-up time. Applications typically delegate most or all writes to the database, which tends to run with a lot of “d... 0 Published 100+ days ago in
Xaprb: Profile, Details
|
0 |
InnoDB has an oft-unused parameter innodb_concurrency_tickets that seems widely misunderstood. From the docs: "The number of threads that can enter InnoDB concurrently is determined by the innodb_thread_concurrency variable. A thread is placed in a que... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 0 |
One schema optimization we often do is extending index when there are queries which can use more key part. Typically this is safe operation, unless index length increases dramatically queries which can use index can also use prefix of the new index are th... 1 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 14 |
Upgrading from MySQL 5.0 to MySQL 5.1 or Percona Server 5.1 you may run into issues with mysql_upgrade – it will identify some tables to be upgraded and will attempt to run REPAIR TABLE for them. This will fail with “The storage engine for... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 2 |
The amount of memory Innodb will require for its data dictionary depends on amount of tables you have as well as number of fields and indexes. Innodb allocates this memory once table is accessed and keeps until server is shut down. In XtraDB we have an o... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 2 |
As I mentioned in my talk An Overview of Flash Storage for Databases I see in the near and middle term future a lot of interest for using Flash storage in Level 2 caching level. The price-capacity trade-off makes Flash as the very good fit for a cache la... 1 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
5 |
I did some drawing exercise and put XtraDB / InnoDB internals in Visio diagram: The XtraDB differences and main parameters are marked out. PDF version is there http://www.percona.com/docs/wiki/percona-xtradb:internals:start. Entry posted by Vadi... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
20 |
MySQL-5.5.4 ® is the great release with performance improvements, let’s see how it performs in tpcc-like workload. The full details are on Wiki page http://www.percona.com/docs/wiki/benchmark:mysql:554-tpcc:start I took MySQL-5.5.4 with InnoDB-... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 3 |
In XtraDB we have the table INNODB_BUFFER_POOL_PAGES_INDEX which shows which pages belong to which indexes in which tables. Using thing information and standard TABLES table we can see how well different tables fit in buffer pool. PLAIN TEXT SQL: m... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 6 |
As soon as we get couple FusionIO cards, there is question how to join them in single space for database. FusionIO does not provide any mirroring/stripping solutions and totally relies on OS tools there. So for Linux we have software RAID and LVM, I tried... 1 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 5 |
In Released and new coming features I did not mentioned two additional INFORMATION_SCHEMA tables available in XtraDB: It is INNODB_TABLE_STATS INNODB_INDEX_STATS These table show statistics about InnoDB tables ( taken from InnoDB data dictionary). IN... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
10 |
I recently was asked what maximal amount transactions per second we can get using MySQL and XtraDB / InnoDB storage engine if we have high-end server. Good questions, though not easy to answer, as it depends on: - durability setting ( innodb_flush_log_at... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
10 |
Oracle recently announcent MySQL-5.5.2-m2 milestone, and I have a predition that MySQL-5.5 will be announced as GA on MySQL UC 2010 in April. So let’s make quick on scalability characteristics we should expect from new release. I made sysbench oltp ... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 6 |
Running many benchmarks on fast storage (FusionIO, SSDs) and multi-cores CPUs system I constantly face two contention problems. So I suspect it’s going to be next biggest issues to make InnoDB scaling on high-end system. This is also reason why in b... 1 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 1 |
As I wrote about 2 years ago the feature of Innodb to store copy of master’s position in Slave’s Innodb tablespace got broken. There is a lot of discussions at the corresponding bug report while outcome of the fix remained uncertain for me ... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
5 |
Question what is better isolation level is poping up again and again. Recently it was discussed in InnoDB : Any real performance improvement when using READ COMMITED isolation level ? and in Repeatable read versus read committed for InnoDB . Serge in hi... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 11 |
I’m running in this misconception second time in a week or so, so it is time to blog about it. How blobs are stored in Innodb ? This depends on 3 factors. Blob size; Full row size and Innodb row format. But before we look into how BLOBs are... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 10 |
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... 0 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 9 |
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 ... 1 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
| 5 |
I can think of at least two major reasons why systems delay flushing changes to durable storage: 1. So they can do the work when it’s more convenient. 2. So they can do less work in total. Let’s look at how the second property can be true. A c... 1 Published 100+ days ago in
MySQL Performance Blog: Profile, Details
|
Page 1 out of 20:
Blogs with invalid RSS feeds, or feeds that contain more than 50 posts are not included in TopBlogLog. Blogs that spam can be removed from the main page or deleted from TopBlogLog.
Categories
- Recipes (52)
- Humor (26)
- Photography (18)
- Development (15)
- Personal (12)
- Technology (11)
- Fashion (9)
- Design (4)
- Crafts (4)
- Music (3)
- Travel (3)
- Women (3)
- Architecture (3)
- Economy (3)
- Education (2)
- Politics (2)
- Law (2)
- Movies (2)
- Green (2)
- Games (2)