…position," i.e. a random-read. What this actually means varies between storage engines. For MyISAM, position really means a byte offset from the beginning of the file. For InnoDB, it means to read a row based on a primary key value.
Handler read rnd next is incremented when handler::rnd_next() is called. This is basically a cursor operation: read the "next" row in the table. The operation advances the cursor position so the next time it's called, you get the next …
…does not give you any surprises. Have you seen people being confused about the fact you can copy MyISAM tables on file basics but not Innodb ? By the fact you can have transactions with MyISAM tables but they would not actually roll back ? Replication which can get broken by Server Crash ? A lot of people are just looking for database which just has the job done, has quick learning curve is robust and easy to operate and has few surprises. As MySQL matures and gets more and more used …
- igvita.com: Schema-Free MySQL vs NoSQL
- Ruby on Rails, JRuby, AWS, EC2, Exalead - Bugmash! Comments: InfiniDB, InfoBright and MonetDB
- oldmoe: 101 Reasons Why PostgreSQL is a better fit for Rails than MySQL
- How Software is Built: Interview with Ezra Zygmuntowicz - Engine Yard
- MicroISV on a Shoestring: Quick Start For Rails on Windows Seven
- blog.webandy.com | Andy Atkinson: Rails Deployments
…and then finally got down to business and did a show create table my_table_name and whoa, it's MyISAM! That's not good. So I set this option in /etc/my.cnf : default-storage-engine = innodb
Restarted MySQL - what's this, it wouldn't start! Checked the logs: 100303 18:37:37 [ERROR] Unknown/unsupported table type: INNODB 100303 18:37:37 [ERROR] Aborting
Now we're getting somewhere. The clincher: mysql> show engines; +------------+---------+-----------------------------------------------------------+--------------+------+------------+ …
- MySQL Performance Blog: XtraDB storage engine release 1.0.6-9
- igvita.com: Measuring & Optimizing I/O Performance
- oldmoe: 101 Reasons Why PostgreSQL is a better fit for Rails than MySQL
- Ruby on Rails, JRuby, AWS, EC2, Exalead - Bugmash! Comments: InfiniDB, InfoBright and MonetDB
- Home - Leading Ruby on Rails Development and Consulting firm in India - Vinsol: 11 Things to Consider Before Deploying Your Rails Application
- a work on process: Weekend Links
…durability, reduce sync delay. Closest comparison to the durability behaviour is MySQL's MyISAM.
Data is not written transactional, so if the server is killed during a write operation, the data is likely to be inconsistent or even corrupted and needs repair. Think classic file systems like ext2 or MyISAM.
In MongoDB 1.3 a database flush to disk can be enforced by sending the fsync command to the server.
Replication
Replication is the recommended way of ensuring data durability …
- Trevor Turk: Weekly Digest, 3-24-10
- Viget Extend : The Development Lab: RubyConf 2009 Recap
- Axon Flux // A Ruby on Rails Blog: How Superfeedr built Analytics using MongoDB
- Ruby Inside: Rackamole: Rack-Based Monitoring For Your Ruby Web Apps
- Railscasts: Episode 194: MongoDB and MongoMapper
- BenCurtis.com: An EngineYard Cloud Gotcha
…exception_logger, hoptoad, exceptional or simply but log exceptions to a DB table ( protip: make that table MyISAM, otherwise exceptions that are added during a transaction will be removed when that transaction rolls back - duh ). Those exception notifications are great but they never provide a lot of context for how the user got to the point.
Lastly there is also the role that log files play in customer support. Have you ever gotten a complaint about data disappearing from your service? With …
- Tender Lovemaking: Namespaces in XML
- danieltenner.com: A tale of two users
- How Software is Built: Interview with Con Zymari - CEO Cybersource
- MicroISV on a Shoestring: Tracking Down A Subtle Analytics Bug
- Rails Envy » Home: Reports of This Podcasts Death Are Greatly Exaggerated
- Practical Ruby: Symmetric, self-referential has-one relationships in Rails
…in a database structured around using InfiniDB then the strings would be stored in a MyISAM table and referenced.
After successfully exporting a table from MySQL and importing it into InfiniDB using their colxml and cpimport tools we had a table of data and were able to run some simple queries, select count(*) for example. However, after a teabreak the queries were no longer running and giving an error: ERROR 122 ( HY000): There was an internal error encountered in the Calpont Engine…
Up for my first manic burst of work for the day.
DailyJS - A roundup of JavaScript stuff from Alex Young, Ric Roberts, and Justin Knowlden. It's off to a promising start.
Fixtures without validation with Factory Girl - Nice idea for generating bad data in a concise and repeatable way.
fast_fixture - Develop with MyISAM, test with InnoDB. Seems a bit iffy but should definitely speed up the tests.
shoulda-addons - Test profiling and color-coded test names for Shoulda.
Here's a little insight I had the other day.
If you use MyISAM tables, and there are various performance related reasons you might, then you've been stuck having to turn transactional fixtures off in your tests.
But unless you are using some special feature of MyISAM that is not present in InnoDB, then why not use InnoDB tables in your test database?
I wrote a simple plugin that has a rake task that clones the development database to the test while changing the ENGINE to InnoDB.
- Topics: InnoDB
- Rails Envy » Home: RailsLab: Scaling Your Database - Part 2
- Simple thoughts - articles: The Internal Storage Mechanism For Globalize for Rails Model Translations
- oldmoe: 101 Reasons Why PostgreSQL is a better fit for Rails than MySQL
- igvita.com: Measuring & Optimizing I/O Performance
In this screencast we first learn the difference between MyISAM and InnoDB storage engines. We then take a look at two strategies for scaling your database writes on a system, the first by using master master replication and the second by sharding your database. Along the way we'll learn about some useful tools for scaling your database, and look at how some big websites like eBay and New Relic shard their database.
Don't forget to subscribe to the screencast RSS feed or …
- Simple thoughts - articles: The Internal Storage Mechanism For Globalize for Rails Model Translations
- igvita.com: Measuring & Optimizing I/O Performance
The startup I had been working for went under, so I have been busy finding a new job and settling in. Got a good gig now at a new place and things are going well.
I'm not doing as much Ruby any more, but I am doing lots of datawarehousing work. There is a new engine out for mysql called 'infobright'. It has proven to be very quick when doing the kinds of queries you do when analyzing web statistics. Easily 10x as fast as MyISAM tables. Read more »
- oldmoe: 101 Reasons Why PostgreSQL is a better fit for Rails than MySQL
- Simple thoughts - articles: The Internal Storage Mechanism For Globalize for Rails Model Translations
- Videos related to 'Ruby on Rails vs PHP - Commercial #3 of 9': SOLMI news Sept 3rd, 2007
- Rubycon - All things geared towards web development: What Web 3.0 has in store for us.
- p.latyp.us: RubyWorks and Gem Sources