Posted by Vadim |
I’ve seen my posts on Ontime Air traffic and Star Schema Benchmark got a lot of interest
(links:
).
However benchmarks by itself did not cover all cases I would want, so I was thinking about better scenario. The biggest problem is to get real big enough dataset, and I thank to Bradley C. Kuszmaul, he pointed me on Wikipedia statistics on access to Wikipedia pages, and thank to Domas, who made stats accessible. Link to the archives: http://dammit.lt/wikistats/archive/ or the original Domas’s announcement .
[read more...]
Posted by fernando |
Percona is hiring. As part of our growth process, we introduced the role of the Shift Support Captain in 2009
(see the original announcement here) to
provide customers with a 24×7 technical contact person.
The Shift Support Team dispatches incoming emergencies, assigns new issues, handles or escalates incoming Nagios alerts from some customers, and in general makes sure things get handled
and customers get the attention they need.
You must be detail oriented, service oriented, tech savvy and as all Percona staff, able to work from home with little supervision. This is a growth position, so we’re also looking for people who can become
consultants with time.
The basic requirements are:
- Excellent written and spoken English.
- Knowledge of MySQL and InnoDB.
- Knowledge of Linux systems administration.
- Knowledge of popular LAMP technologies such as Apache.
- General programming and scripting abilities.
- Proven success working in a distributed environment where
e-mail, IRC and voice calls are the only interaction with
clients, colleagues and managers on a daily basis.
Work is scheduled in 8-hour shifts, and some weekend shifts will be required.
Some of the benefits of working for Percona include good pay and benefits, working from home, with a team of experts who work on challenging projects everyday and who develop/contribute to many cool projects
Some travel is required, at least for a yearly company meeting, and for some conferences and other events.
If you think you’re a good candidate, please fill out the contact form on our website. Thanks!
Posted by
fernando @ 7:31 am ::
percona ::
Posted by Morgan Tocker |
February and March as busy months for Community events. There’s MySQL University, Fosdem, the Seattle MySQL Meetup & Confoo.ca. [read more...]
Posted by Morgan Tocker |
A while back Friendfeed posted a blog post explaining how they changed from storing data in MySQL columns to serializing data and just storing it inside TEXT/BLOB columns. It seems that since then, the technique has gotten more popular with Ruby gems now around to do this for you automatically. [read more...]
Posted by
Morgan Tocker @ 2:39 pm ::
mysql,
tips ::
Posted by Vadim |
We recently released XtraDB-9, and while we did not highlight it in announcement, the release-making feature is ability to save and restore InnoDB buffer pool.
The idea is not new and was originally developed by Jeremy Cole (sorry, I do not have the link on hands) some time ago, and now we implemented it in XtraDB.
Why would we need to save and restore content of buffer pool ?
There are several reasons.
First, it’s not rate on modern servers to have 32GB+ of RAM, with allocated InnoDB buffer_pool 26GB or more. When you do restart of server, it may take long time to populate cache with useful data before you can bring it back to serve production load. It’s not rare to see
maintenance cycle takes two or more hours, mainly because the slave need to catchup with master and to warm cache.
In case with the server crash, it is even worse, you need to wait possible long time on InnoDB
recovery (we have the patch for that too, in that post you can see InnoDB recovery took 1h to accomplish) and after that warm caches.
Second, it is useful for some HA schemas, like DRBD, when, in case of failover, you need to start passive instance on cold.
[read more...]
Posted by peter |
So you get MySQL or other applications using too much memory on the box or OS behaving funny and using more memory for cache and pushing application to the swap. This causes swapping and causes performance problems. This much is obvious. But how bad is it ? Should you count it same as normal Disk IO as the box is having or is it worse than that ?
[read more...]
Posted by Vadim |
I appreciate opportunity Jos van Dongen from Tholis Consulting gave me. He granted me access to servers with 8 attached Intel X-25M 80GB MLC cards. The cards attached to 2 Adaptec 5805 raid controllers, with 4 cards per controller.
The cost of setup is 8 x 260$ (X-25M) + 2×500$ (Adaptec 5805) = ~3000$.
Available space varies in depends on raid setup from 300GB to 600GB.
The logical comparison is to compare results with FusionIO 320GB MLC card, so I will copy results from FusionIO 320GB MLC benchmarks.
[read more...]
Posted by peter |
I generally thought about MySQL replication as being quite low overhead on Master, depending on number of Slaves. What kind of load extra Slave causes ? Well it just gets a copy of binary log streamed to it. All slaves typically get few last events in binary log so it is in cash. In most cases having some 10 slaves are relatively low overhead not impacting master performance a lot. I however ran into the case when performance was significantly impacted by going from 2 to 4 slave on the box. Why ?
[read more...]
Posted by Morgan Tocker |
After a nice long vacation, it’s time to unveil our destinations for public classes in 2010. We are now offering a course for Developers as well as DBAs. The dates are:
Do you run a meetup group in one of the cities listed? Get in touch! I would be happy to come along and give a presentation, or just answer your MySQL questions over a dinner or beer. You can reach me via @percona or email.
Posted by Aleksandr Kuzminsky |
Dear Community,
As of today Release 9 of XtraDB storage engine is available.
The release includes following new features:
- The release is base on 1.0.6 version of InnoDB plugin.
- MySQL 5.1.42 as a base release
- Separate purge thread and LRU dump is implemented (this feature was actually added in Release 8, but somehow it was forgotten)
- New patch innodb_relax_table_creation
- Added extended statistics to slow log
- Adjust defaults with performance intention
- Added parameter to control checkpoint age
- Added recovery statistics output when crash recovery (disabled by default)
- Patch to dump and restore innodb_buffer_pool
Fixed bugs:
- Bug#488315:
rename columns and add unique index cause serious inconsistent with mysqld
- Bug #495342: “MySQL 5.1.41 + InnoDB 1.0.6 + XtraDB patches extensions-1.0.6, rev. 127 fails to compile on OpenSolaris”
- Bug #47621: change the fix of http://bugs.mysql.com/47621 more reasonable
The builds for RedHat 4, 5 , Debian and Ubuntu are located on http://www.percona.com/mysql/xtradb/5.1.42-9/ . Since Release 9 .tar.gz packages are available for FreeBSD.
There is an RPM Percona-release. It installs Percona.repo to /etc/yum.repos.d/ and the public key which we use to sign RPMs. The copy of the key is located on our web-site.
Once you install Percona-release repo the upgrade becomes as easy as
CODE:
-
yum update MySQL-server-percona MySQL-client-percona
The latest source code of XtraDB, including development branch you can find on LaunchPAD.
Please report any bugs found on Bugs in Percona XtraDB Storage Engine for MySQL.
For general questions use our Pecona-discussions group, and for development question Percona-dev group.
For support, commercial and sponsorship inquiries contact Percona
del.icio.us
digg