…it contains fair population of transaction – getting only transactions which are slow is…it took to execute SQL query from PHP application side, but we can’t…port request was issued to which key was requested, and on response I… time is coming from MySQL. I check the number of MySQL Queries and it is…
Comment: When should you store serialized objects in the database?
January 22, 2010 By 47 Comments
… reads and writes from memcached. It has 3 simple functions: get(key), set(key, value), and delete(key). In the set() function… hit, but I imagine it’s related to MySQL‘s block size, which I’m sure I’… my applications. Anyway, this allows me, as a PHP programmer, to write code insanely fast, and will …
Comment: MySQL Partitioning - can save you or kill you
June 28, 2012 By 45 Comments
…mysql.com/list.php?24 ) > 8GB RAM > key_buffer_size=512M I would recommend (if you stick with MyISAM) 1500M. See http://mysql….ObjInstance and o1.utctime=o2.utctime); ” SELECT * FROM ObjectInstances_T where ObjectClass in (…) and… have a VARCHAR. Often people can get away with latin1, which has less…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a … new Linux/Mysql server for a client, upgrading their main database (from 16GB, … a good way to get large data manageable. MySQL Master Master Manager …hash searches/s HT: Strange, primary key equality searches should work through the…
Post: GROUP_CONCAT useful GROUP BY extension
September 4, 2006 By 49 Comments
… to get PHP array without looping inside PHP: Table: CREATE TABLE services ( id INT UNSIGNED NOT NULL, client_id INT UNSIGNED NOT NULL, KEY…,7 | +—-+————————-+ Handling in PHP: old way: with group_concat: This should work faster, as we remove loop from PHP to MySQL server side. Also…
Post: Drop table performance
April 20, 2011 By 22 Comments
… http://bugs.mysql.com/bug.php?id=51325 and http://bugs.mysql.com/bug.php?id=56332.) …get especially painful, as during this operation InnoDB holds the LOCK_open mutex, which prevents other queries from…mysql -Bse “CREATE TABLE ts_$i (begin_time int(11) NOT NULL, end_time int(11) NOT NULL, PRIMARY KEY…
Comment: MySQL Query Cache
June 3, 2009 By 70 Comments
… You can also use it as misc object cache from inside php This are still different shoes And even if …it with mysql-qery-cache because if your manual cache is outdated you get most time parts of it from ….419 qps], 224K conn, TX: 8B, RX: 1B) [OK] Key buffer hit rate: 99.7% (14M cached / 44K reads)…
Post: Improved InnoDB rw_lock patch
October 20, 2008 By 3 Comments
….g. update_key benchmark from sysbench. There are also results with Yasufumi’s rw_locks (http://bugs.mysql.com/bug.php?id=26442) ThreadsStandard… include InnoDB smp fixes in our build yet. Fortunately we get fixed version of Yasufumu’s rw_locks and you can…
Post: mk-query-digest, query comments and the query cache
… additional information such as the PHP source line and user … the comment into attribute key/value pairs. For example: –embedded-attributes ‘^– [^\n…from this test. You can enable query cache stripping in Percona Server at runtime: mysql… with no comment at all) get 1000 misses. Everything beyond …