Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 11

Displaying posts with tag: Notes (reset)

A few notes on locking in MySQL
+0 Vote Up -0Vote Down
posted by Ovais Tariq on Sat 14 May 2011 20:48 UTC
Tags:
(edit) mysql, Replication, Notes, locking, auto_increment, MVCC, row-level locking, mysql resources, innodb vs myisam, row-based, statement-based, read-lock, locking reads, shared locks, auto_inc lock, concurrent inserts, exclusive locks, innodb locking, innodb_autoinc_lock_mode, lock priority, myisam locking, write locks
This is another article in a series of articles titled "A few notes ..." in which I will be posting some important information about locking concepts, different types of locks and what locks table engines support. Just like the previous article, the purpose of this article is to highlight important aspects that you should have in the back of your mind when developing applications.
MySQL Conference Notes
Employee +0 Vote Up -0Vote Down
posted by Masood Mortazavi on Wed 15 Apr 2009 06:06 UTC
Tags:
(edit) mysql, code, Notes, Databases, community, conference, Programming, developers, users

MySQL Conference 2009 is coming around the corner, next week, in Santa Clara.

You may want to delve into the notes, as a fast way to learn about the happenings.

If you want to become an active code contributor to MySQL, the hackfest by Mark Callaghan seems interesting, and you should probably also start here and here. 

There will also be a special BoF geared to community contributors. (I still haven't been able to find out

  [Read more...]
MySQL Conference Notes
Employee +0 Vote Up -0Vote Down
posted by Masood Mortazavi on Tue 14 Apr 2009 23:06 UTC
Tags:
(edit) mysql, code, Notes, Databases, community, conference, Programming, developers, users

MySQL Conference 2009 is coming around the corner, next week, in Santa Clara.

You may want to delve into the notes, as a fast way to learn about the happenings.

If you want to become an active code contributor to MySQL, the hackfest by Mark Callaghan seems interesting, and you should probably also start here and here. 

There will also be a special BoF geared to community contributors. (I still haven't been able to find out

  [Read more...]
MySQL Conference Notes
Employee +0 Vote Up -0Vote Down
posted by Masood Mortazavi on Tue 14 Apr 2009 23:06 UTC
Tags:
(edit) mysql, code, Notes, Databases, community, conference, Programming, developers, users

MySQL Conference 2009 is coming around the corner, next week, in Santa Clara.

You may want to delve into the notes, as a fast way to learn about the happenings.

If you want to become an active code contributor to MySQL, the hackfest by Mark Callaghan seems interesting, and you should probably also start here and here. 

There will also be a special BoF geared to community contributors. (I still haven't been able to find

  [Read more...]
Security and the real world
+0 Vote Up -0Vote Down
posted by Kristian Köhntopp on Wed 26 Apr 2006 20:09 UTC
Tags:
(edit) Notes
These are the slides I have shown at my security talk (Room F at 11.50am today).

Security and the real world (PDF, 1.4 MB):


Continue reading "Security and the real world"
Serving Images from a File System
+0 Vote Up -0Vote Down
posted by Kristian Köhntopp on Tue 14 Mar 2006 11:40 UTC
Tags:
(edit) Notes
In Serving Images from a Database, Sheeri responded to me:
I appreciate your ideas, but you haven't read what I've written: "the sheer number of files is enough to kill any os."

I'm serious about that. we're talking 36 million images -- that's 36 million files (no thumbnails, they're all reduced size) plus directories to store them in. We have cacheing tuned very well, and it's still kills the OS.


Here is what I tried to simulate that:

I took my new Strato MR2. It is currently running tor, INN and MySQL. There are two HDS722516VLSA80 160 GB SATA HDDs. These disks are rated at





  [Read more...]
Serving Images From A Database
+0 Vote Up -0Vote Down
posted by Kristian Köhntopp on Fri 10 Mar 2006 20:22 UTC
Tags:
(edit) Notes
Sheeri wrote:
So, most of the “I want images in MySQL” conversations are terminated with “Don’t.”
People do say this for a reason. Here is the story of your request going through the system:
Continue reading "Serving Images From A Database"
Adventures in the Simple and the Complex
+0 Vote Up -0Vote Down
posted by Kristian Köhntopp on Wed 14 Dec 2005 20:50 UTC
Tags:
(edit) Notes
In Is MySQL simple or complex (or both)?, Mike Kruckenberg asks:
So the question is . . . What happens to the people who really just wanted a simple, no frills, easy to use database. Based on the message, MySQL is no longer the database for them. Right?


MySQL 5.0 has gained a lot of features, and some of these features such as the procedural extensions, are as often a benefit for a project as they are creating problems for a project due to feature abuse. Having more features makes the product larger and more complex as well. So, yes, 5.0 is a lot more complex than older versions, and it carries around a lot of baggage that many traditional MySQL users don't need - and yet the same features are crucial for others.

This dilemma one reason



  [Read more...]
Doing the certification dance
+0 Vote Up -0Vote Down
posted by Kristian Köhntopp on Sat 26 Nov 2005 10:26 UTC
Tags:
(edit) Notes
As reported earlier I have been taking the MySQL core and pro exams. This morning I found two letters from Denmark in my mail, wherein The Company deemed me fit and bestowed upon me the vast powers of the Certified MySQL Professional.

My certification IDs are 73899 and 74024 and the password is "public".
How much memory can a process use?
+0 Vote Up -0Vote Down
posted by Kristian Köhntopp on Thu 24 Nov 2005 14:46 UTC
Tags:
(edit) Notes
If you run the following program as a non-root user, you will see exactly how much memory a single process can allocate on your Linux system. The program is simple, it gets memory in 1MB chunks until it is shot down by the Operating System. In order to prevent overcommitment, the memory allocated is actually written to with memset().

On a Debian 2.4 smp kernel with 4 GB of RAM, it stops at 2933 MB.

(via Torsten Sievers)


Continue reading "How much memory can a process use?"
MySQL certification - the experience
+0 Vote Up -0Vote Down
posted by Kristian Köhntopp on Sun 11 Sep 2005 18:08 UTC
Tags:
(edit) Notes


This is the MySQL Certification Stude Guide, Version 4.1. It was the foundation of my preparation for the MySQL 4 Core and Pro exams I took at the MySQL Consulting Bootcamp 2005. The test results are not yet in, so I cannot tell you if it worked. :) I complemented my preperations with practical experiments and by simply reading my way through the MySQL Online Manual.

I can tell you about the Guide, and the Test, though.

Continue reading "MySQL certification - the experience"
Showing entries 1 to 11

Planet MySQL © 1995, 2013, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.