… to be *very* quick to get your connection before the run away application does. Does this method work for other global variables…
Post: Sell-an-Elephant-to-your-Boss-HOWTO
August 28, 2012 By 3 Comments
… performance improvements are a priority and should be done right away, not at all. I want to suggest that you can… month? How many conversions are we loosing because users turn away due to slow service during registration? It may be hard… so no more than 24 such requests run in parallel. Since one customer can run 5 reports in parallel, with no overbooking…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… behavior means any UPDATE statement which is blocked by long running select will also block further selects from this table – they… our problems reside. Cache/Session tables (you can throw them away if it server crashes). You can use multiple of cache… is quick to regenerate Generally tables which you can throw away without any trouble. Tables with data you do not need…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… realtime data. The database giveth, and the database taketh away. Finally, you should think a lot about how you need…). Archive If you don’t need data anymore, move it away or get rid of it. I wrote a three… been able to avoid sharding for a long time and run on many fewer disk drives with much less memory, or…
Post: Win Free MySQL Conference Tickets!
March 14, 2012 By 3 Comments
We’re giving away three full conference passes (worth $995 each) to the Percona … to be there — and that’s why we’re giving away free tickets and books, and making it easy for you… may give your prize to someone else instead The contest runs from now (March 15th, depending on your timezone) through the…
Comment: SystemTap - DTrace for Linux ?
August 31, 2011 By 17 Comments
…. The client session will be disconnected (MySQL server has gone away) after the SystemTap script is started or terminated. test@localhost… [(none)]>select now(); ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect… Connection id: 7 Current database…:04 | +———————+ 1 row in set (0.00 sec) 2. When running the SystemTap script, command “alter table xxx truncate partition yyy…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… of openness. It also shocks people sometimes — “you’re giving away the golden goose!” Not really. What you hire us for… out. … snip … | Com_admin_commands | 255868807 | 11893 | Why is something running an admin command constantly? This is generally a Ping command… at, including checking for default users in the mysql.* tables, running mk-duplicate-key-checker to find redundant indexes, and so…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…=msandbox –mysql-password=msandbox –mysql-socket=/tmp/mysql_sandbox5516.sock run [root@localhost msb_ps_5_5_15]# time mysqldump –defaults….cnf test md_cache_test_big > /dev/null Baseline Run: When we run the tests individually Sysbench gives about 330 req/sec… configuration MySQL has buffer pool which can be easily washed away by large table scans or heavy batch jobs. If this…
Post: Living with backups
November 6, 2008 By 28 Comments
… older ones need to go away. Just imagine what happens to all the cached data during backup run when the process is…_running= 1; $is_running= 1; while(1) { if ($is_running == 0 && $was_running == 1) { kill 19, $pid; $was_running= 0; } if ($is_running == 1 && $was_running == 0) { kill 18, $pid; $was_running= 1…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
… the series of free-Percona-Live tickets we’ll give away. But first — have you ever wondered what servers are in…_only Filters Binary logging MIXED Slave status 0 seconds behind, running, no errors Slave mode IDEMPOTENT Auto-increment increment 4, offset…_only Filters Binary logging MIXED Slave status 0 seconds behind, running, no errors Slave mode IDEMPOTENT Auto-increment increment 4, offset…
