You searched for how to imlement condition in my_sql

June 20, 2013

Post: What technologies are you running alongside MySQL?

June 19, 2013 By Peter Zaitsev 3 Comments

… environments MySQL is not the only technology used to store in-process data. Quite frequently, especially with large-scale or complicated … and processing do you use alongside MySQL in your environment? Please feel free to elaborate in the comments about your use case and…

Filed Under: MySQL, Polls Tagged With: Cassandra, CouchBase, Hadoop, Hbase, Inhouse Developed Technology, Lucene, Memcached, MongoDB, MySQL, Redis, RethinkDB, Riak, Sphinx, Tarantool

Comment: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)

June 19, 2013 By Ernie Souhrada 12 Comments

Hm, yeah, I just tried it on my F18 system (kernel 3.9) and got the same error. Apparently this is a 2.6.x hack only, or maybe there is some other workaround for newer kernel versions that I’m not aware of.

Filed Under: Insight for DBAs, MySQL Tagged With: 90-nproc.conf, Errno 11, Ulimits

Post: MySQL Webinar: Percona XtraDB Cluster Operations, June 26

June 18, 2013 By Jay Janssen Leave a Comment

…, but we’re starting to reach a threshold where it’s easier to find folks with PXC in production and such the need… some key questions/issues/pain-points for those with PXC in production already. As such, I’m giving a webinar entitled… Flow Control What and How to Monitor Tuning best practices This webinar is not meant to necessarily be exhaustive, but to cover key topics…

Filed Under: Events and Announcements, Percona XtraDB Cluster Tagged With: Backups from the cluster, flow control, Jay Janssen, Percona XtraDB Cluster, SST, Tuning best practices, webinar

Post: Call for papers: Percona Live London

June 14, 2013 By Tom Diederich Leave a Comment

… Percona Live MySQL Conference and Expo in Santa Clara, you know it was a rare opportunity to learn from some of the most accomplished system architects and developers in the business. Now it’s time to give back. The call for papers (CFP… internals or explain how specific features work in depth. These stories are gold! And you owe it to the MySQL community to share them…

Filed Under: MySQL, Percona Live Tagged With: Percona Live London

Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!

June 17, 2013 By Raghavendra Leave a Comment

… the node information – IP address or hostname – should be known in advance (the node itself needn’t be up), which may… to manage this with a small team. That strongly implies scalability of resources – you scale more with less, and that is how it should be. We would like to hear from you about your architectural setup…

Filed Under: MySQL, Percona XtraDB Cluster, XtraDB Cluster Tagged With: galera, haproxy, HP Cloud DNS, Patrick Galbraith, pxc, synchronous replication setup, xtrabackup, Xtrabackup SST, XtraDB Cluster

Comment: How to calculate a good InnoDB log file size

June 14, 2013 By Baron 38 Comments

According to this link, https://mariadb.atlassian.net/browse/MDEV-4662 Jesper is correct and I am wrong: when InnoDB warns about not enough space in the logs, it’s overwritten its last checkpoint. Thanks to Jeremy Cole for finding out the truth.

Filed Under: Insight for DBAs Tagged With: InnoDB, Tuning

Comment: Sphinx search performance optimization: attribute-based filters

June 13, 2013 By Aurimas Mikalauskas 11 Comments

Fabian, – please note that, as stated in the article, this technique only works well for highly selective … 10 groups per 10M records), then you don’t want to use this. Please see “Highly selective columns only” section for…

Filed Under: Insight for Developers, MySQL Tagged With: FullText Search, Sphinx, Tips