When I say volume partition, I'm referring to how to separate the
different structure of your MySQL components to different
volumes. For a newbie, it is so easy to just install MySQL using
its default configuration. This means that your binary logs
(assuming you are using it) will be in the same volume as your
data files.
There is nothing wrong with this if you have a small database,
but once your database grows, you will see an impact of what you
did. What you sow, is what you reap. Let me explain this further,
remember that binary logs needs to be written to the hard disk
and the same goes for the data files. Imagine if there are two
processes writing to your hard disk at the same time, what would
happen? Setting aside the technological jargon, it will take
longer to perform the necessary action.
This is the reason why you have to be careful in partitioning
your MySQL into different volumes. Make sure that the binary …
The latest from the MySQL community
Ideas, releases, practical guides, and perspectives from the people building with MySQL.
In this article, we discuss the XML functionality available in MySQL, with an emphasis on new features coming online in MySQL 5.1 and MySQL 6.0. We assume that you already have a working knowledge of XML, and that you know what the terms ?valid? and ?well-formed? mean. We also assume that you have some knowledge of XPath.
So we're back from the company meeting which took place last week
in Hurghada, Egypt. It was a great opportunity to meet a lot of
people for the first time in person to work together and have
some fun.
Because of charter flight schedule this was rather long meeting - we had whole week in the Egypt in 5 star all inclusive resort (FYI: It is nowhere near European/American 5 stars in terms of quality or price). We had work sessions for 4.5 days, One day we took full day excursion to Luxor and another half a day we took introductionary diving and snorkeling tour. Some of us having late plane departure got almost another day to relax on the beach.
If you're wondering about budget we tried to keep it at just over 1000$ per person which varied a bit depending on cost of travel, such as travel from Krakow or Novosibirsk was surely expensive than from Kiev and Moscow.
Being visitor on plenty of conferences and now …
[Read more]
On December 13 (it means today for most of the readers) at 15:00
CET (14:00 UTC), the MySQL University lecture on Lua will start.
The topic is quite extensive. Even though the lecture is limited
to using Lua with MySQL Proxy, yet there is a lot of ground to
cover. During a rehearsal session last week, I realized that the
whole matter would need much more than one hour if I describe in
detail all the introductory material that I originally
planned.
So I will reduce the time dedicated to MySQL Proxy architecture,
which you can look on your own by reading Getting started with MySQL Proxy. I will cover
this matter only briefly during the lecture, so if you know some
background, you’ll enjoy the lecture even more.
If you are new to MySQL University lessons, …
[Read more]The Pythian family got a new song last Monday — “Sheeri” means “my song” in Hebrew. This post on my own blog explains how I got the job. High winds delayed my flight last Monday, and we’ve had two snow storms since I arrived. Luckily, my real-life context switch has not been too difficult. [...]
MySQL’s manual page for InnoDB’s adaptive hash states: If a table fits almost entirely in main memory, the fastest way to perform queries on it is to use hash indexes. InnoDB has a mechanism that monitors index searches made to the indexes defined for a table. If InnoDB notices that queries could benefit building a [...]
The last article demonstrated that a denormalized data model was a bit faster than a normalized data model when all the data fit into memory, but only by 20-30 percent or so, at least for the experiments I ran. This article deals with larger data volumes and shows a case where normalized data is faster than denormalized data and then details another case where a denormalized data model faster.
First, this is the what the tables in question look like. All the product tables have 10 million rows. The denormalized ProductAll table is 5.2 gig, and as innodb_buffer_pool_size is set to 4 gig, this table won't fit into memory. The filler column represents other product attributes without having to specify them in detail.
create table ProductAll (
productAllId int(11) not null,
productAllName varchar(32) not null,
…
Ruby on Rails 2.0 was released last week, “It’s done!“, David Heinemeier Hansson notes.
Ruby on Rails has come a long way since Lenz Grimmer’s interview with DHH in February 2006.
Browsing DHH’s blog, I find snippets (bolding mine) like
Piggy-backing off the new drive for resources are a number of simplifications for controller and view methods that deal with URLs.
As you might have gathered, Action Pack in Rails 2.0 is all about getting closer with HTTP and all its glory.
We?ve also made it much easier to structure your JavaScript and stylesheet files in logical units without getting clobbered by the HTTP overhead of requesting a …
[Read more]Cleversafe obtains new round of funding. Sun releases OpenSPARC T2 processor design. IT Mill open sources RIA development tools. (and more)
Former Motorola CEO Christopher Galvin Leads Cleversafe’s Series C Round, Joins Board of Directors, Cleversafe (Press Release)
Sun Accelerates Growth of UltraSPARC CMT Eco System; Releases OpenSPARC T2 Processor RTL to Open Source Community and Joins Five Major Universities in Launch of OpenSPARC Technology Centers of Excellence, Sun Microsystems (Press Release)
IT Mill Integrates Google Web Toolkit (GWT) And Open-Sources Its RIA Development Tools, IT Mill …
[Read more]The folks over at zmanda who specialize in MySQL backup are doing a webinar on December 13th, this Thursday. They specifically mention it as relevant for Oracle DBAs or anyone moving to MySQL. Looks to be an interesting event.