… GET_LOCK function in MySQL. The second one is good if you want to serialize jobs from multiple servers (for example you… limit concurrency for certain processes – like if you have 50 web servers which run certain cron jobs, but you do not want… avoid hundreds of cron error messages when you restart database server etc but information about cron errors should find you. Store…
Post: MySQL Stored Procedures problems and use practices
June 12, 2007 By 21 Comments
… helper Debug Storage Procedure which will log some information in MySQL table but it is not convenient enough. Bad Parser Error… also loading CPU on your Database Server, which is typically more expensive to scale than Application/Web Servers. It is OK however to… result set back to the client as in this case server may need to do more work to send it back…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… update MySQL the same date as release would hit the web. Since that time I matured and so did MySQL ecosystem. MySQL is powering… estimate more people running on MySQL or Percona Server 5.1 than 5.5 Facebook also sticks with MySQL 5.1 even though their highly patched and improved version. MySQL…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
If you’re following MySQL or PHP landscape you should have seen announcement by MySQL to develop pure PHP driver. If not… memcached hooked up to it to share result sets among web servers for result sets which can be a bit stale. This… for multiple MySQL connections at once. For scale out applications data to generate the page may be on many different servers and…
Post: Scalr and MNPP
April 28, 2011 By Leave a Comment
… development environment for PHP and MySQL you can check out MNPP which also includes lightweight Ngnix web server instead of Apache. Now about any Open Source projects including or based on Percona Server or Xtrabackup ? Let…
Post: Upcoming Webinar "Managing Big Data with Percona Server, XtraBackup and Tungsten"
February 2, 2011 By 3 Comments
… will be giving a webinar “Managing Big Data with Percona Server, XtraBackup and Tungsten”. This is joint Continuent and Percona Webinar… SaaS businesses and large web applications. In this webinar, we’ll teach you how to set up Percona Server, XtraBackup, and Tungsten…
Post: Schedule for MySQL Conference 2012 is Published
January 25, 2012 By 3 Comments
…. We have talks about running MySQL on extremely large scale in a Web as well as running MySQL In the Enterprise Environments. Some… working on MySQL Code. We have many talks which are covering Oracle MySQL, and forks such as MariaDB, Drizzle and Percona Server are well covered too. You will also have a chance to learn about commercial MySQL alternatives such as…
Post: CentOS Comes with free build of MySQL Enterprise ?
January 4, 2008 By 10 Comments
… this writing you could only get binaries for MySQL Community 5.0.45 from MySQL Download Pages which was released in July… mysql-devel.x86_64 5.0.54-1.el4.centos centosplus mysql-libs.x86_64 5.0.54-1.el4.centos centosplus mysql-server… not built exactly same as ones you would download on MySQL Web site, ie BDB may be enabled by default but in…
Post: MySQL Performance Blog was down today
November 21, 2009 By 3 Comments
MySQL Performance Blog (and percona.com too) were down today because … of calls and messages from the customers and friends about web site going down so we probably have to invest into… redundant – currently we were quite cheap and a lot of servers have single network card (so you can’t use trunking…
Comment: Why do you need many apache children ?
February 17, 2008 By 15 Comments
… load of db server, web server thanks to this article. Timeout setting in httpd.conf do great harm to so many mysql connections in… served from our web server, so there are many child processes even if actual traffic is not overloaded. So mysql connection opened in… dedicated web server when concurrent apache connection reaches to 100 at peak time. Their daily page views handled by single php web server is…
