…that time-based flushing allows the backing store to be written to at a more …results were obtained with the default vCache configuration, I think vCache can be declared the clear winner. Base MySQL…wait_timeout = 120 max_connections = 5000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_…
Post: Handling big result sets
June 26, 2006 By 13 Comments
…stmt->store_result(); to buffer the result on client side. The results: with $stmt->store_result(): 55.20s without $stmt->store_result…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… of placeholders and send data for each of them using mysql_stmt_send_long_data call – Server buffers such data until you… queries. Stored Procedures – How much memory can stored procedure allocate ? say can you create 1000 variables in stored procedure and set 1M result set to each of them ? I have not experimented with other stored procedure language…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… bumping the counters at the same time. As a result, some of the stores might be lost, with the counter values slightly…:2553) ==9090== by 0x6A87FC: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:269) ==9090== by 0x63A3E3: execute…:5179) ==9090== by 0x6435EA: mysql_execute_command(THD*) (sql_parse.cc:2309) ==9090== by 0x782C6D: sp_instr_stmt::exec_core(THD*, unsigned…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… lot larger problems with MySQL 5.5 with addition of user variables, stored procedures, prepared statements… you might want to look at Prepared_stmt_count to see how many prepared statements…other correspond to global memory allocation and will result in increased memory allocation until server is …
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
… Bugs WHERE bug_id IN ($placeholders)”; $stmt = $pdo->prepare($sql); $stmt->execute($params); Radu M. asked:…load onto their database server. Their MySQL server became CPU-bound, while …results in a subsequent SQL query, then you should be able to store such strings safely. Another risk of storing…
