…”Query Cache” which is quite helpful for MySQL Performance optimization tasks but there are number…cached SHOW commands or stored procedure calls are not, even if stored procedure would simply preform select to…queries being cached this might reduce update speed a bit. Fragmentation over time – Over …
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
… speed stays about the same: mysql> select count(*) from m3; +———-+ | count(*) | +———-+ | 10476840 | +———-+ 1 row in set (0.00 sec) mysql… 10000 rows and wrote little stored procedure to make timing easier: mysql> DELIMITER // mysql> CREATE PROCEDURE test_read(pl INT) -> BEGIN -> …
Post: A micro-benchmark of stored routines in MySQL
August 16, 2009 By 7 Comments
… wondered how fast stored routines are in MySQL? I just ran a quick micro-benchmark to compare the speed of a stored function against…, your comments welcome — is to see how fast the SQL procedure code is at doing basically the same thing the subquery… took the subquery and basically rewrote it as a stored function. mysql> delimiter // mysql> create function speaks_english(c char(3)) returns integer…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…, both in terms of size and spindle speed. I need to know how many physical …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…, or apps that have a lot of stored procedures, which are more difficult to analyze because …
Post: PROCEDURE ANALYSE
March 23, 2009 By 9 Comments
…speeds up processing in most cases ? These and similar tasks are often done by bunch of SQL queries while really MySQL has a native feature to perform this task – PROCEDURE ANALYSE Here is sample run of PROCEDURE…data type – maximum length of data actually stored often can tell us if we defined…
Comment: MySQL - to use or not to use
May 29, 2007 By 10 Comments
…. Also I think many of those who say that MySQL lacked triggers, stored procedures, views and so on didn’t really want to… see now, you can live fine without partitioning, views, triggers, stored procedures for most applications – but if you need them, they are… google performancetools tcmalloc library, will be interesting to see the speed impact.
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 139 Comments
… set-variable=max_connections=1500 log_slow_queries=/var/log/mysql-slow.log sql-mode=TRADITIONAL concurrent_insert=2 low_priority… eking performance out of an InnoDB table for raw SELECT speed will take a committee of ten PhDs in RDBMS management… needed referential integrity and such, MySQL was a pathetic “option”. Yes 5.x has included triggers, stored procedures, and such, but they’re…
