MySQL-dump - Comments

santosh: An InnoDB tutorial

nospam@example.com (santosh) — Mon, 21 Jul 2008 11:13:57 +0200

I have a problem in deleting the child table row from my application using unique id. when I am using the command prompt it is getting deleted. But, from my application when I am deleting a post the result is 1 but, when I am refreshing the post.php I can see the post which I have tried to delete

Azundris: Nermalisation

nospam@example.com (Azundris) — Sat, 05 Jul 2008 16:08:58 +0200

The point is that you have the option to not do, but then you'll be in a world of pain. The point is also to show that if you do it, how to do it. A more technical approach is here:
http://en.wikipedia.org/wiki/Database_normalization

fdask: Nermalisation

nospam@example.com (fdask) — Fri, 04 Jul 2008 15:40:45 +0200

Nice little article, and I like how you've used cats in your examples :)

I am a little unclear what the point here is though... break tables up?

Salmiakki: Salmiakki - the official MySQL Drink

nospam@example.com (Salmiakki) — Sun, 08 Jun 2008 11:34:56 +0200

150g of liquorice are enough to get the original Salmiakki taste.... you can add some more, anyway

mohammad: DB Designer becomes MySQL Workbench

nospam@example.com (mohammad) — Wed, 28 May 2008 05:41:16 +0200

It's very good

delbertino: phpvikinger.org: Things that have no name

nospam@example.com (delbertino) — Sun, 11 May 2008 06:34:15 +0200

In reply to "stuff with no names":very informative and succinct. I am retired and need to learn to build a website for e-commerce;check dull "on-line thriftshop" @"zmama.vstore.ca" to see why I need to take control but need to learn PHP v6 now.Thanx for your precious time.

ashok: What is the difference between MySQL and Postgres?

nospam@example.com (ashok) — Wed, 30 Apr 2008 14:08:45 +0200

what is the difference between MySql and PostgreSql?

fortunecookienotes: Fortune Cookie

nospam@example.com (fortunecookienotes) — Wed, 09 Apr 2008 21:46:52 +0200

What a random fortune, who knows what it means. My favorite random fortune cookie note reads "you will make a good laywer."

Harrison Fisk: Configuring InnoDB - An InnoDB tutorial

nospam@example.com (Harrison Fisk) — Thu, 27 Mar 2008 19:17:51 +0100

Hi Kristian,

I noticed a few things that are wrong with your above article. Overall it is good however, so don't take this as complaints ;)

1. innodb_flush_method=O_DIRECT: In this case, the data files are opened with O_DIRECT, but the REDO logs are not and still use fsync.

This is due to the fact that O_DIRECT requires aligned access, but the REDO doesn't have nice always aligned access. The data files always are accessed in 16k pages, so it is always aligned.

2. Background recovery in 5.0: Only the UNDO process is done in the background, the REDO log replay will still be done prior to startup. So the size of the log files still does impact restart time. They are the only thing that effect recovery time now, whereas previously the size of the UNDO segments did as well.

3. Innodb_log_waits: This status counter is for when the innodb_log_buffer is full and needs to synchronously flushed and is not at all related to when a checkpoint needs to be done.

Feel free to catch me on IRC if you have any questions about these. Thanks!

Erik: Rubyisms

nospam@example.com (Erik) — Wed, 19 Mar 2008 15:01:13 +0100

Sorry, I should mention that the create transaction simply involves doing:

content = BlogContent.new(params[:content])
entry = BlogEntry.new(params[:entry].merge(:content => content))
entry.save!

Erik: Rubyisms

nospam@example.com (Erik) — Wed, 19 Mar 2008 14:51:13 +0100

I like to separate text and blob columns into their own models and tables, storing and managing the record content separate from its meta data.

For example in the case of a blog I would have two models: BlogEntry and BlogContent the later having just an id and text column. This allows me to RUD the metadata separately from the content and use lazy loading of the content when needed. The only hitch is that you need to wrap the create operation in a transaction.

This avoids many of the problems mentioned above and offers a great deal of flexibility in how the bulk of the data (the content) is managed on the back end.

James deville: Rubyisms

nospam@example.com (James deville) — Wed, 27 Feb 2008 04:47:51 +0100

IMHO: Rails is being designed and primarily used by people with a dedicated DB. So the idea of constraining in the DB is not as important. As David H has said multiple times, if something bothers you, submit a patch.

If you are here and unable to code in ruby for a patch you would like, let me know (james dot deville with gmail), and I'll even see if I can do it for you!

James deville: Rubyisms

nospam@example.com (James deville) — Wed, 27 Feb 2008 04:33:16 +0100

Rails only uses transactions if you ask it to. If you just do a People.find(:all), it does a select * from people, not a begin; select * from people; commit;

James: A quick tour of DRBD

nospam@example.com (James) — Tue, 26 Feb 2008 00:00:58 +0100

DRBD acts like a mirror of a disk only instead of copying to a local disk on the server it copies accross the network to another server. So as soon as you make a change to the primary server it is written to the disk of the failover server.

Nilesh: Configuring InnoDB - An InnoDB tutorial

nospam@example.com (Nilesh) — Tue, 19 Feb 2008 19:58:52 +0100

Hi,
I have been working on an MySQL DBA Dashboard. The Dashboard currently has basic information from the information schema.

Would like your opinion to improve and make it useful, for e.g to add DB performance metrics etc, but not sure where this information would be available.

Your opinion is highly regarded and will really appreciate if you could point me to some resources on this.
( njethwa @ gma!l . com)
Regards
Nilesh
MySQL Dashboards