Well, the first summary of last 10 variable day outs.
Day Outs:
- Day Out #1: delay_key_write
- Day Out #2: key_buffer_size
- Day Out #3: max_connect_errors
- Day Out #4: innodb_buffer_pool_size
- Day Out #5: innodb_thread_concurrency
- Day Out #6: …
May
13
2008
May
13
2008
If you’re an advanced MySQL person, you might already know these,
in which case, please read anyway, because I still have some
questions. On the other hand, f you’re someone who launched an
application without a lot of database background, thinking “MySQL
Just Works”, you’ll eventually figure out that it doesn’t, and in
that case, maybe these tips will be of some use. Note that I’m
speaking specifically about InnoDB and MyISAM, since this is
where most of my experience is. Feel free to add more to this
content in the comment area.
InnoDB vs. MyISAM
Which one to use really depends on the application, how you’re deploying MySQL, your plans for growth, and several other things. The very high-level general rule you’ll see touted on the internet is “lots of reads, use MyISAM; lots of writes, use InnoDB”, but this is really an oversimplification. Know your application, and know your data. If all of …
[Read more]
May
13
2008
Oursql-conferences is a discussion list
for a community conf, not to compete with but augmenting the
Sun/MySQL one. We're here to discuss such an event, its
potential, dates/location, and get it going!
It's a public group, please blog & tell others about it!
Sheeri suggested OurSQL, like her podcast.
Members: 91
Discussions:
Conference Outline
By Eric Day - May 6 - 4 authors - 5 replies
Would a Virtual Conference Work?
By Sheeri K. Cabral - Apr 29 - 7 authors - 11 replies
How about a community build?
By Arjen Lentz - Apr 27 - 6 authors - 6 replies
Creation of oursql-sources Group
By Mark Schoonover - Apr 25 - 1 author - 0 replies
What about MySQL Camp?
By Keith Murphy - Apr 25 - 2 …
May
13
2008
Oursql-conferences is a discussion list
for a community conf, not to compete with but augmenting the
Sun/MySQL one. We're here to discuss such an event, its
potential, dates/location, and get it going!
It's a public group, please blog & tell others about it!
Sheeri suggested OurSQL, like her podcast.
Members: 91
Discussions:
Conference Outline
By Eric Day - May 6 - 4 authors - 5 replies
Would a Virtual Conference Work?
By Sheeri K. Cabral - Apr 29 - 7 authors - 11 replies
How about a community build?
By Arjen Lentz - Apr 27 - 6 authors - 6 replies
Creation of oursql-sources Group
By Mark Schoonover - Apr 25 - 1 author - 0 replies
What about MySQL Camp?
By Keith Murphy - Apr 25 - 2 …
May
13
2008
Oursql-sources email group was created to
discuss community MySQL builds, patches and adding features using
the GPL'd version of MySQL sourcecode.
Members: 27
Discussions:
The MySQL
CLA - A barrier to community contributions?
Source trees, Public Development and Builds
- Version control, community contributions.
-- MarkMySQL DBA & Programming Blog by Mark Schoonover
May
13
2008
Oursql-sources email group was created to
discuss community MySQL builds, patches and adding features using
the GPL'd version of MySQL sourcecode.
Members: 27
Discussions:
The MySQL
CLA - A barrier to community contributions?
Source trees, Public Development and Builds
- Version control, community contributions.
-- MarkMySQL DBA & Programming Blog by Mark Schoonover
May
13
2008
Ask any DBA what are his top priorities for backup of MySQL. Chances are that hot backup and recovery to a specific point-in-time (or transaction) will be on top of everybody?s list.
The recovery to any point-in-time has been always an ultimate goal for data protection. Traditional backup solutions allow recovering only to a point in time when the last backup took place, e.g. last night. A lot of new data could be created and lost since that last backup. That is why in the last several years many vendors have been working on Continuous Data Protection (CDP).
Storage Networking Industry Association (SNIA) defines Continuous Data Protection (CDP) as “a class of mechanisms that continuously capture or track data modifications enabling recovery to previous points in time”.
…[Read more]
May
12
2008
I need to generate large (1TB-3TB) synthetic MySQL datasets for
testing, with a number of requirements:
a) custom output formatting (SQL, CSV, fixed-len row, etc)
b) referential integrity support (ie, child tables should
reference PK values, no orphans,etc)
c) able to generate multiple tables in parallel
d) preferably able to operate without a GUI and/or manual
intervention
e) uses a well defined templating construct for data
generation
f) preferably open source
Does anyone out there know of a product that meets at least most
of these requirements?
*edit*
I found a PHP based data generation script (www.generatedata.com)
that is extensible in its output formatting, so it should do
everything I need it to do.
May
12
2008
I just left a meeting with a large enterprise that dumped Microsoft Sharepoint for Alfresco for content management and collaboration. While that makes me smile, the thing that I loved hearing most from the vice president of IT was her general thoughts on open source, and why it's getting more play within this media company, including Alfresco, MySQL, Liferay, and more:
The culture here is about freedom and the ability to impact things ourselves. We're adopting more and more open source because we want to be in control of our own destiny....
In some cases, open source has meant higher implementation costs upfront but lower costs over the long run.
There is a resistance here to being framed into a long-term proprietary path: Closed APIs, closed standards, and closed source force us onto a vendor's licensing treadmill - we don't want that. We want flexibility and choice. We think about IT for the long run.
Music to …
[Read more]
May
12
2008
Jonathan Schwartz of Sun, and Giuseppi Maxia of
MySQL
Originally uploaded by FallenPegasusAccording to my Flickr stats, this
picture just got a huge surge of views, most of them from
"fakesteve.blogspot.com".
But when I go to that blog, I can't find the link.
Can anyone find it for me?