|
Several months ago I wrote about logs on demand in MySQL 5.1. Now that 5.1 is approaching its maturity stage, I am happy to report that this feature has proven itself very handy and useful. Petr Chardin will talk about this very feature at the MySQL Conference and Expo. |
While reviewing the material for this session, I remembered a
usability report that I wrote when the feature
was …
I have just released PrimeBase XT 0.9.86 which will be my last
release before the MySQL User Conference this year. The most
significant change in this version is the reduction of the number
of data logs used per table. This, and a number of other
modifications, makes PBXT fit to handle databases with 1000's of
tables.
If you would like to learn more about the development and design
of PBXT then join me for my session at the MySQL User Conference
in Santa Clara, on Wed, April 25, 10:45am - 11:45am, Ballroom
F:
PrimeBase XT: Design and Implementation of a
Transactional Storage Engine
Looking ahead, I would also like to invite all who are interested
to the "Scalable BLOB Streaming Infrastructure" BoF,
which is scheduled for …
LJ ate part of the post, so I am updating it with the original
content.
I've not been posting a lot about my studies on bottlenecks in
the
server and my work on what I am seeing with different engines,
but I
thought I would comment on Peter's benchmarks on PBXT:
http://www.mysqlperformanceblog.com/2007/04/08/pbxt-benchmarks/
This is a bit off what I have found so far:
In all tests but the final, the task …
Today while waiting at the airport, I took a look at the news stand, and right there on the cover of Fast Company were two words Google, and Wikipedia. Given Wikipedia is a poster boy of MySQL it was an immediate purchase just to see what was being said.
So the title of the cover was Google’s worse nightmare - Wikipedia’s Jimmy Wales has his sights set on the search business.
Now, often I use Wikipedia to search for things directly rather then using Google. I’ve found it usually to be more accurate, particular on topics I know it will contain. References to search users being disappointed, Google and Yahoo tied with a 2.3 of 5 in user satisfaction hits about home for me as week, and that’s exactly the ideas …
[Read more]
Direct play this episode at:
http://tinyurl.com/2guzuk
Download all episodes at:
http://technocation.org/podcasts/oursql/
Subscribe to the podcast at:
http://feeds.feedburner.com/oursql
News:
MySQL signs a 1 million Euro deal with an unnamed European
Telco.
http://www.pythian.com/blogs/408/mysql-inks-1m-deal-anyone-know-more-details
MySQL 5.0.37 is out ? it’s an odd release, so it’s a community
release, and it’s a full release with binaries and source. This
release isa big milestone, as it includes the first patches
submitted by the MySQL Community.
…
Today I was doing some pre-release testing of our software and to test it I was needed three separate servers running MySQL. After some thinking I decided to use my “old” workstation (actually it is pretty powerful Sempron with 2Gb of RAM, but now I use my macbook as a primary workstation) and start 3 separate virtual servers there. Of course, as all admins, I’m little bit lazy and installing Debian on all three machines was not appropriate solution ;-). So, I’ve created one machine, installed brand-new Debian Etch there and then begun to look for solution to clone this machine to run it in three copies. After all these operations were done, I’ve decided to spend time I’ve saved with this simple trick to describe here how to clone VmWare …
[Read more]I've been preparing for my innotop session at the upcoming MySQL conference, and enlisted Giuseppe Maxia's MySQL Sandbox to help me get a bunch of MySQL servers, from 3.23.58 to 5.2.3, running on one machine. It was super-easy and has helped me find some bugs in innotop. I should have done this a long time ago.
The PBXT Storage Engine (http://www.primebase.com/xt/) is getting
stable and we decided to benchmark it in different
workloads.
This time I tested only READ queries, similar to ones in
benchmark InnoDB vs MyISAM vs Falcon
(http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1)
The difference is I used new sysbench with Lua scripting
language, so all queries were scripted for sysbench.
New sysbench you can get from svn repository:
PLAIN TEXT CODE:
The used LUA script for sysbench
…
By Tim O'Reilly
Paul Tuckfield of YouTube has just joined the keynote lineup at the MySQL User Conference, which will be held April 23-26 at the Santa Clara Convention Center. Paul will be talking about Scaling MySQL at YouTube. Every web 2.0 company is ultimately a database company. Some roll their own, a few, a very few, use proprietary commercial databases. Most are running on MySQL. Given the rapid scaling that YouTube has enjoyed, I'm sure Paul will have a lot of useful advice for other up-and-coming sites. Paul's keynote is part of a general focus on scalability at the conference -- there's an entire track on performance tuning and benchmarks, and another on …
[Read more]As I write this blog I have over 90 draft blog posts. That’s 9-0. Why do I have so many posts? The main reason is I want to say something, and I’ve either not completed it, or researched it sufficiently to consider the entry complete.
This frustrates me as sometimes I just want to get the word out on something, or of my opinion, or of something great I’ve discovered. I do it for me, I don’t really care if anybody actually reads my stuff, but I’m surprised sometimes when I get comments how people actually get to see my blog.
JotThat is a surprisingly simple yet brilliant idea. It’s quite simply a site for making Jots, making quick notes, making a passing comment, noting a thought, something you want to either remember or something you want to say in a simple Jot form.
What makes JotThat in my eyes? Well it’s simple, …
[Read more]