so mysql 5.1 is declared ga contains enough bugs to make monty rail against it publically doesnt as far as ive been able to gather have a stable crossrelease pluggable storage engine abi despite that being a major release feature meaning you have to have new plugin releases for each mysql server release before upgrading anything and continues the ma......
[Show More]

we have now published presentations from opensqlcamp at percona presentation pages percona mysql patches is a great presentation to see percona patches for mysql in action showing how you can use them to get more understanding of your server load and improve server performance as well as how they can improve performance all together. sphinx fulltext search engine is presenta......
[Show More]

working with number of hosting providers i always wonder how do they manage to keep things up given mysql gives you so little ways to really restrict how much resources single user can consume. i have written over a year ago about 10 ways to crash or overload mysql and since that people have come to me and suggested more ways to do the same. this is huge hole in mysql design thinking little.....
[Show More]

mysql 5.1 is ga. yay a lot of new features have been added and the numbering convention of just adding a .1 doesnt really explain that. if i had of numbered it i probably would have called it 6.0. in some ways mysql has done both themselves and dbas a small injustice. while working at mysql i met a lot of customers that tended to be conservative they donrsqu......
[Show More]

mysql ab sun mysql mysql bitkeeper close source bazaar open source source code branch ......
[Show More]

i have written before myisam does not scale or it does quite well two main things stopping you is table locks and global mutex on the keycache. table locks are not the issue for read only workload and write intensive workloads can be dealt with by using with many tables but key cache mutex will still hunt you. if you aware of mysql history you may think key cache scalability was fixed......
[Show More]

our customers or prospective customers often ask us how we do a performance audit its our most popular service. i thought i should write a blog post that will both answer their question so i can just reply read all about it at this url and share our methodology with readers a little bit. this fits well with our philosophy of openness. it also shocks people someti......
[Show More]

mysql ha lanzado su nueva versian de mysql query analyzer dentro de mysql enterprise de la cual hablan muy bien en casi todos los blogs. para aquellos que usemos la versian community podemos usar una alternativa gratuita a esa herramienta. para ello debemos instalar los parches que ofrece percona los cuales entre otras cosas permiten obtener matricas desde el propio servidor. tambia......
[Show More]

i recently came across this interesting project by percona lab to provide a version of mysql with all the cool patches applied to it. it is not the latest greatest version of mysql 5.1 currently 5.1.29 but i expect they will catch up with the ga release of 5.1 which i understand is just around the corner. posted in software developmen t......
[Show More]

the mysql database server can display a lot of performance statistics. however most of them relate to general server parameters such as buffer sizes and query cache settings. of course such settings are important to get right and can make a huge difference in performance. once youve tuned them however you need to start looking at the tables and queries. when a single bad query can cost ......
[Show More]

we made new binaries for mysql 5.0.67 build 7 which include patches we recently announced . the percona release includes plain text code innodb che ck defrag. patch session status to check fragmentation of the last innodb scan 1.0 percona gpl the names are innodb scan ......
[Show More]

do you know that there are two limits about dirty modified but not flushed to disk blocks of innodb buffer pool one is the limit of amo unt . the other is the limit of age. limit of amo unt as you know buffer pool of innodb works as writeback cache of its datafiles. if the buffer pool is filled by dirty blocks innodb cannot......
[Show More]

as you likely have seen sun has posted the new specjappserver results more information from tom daly can be found here these results are quite interesting for me as i worked on some of the previous specjappserver benchmarks several years ago while being employed by mysql. these are great results plus they can be relevant to a lot of us because commodity x86 based hardware was used fo....
[Show More]

we have finally found the time to update out presentation pages weve added the presentation on mysql scaling by sharding and replication as well as russian language presentations ive given at highload conference back in october. innodb scalability and new features russian scaling mysqlpowered web sites by sharding and replication russian won......
[Show More]

...roredbinlogs and fastmasterpromotion patches as second provides feature to make slave as master in case of main master failure. at this moment you can download patch by itself there httpwww .percona.c ommysql5 .0.67b6p atchesmir ror binlog .patch with docs on our wiki also the patch will be included in ourdelta binaries beside our releases for centos redhat platform so you can ...
[Show More]

there is patch from google to improve smp performance but for some workloads it showed for us reverse scalability. e.g. update key benchmark from sysbench. there are also results with yasufumis rw locks httpbug s.mysql.co mbug.php id26442 threads standard innodb google smpfix yasufumi rw lock 1 9700.28 10601.96 9432.44 2 14355.66 16673.3......
[Show More]

perconas patches are now available to a wider audience via ourdelta a community effort to provide builds with features percona patches google patches etc and storage engines pbxt sphinx etc that arent in the main mysql server. arjen lentz is really the brainchild behind this. kudos arjen what does this mean for the percona patches well now......
[Show More]

so many engines and so little to choose from. this is one of our two major decision points in drizzle right now. let me explain. today we have innodb maria falcon and pbxt . simple not really. innodb is not a single engine it is three engines. we have the default one which is shipped. it has been the wunderkinder for years now but has been showing its age. go buy a piece of hard......
[Show More]

database performance is one of the major bottlenecks for most web applications. most web developers are not database experts and im no exception there are however several basic methods to analyze and optimize database performance without resorting to expert consultants such as those whose founders blogs are an invaluable source of mysql knowledge. the performa......
[Show More]

i guess many of you know us and so our company for mysql related services. it is true this is majority of our business at this point but it is far from everything. our goal in reality is to help people to build and operate quality systems typically web sites which means we help customers with performance scalability high availability as the whole not just mysql related issues. indeed......
[Show More]

the trouble with slave lag is that you often cant see it coming. especially if the slaves load is pretty uniform a slave thats at 90 of its capacity to keep up with the master can be indistinguishable from one thats at 5 of its capacity. so how can you tell when your slave is nearing its capacity to keep up with the master here are three ways one wat......
[Show More]

ever wonder what is stored in innodb buffer pool at the moment it is not so hard actually we made a short patch for mysql 5.0 which show innodb buffer pool content plain text sql mysql select from informatio n schema.i nnodb buff er pool co ntent .. ....
[Show More]

Similar post was found from:
www.revenuesource.com

...on. set global log slow f ilterqu ot then it was just a question of examining the slow query log and fixing the queries. more information about the patches is available here httpwww .percona.c ompercona lab.html entry posted by ewen one comment add to ......
[Show More]

i havent posted any update in 2 months not because i havent been doing anything but rather the opposite i have been exceptionally busy. as baron has noted i work with percona doing the maintenance and development for maatkit of which release 2325 was just published. consequently i havent been working on my own scripts though hopefully that will change and in some w......
[Show More]