…` varchar(39) default NULL, `f11` int(11) default NULL, `f12` float default NULL, `f13` int(11) default NULL, `f14` smallint(6… be improved. How? Let’s look mysql_query function: http://www.php.net/manual/en/function.mysql-query.php. Unfortunately there is nothing interesting for our current task excluding link to mysql_unbuffered_query and this link says: mysql…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… logs for the last month to see how frequently this functionality is used. Happily there are only few INSERT ON DUPLICATE… for MySQL to see what is different in the tables. It turned out one of the float columns stored “-0″ in MySQL 5… being trivial. This was the best choice as with New MySQL version upgrade involves new Operating System and hardware and any…
Comment: Innodb Performance Optimization Basics
April 24, 2008 By 75 Comments
…function microtime_float(){ list($usec, $sec) = explode(” “, microtime()); return ((float)$usec + (float)$sec); } $time_start = microtime_float…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…float depending on the load similar as loadavg metrics. Here are some of the ways to measure it: 1) Use “UserStats” functionality… query: mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql_…
Comment: Speeding up GROUP BY if you want aproximate results
September 4, 2008 By 24 Comments
….0 and 100.0 (float). I want to divide this value into N “bins” and make mysql count how many entries are… BY 1; Problem is: mysql can’t use an index on x because of the INTERVAL function. Is there a way I…
