… in parallel Example : I have a client at my DB/Web hosting company with 650+ databases (450+ GB) in one mysql instance… individual tables (which I have also scripted for other DB Hosting clients) Option 2 (not using mysqldump) MAATKIT’s very own…
Comment: Wishes for new "Pure PHP" MySQL driver
September 15, 2010 By 17 Comments
… for people using shared web hosting! I managed to compile a local php5.3 cgi on a shared host recently and got it…
Comment: MySQL for Hosting Providers - how do they manage ?
February 12, 2009 By 15 Comments
I was with host monster but they kicked us off because our mysql queries were too long. Do you know of a web hosting place where we can have longer queries
Comment: MySQL for Hosting Providers - how do they manage ?
December 1, 2008 By 15 Comments
One web hosting company that I host with (NearlyFreeSpeech.NET) gives a private instance of MySQL server to each customers (listening on standard port on a private IP address). It provides much better isolation than everyone shares the same MySQL process.
Comment: How expensive is USER_STATISTICS?
June 4, 2012 By 14 Comments
I’d check if it scales as well when you have lots of users and lots of databases, each getting little load (shared web hosting use-case, dedicated MySQL servers there often end up serving tens of thousands users/DBs). If it does, enabling it by default seems to be a safe thing to do.
Comment: Server Outages at Percona
July 21, 2011 By 12 Comments
… applicable lessons learnt would be great to read about. My web host had a raid controller failure but they used R1Soft CDP…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… table on 0% yes, 99% no # String: # Databases prod_db # Hosts localhost # InnoDB trxID 1153145C (2/0%), 11531626 (2/0%)… 43…
Comment: Impossible - possible, moving InnoDB tables between servers
March 20, 2010 By 9 Comments
… Hybrid Logic Ltd. www.hybrid-cluster.com – Next-generation cloud web hosting
Comment: Opening Tables scalability
December 6, 2006 By 27 Comments
… the problems ? Or are you speaking about special case of web hosting then there would be 32000 users created for each database…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 30 Comments
… idea why this would happen ? I see if frequently with web applications and it is often indication of trouble. Not only… info. You my notice in the “Host” filed of SHOW PROCESSLIST output not only host but also port is specified, showing you… same host, which if usually bad idea) and connection to some external web server. You can use strace -p to see what host…
