…with MySQL 5.5 with addition of user variables, stored procedures, …remove (or still use for processing). Of course you will …(both in memory and not): mysql> select * from information_schema.global_temporary_tables \G … global memory allocation and will result in increased memory allocation until…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…results mysql> select sum(total_lines) from dashboard_customer_sales ; +——————+ | sum(total_lines) | +——————+ | 155186550 | +——————+ 1 row in set (0.64 sec) mysql> select…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
…procedure to make timing easier: mysql> DELIMITER // mysql> CREATE PROCEDURE…results, but I show only one here) mysql> select sum(i) from m3; +———+ | sum(i) | +———+ | 3492290 | +———+ 1 row in set (1.86 sec) mysql> select…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
…Because by default mysql_query uses mysql_store_result C library call and buffers all result set in the process memory. … do processing in PHP at all. Many summary tables can be built by INSERT … SELECT, or…Another alternative is of course to use MySQL Stored Procedures which can be fit to do this …
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…full result sets. This means it is much more efficient as query which required processing …SELECT queries are cached SHOW commands or stored procedure calls are not, even if stored procedure would simply preform select…likely would not have change their result set but MySQL has no way to identify …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…The result looks like this: +———————————–+———————-+———————-+ | Variable_name |… non-SELECT …stored procedures,…our process …
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
… count($params), “?”)); $sql = “SELECT * FROM Bugs WHERE…process, but it’s not her responsibility alone. Brian P. commented: Q: If you’re writing Dynamic SQL in your Stored Procedures…procedures extensively. They found that it was awkward because of the limits of the procedure language MySQL… results …
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…*” are not really used. Load procedure: Infobright: the loader that …that load statement is: mysql -S /tmp/mysql-ib.sock -e “…SELECT count(*) FROM ontime;. Both InforBritgh and MonetDB executes it immediately with result… is not for online transactions processing. Compression in InfoBright is …
Comment: Can MySQL temporary tables be made safe for statement-based replication?
May 27, 2008 By 8 Comments
…stored procedure and that I have my code surrounded by START TRANSACTION; COMMIT; mysql>…TABLE `test`.`temporary_table` ENGINE = InnoDB AS SELECT id, value_1, value_2, value… I was going to create a process that could potentially run this multiple …rc and I got the same results. So at first glance, we …
