… since mysql 5.5 the statement “CHANGE MASTER TO MASTER_HOST=” ” will make an error and stop this script. As I…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
Comment: Choosing proper innodb_log_file_size
May 15, 2012 By 12 Comments
… and off-peak hours for your location. VPS and shared hosting are unreliable in that context – tuning might work superb today…
Post: Community events around Percona Live MySQL Conference and Expo 2012
March 26, 2012 By 1 Comment
… Day of the conference (April 10th) SkySQL and MariaDB are hosting SkySQL Solutions Day (April 13) which will feature keynotes by… (April 13) Finally there is a first Sphinx Search Day hosted by Sphinx Technologies (April 13) All these events are free…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… example how it can look: mysql> show processlist; +——-+——+———–+———-+———+——+————————-+—————————–+———–+—————+———–+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | Rows… to execute on the table. mysql> show processlist; +——-+——+———–+———-+————+——+——————————+——————————+———–+—————+———–+ | Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined…
Comment: Should MySQL and Web Server share the same box ?
April 23, 2012 By 9 Comments
Hello Peter, It sounds like splitting the servers for both MySQL and web, will require external help either experienced developer or assistance from hosting server to split the servers. Not something easy to do even for the good-known forum owner ?
Post: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
… offer from Box, we are creating a custom site to host the speaker slides in a central repository so the knowledge…
Post: The #1 mistake hosting providers make for MySQL servers
July 25, 2008 By 30 Comments
… you’re getting someone else to build and host your servers for you. Most hosting providers — even the big names — continue to… a pretty expensive mistake. I do not know why the hosting providers keep doing this. Just yesterday I got a quote…-class hardware these days. So it certainly looks like the hosting companies need to change what they’re doing, but maybe…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
…-query-digest output was obviously bogus when compared to the host‘s slow-query-log (for example, none of the top… and resulted in about 0.2% packet loss on this host, which is acceptable — the variances are statistically smoothed out and… to forward the tcpdump output to another host for processing because the database host couldn’t handle the additional IO or CPU…
Post: Traffic Tricks by Hosting Providers.
October 17, 2007 By 13 Comments
… my experience (which is at large extent focused on inexpensive hosting) I found it much better to work with Co-Location… 95% Commit + Overcharge payment is also fair pricing which means hosting provider is interested for me to use more traffic, not… more power buy another rack. Going forward we plan to host our consulting business web sites MySQLPerformanceBlog, Percona high quality dedicated…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
Working with number of hosting providers I always wonder how do they manage to keep … thought ? This surely would help adoption by (especially low end) Hosting Providers and remember this exactly where a lot of kids… play with web technologies. So how do the hosting providers manage to host hundreds of users on single server with single MySQL…
