… become huge. Bug fixed #1040108 (Teemu Ollakka). Variable wsrep_defaults_file would be set up to the value in the last configuration file read. Bug fixed by keeping the value found in the top configuration file. Bug fixed #1079892…-Cluster-server and Percona-XtraDB-Cluster-client would conflict with mysql and mysql-server packages. Bug fixed #1087506 (Ignacio Nin). Other bug…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
… decided to write a series of blog posts on MySQL‘s unsolved severe limitations. I mean limitations that …Web applications, this isn’t really seen as a huge limitation. That’s because these apps are mostly …in favor of solution 2) with an option to configure it to behave as solution 1). The other big…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… behavior on errors. By default these filesystems are configured to Continue when error (such as IO error … 64bit flex_bg spars e_super large_file huge_file uninit_bg dir_nlink extra_isize Filesystem … not needed for partition you store MySQL data on, as chances are MySQL server is only one doing …
Comment: Falcon Storage Engine Design Review
January 13, 2007 By 19 Comments
… at the same time we can see that the current configurations of mysql is not good either. For example take the case… be interresting if some auto settings could be developed within mysql so we could get the best from each world… in… included mysql (my-huge.cnf etc) seems a bit outdated regarding how the memory is being used in today versions of mysql 5…
Post: Webinar: Avoiding common traps when designing a MySQL application
January 7, 2013 By 4 Comments
… you when designing and building a stable and high-performance MySQL application. I will discuss a broad range of topics, from… often see during my consulting practice wrong configuration putting data at risk or huge wastes of money to buy powerful hardware where… have done the same result. So if you think your MySQL servers are not in an optimal state, I invite you…
Post: Percona is Speaking At Open Source Data Center Conference in Nuremberg, Germany
April 19, 2012 By Leave a Comment
… by Alexey Kopytov – Expert Troubleshooting: Resolving MySQL Problems Quickly by Kenny Gryp Feel … source software in data centers and huge IT environments. The bilingual conference program …depth workshops „Open Nebula“, „IPv6“ und „Puppet Configuration Management“, taking place on the day before…
Comment: MySQL Server Variables - SQL layer or Storage Engine specific.
December 1, 2006 By 14 Comments
… need to execute mount none /mnt/hugepages -t hugetlbfs for mysql all what you need is echo 2000 > /proc/sys/vm…/nr_hugepages does not work on your box See also Configuring Huge Pages in RHEL 3/4 here: http://www.puschitz.com…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… may not be suitable for your environment. (garfield:~/work/mysql-5.0.51a) % ./configure ‘–disable-shared’ ‘–with-server-suffix=-community’ ‘–without-embedded… slow logging (see Configuration section for details). Then rename the binary, which can be safely done even with MySQL still running. This… a lot of IO bandwidth and the file may grow huge very quickly when logging all the queries. This parameter allows…
Comment: MySQL Server Variables - SQL layer or Storage Engine specific.
December 1, 2006 By 14 Comments
Vadim, I configured already a kernel to enable huge pages. I can use huge pages with a size of 2MB. I made a…-pages in the my.cnf and when I check in mysql I saw the following: show variables like ‘%large%’; +———————+———+ | Variable_name… see that mysql use this huge pages. Information about the server that I use: Linux DL585 2.6.15.1-huge-page #1…
Post: How to calculate a good InnoDB log file size
November 21, 2008 By 38 Comments
… people give you a formula for choosing a configuration setting, you should look at it with skepticism…s peak usage time: mysql> pager grep sequence PAGER set to ‘grep sequence’ mysql> show engine innodb … size is just wrong. One final note: huge buffer pools or really unusual workloads may require…
