… Percona-Server-shared-compat package naming issue that could lead to unresolved …, where an unprivileged MySQL account owner could perform brute-force password guessing …64-bit unsigned integers now. Bug fixed #714925. mysql_set_permission was failing on Debian due to missing libdbd-mysql…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/… the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699…64-bit unsigned integers now. Bug fixed #714925. Server would crash if an INNODB_CHANGED_PAGES query is issued…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…MySQL 5.5 MySQL uses asynchronous IO which should allow it to load IO subsystem very effectively being able to issue…35-generic Architecture | CPU = 64-bit, OS = 64-bit Threading | NPTL 2.15 …performance should be better as it has less overhead with double buffering as well as more information MySQL…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition… /usr/libexec/mysqld is a 64-bit build, if I’m on a 64-bit OS. Examining MySQL configuration Then I’ll …make sure that we refer back to the previous issue‘s findings, so that we don’t duplicate …
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
…MySQL Also was very slow running some queries so we changed scripts a bit…MySQL 6.0 performance will improve. Though considering a lot of talks about optimizer improvements in MySQL…MySQL to use CPUs and hard drives this system has more efficiently. Parallel query will be growing issue for MySQL…,32,64…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
…from the system. What I usually look for MySQL is performance in random reads and random writes. …code path in kernel and so has a bit different performance pattern compared to buffered IO (even …64 threads are waiting for IO. Now lest see our write test which seems to have some serialization issues…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
…as memory). With MySQL common sense however does not always works – we’ve seen performance issues with large … option is used. With default table_cache=64 accessing all tables take 12 sec which…bit worse than MySQL 5.0.85. So the problem is not fixed in MySQL 5.1, lets see how MySQL 5.4 behaves. MySQL…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…can get 8 core x86-64 box with 32G with good price/performance value while if you would…past certain hardware configuration – some of these issues may be MySQL related and others (like excessive row level …would just need another server a bit later. However if you have 100 MySQL servers to deal with …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…: A query thread normally posts about 64 page read requests per a readahead…which can help performance (keeping data smaller) or can a bit slow it down…series. Also note the “Auto Increment Issue” is finally solved in 5….of us are using MySQL because it seems to offer the neccessary performance. Are we…
