…count = count + 1 where achievement = ‘killed_troll’; How many players might accomplish this achievement at the same time… as crucial. This is fine as long as you weigh both options carefully. … to the tradeoffs we take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves….
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…on this SSD to run this experiment that long. So there we see the strong side of…the average throughput is 7800 tps. Something to take into account: TokuDB results are not quite stable…10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max-time=18000 –…
Post: MySQL Wish for 2013 - Better Memory Accounting
December 31, 2012 By 6 Comments
…walking blind with MySQL is resource usage – specifically Memory Usage. I can’t count how many time I had… example if some INFORMATION_SCHEMA query were to take couple of GB of memory we might not…MySQL 5.6 is getting close to be done I imagine the planning and feature design is long started for MySQL…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… COUNT(*). mysql> select count(*) cnt from order_lines\G *************************** 1. row *************************** cnt: 155187034 1 row in set (32.03 sec) mysql> …view which uses the complete refresh method takes a very long time to refresh: mysql> call flexviews.refresh( -> flexviews.get_id(‘…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
…long_query_time when it is set online, meaning changing it via set global long_query_time…MySQL but this would make replication to be delayed few more hours because of the time Innodb takes to open tables first time…__ 001 _______________________________________________________________________ Count :…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… which is obviously the problem – they take Apache Slot, MySQL Connection and other resources. I had … for scripts running very long time. For simplicity I did not use MySQL, but other system call – sleep… I would use real MySQL queries this would be counted to max_execution_time and so script …
Post: The case for getting rid of duplicate “sets”
May 17, 2011 By 2 Comments
… in set (0.00 sec) mysql> select count(*) from ex1; +———-+ | count(*) | +———-+ | 73027220 | +———-+ 1 row in set (0.00 sec) mysql> select sum(val) from… above. Also, notice that it takes a long time to delete. There is no index on this table. mysql> delete from data where val…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… of connections but yet MySQL takes much more memory than …count to see how many prepared statements are allocated on server and Com_stmt_send_long_data to see whenever sending long…INDEX_LENGTH: 0 CREATE_TIME: NULL UPDATE_TIME: NULL *************************** 2. row *************************** …
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… query was taking far too long to execute, ~11 hours in case of MySQL 5.5 and ~5 hours in case of MySQL 5… let’s take a look at the graph: MRR doesn’t really make any positive difference to the query times for MySQL 5… was used in both MySQL 5.6 and MariaDB 5.5. Handler_mrr_rowid_refills counts how many times the buffer used by…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… be repaired at the same time. What if user uses all … could easily make server to take up all memory. However there … each of them using mysql_stmt_send_long_data call – Server buffers …count are designed to protect from typical application mistakes not from someone intentionally trying to bring MySQL…
