pbxt.blogspot.com

blog.andrewrose.co.uk

Andrew Rose: May 2010

http://blog.andrewrose.co.uk/2010_05_01_archive.html

Wednesday, 26 May 2010. ExtJS - loading grid record into form with loadRecord() but getting the displayField instead of valueField submitted. A long title I know, but today was one of those days that every programmer dreads. a day with a small problem that takes more than 5minutes to figure out. This one took me a whole day! Reasons; partly because of a lack of documentation, partly me giving ExtJS to much magic credit and mostly me over-thinking the problem. You need to set the hiddenName value in the c...

blog.andrewrose.co.uk

Andrew Rose: January 2008

http://blog.andrewrose.co.uk/2008_01_01_archive.html

Wednesday, 30 January 2008. LAMP: The mailing lists you *SHOULD* be subscribed to. The LAMP stack consists of some complicated software, and this software from time to time will develop faults and security flaws. How do you keep yourself informed? Hope that the issues crop up on Digg, Slashdot? Well the best way is to join the Announce lists for each of the LAMP stack components. The first one is dependent on the GNU/Linux distribution your running, in my case it is Archlinux, so I've subscribed to:.

blog.andrewrose.co.uk

Andrew Rose: September 2011

http://blog.andrewrose.co.uk/2011_09_01_archive.html

Tuesday, 20 September 2011. MongoDb numeric field selection in PHP. If you are attempting to use numeric field selection with MongoCollection: find() and run into the error:. PHP Fatal error: Uncaught exception 'MongoException' with message 'field names must be strings'. It is caused by PHP converting an array key that is defined as a string into an integer, so:. Array('123' = 0);. Array(123 = 0);. Fields = new stdClass;. Fields- {123} = 0;. Posted by Andrew Rose. Subscribe to: Posts (Atom).

varokism.blogspot.com

varokism: décembre 2011

http://varokism.blogspot.com/2011_12_01_archive.html

Mercredi 21 décembre 2011. Fine tuning read rnd buffer size and read buffer size. Those variables are easy to tune. The evidence popup here between 128 and 256K for in memory workload. In myisam.cc my default record cache size is set to global system variables.read buff size;. To show IO size :. Strace -p id mysqld -e read -e write. In InnoDB the difference come with prefetch trigger when no fragmentation. It is the case when rows are inserted in increasing primary key order. So conservative read...As we...

varokism.blogspot.com

varokism: Howto - Move a table to different schema with no outage

http://varokism.blogspot.com/2015/04/howto-move-table-to-different-schema.html

Jeudi 16 avril 2015. Howto - Move a table to different schema with no outage. I remember a time when it was debate if views can be useful for a web oriented workload? This post is about one good use case:. The story is that some tables have been creating into a schema and used by the application into same connection. Later on some more schema have been added to separate data for multiple application domain but still using original table, kind of cross domain universal table. CREATE DATABASE schema1;.

blog.andrewrose.co.uk

Andrew Rose: Roll your own N-server sandbox

http://blog.andrewrose.co.uk/2008/02/roll-your-own-n-server-sandbox.html

Tuesday, 5 February 2008. Roll your own N-server sandbox. Have you ever wanted to play around with(test ;) MySQL replication/clustering techniques, LVS/Apache load balancing etc but didn't have the hardware available and where smart enough not to use a production environment? Well an easy way to be able to do this is by creating a sandbox environment using something like qemu. Root@ishell ]# pacman -S user-mode-linux uml utilities. Root@ishell ]# mkdir servers. Root@ishell ]# cd servers. Root@ishell ]# i...

blog.andrewrose.co.uk

Andrew Rose: LAMP: The mailing lists you *SHOULD* be subscribed to.

http://blog.andrewrose.co.uk/2008/01/lamp-mailing-lists-you-should-be.html

Wednesday, 30 January 2008. LAMP: The mailing lists you *SHOULD* be subscribed to. The LAMP stack consists of some complicated software, and this software from time to time will develop faults and security flaws. How do you keep yourself informed? Hope that the issues crop up on Digg, Slashdot? Well the best way is to join the Announce lists for each of the LAMP stack components. The first one is dependent on the GNU/Linux distribution your running, in my case it is Archlinux, so I've subscribed to:.

blog.andrewrose.co.uk

Andrew Rose: April 2008

http://blog.andrewrose.co.uk/2008_04_01_archive.html

Friday, 11 April 2008. I wouldn't normally post OT on my blog but this is for a good cause. I'm running the Manchester 10k. On the 18th of May and am trying to raise £200 for the Rainbow Family Trust (Francis House) who support and improve the quality of life for terminally ill children diagnosed with 'no cure'. So dig deep and help me reach my target by going to this site and making a donation: http:/ www.justgiving.com/. Posted by Andrew Rose. Subscribe to: Posts (Atom). View my complete profile.

varokism.blogspot.com

varokism: MariaDB Storage Engine for CCM forum

http://varokism.blogspot.com/2013/07/mariadb-storage-engine-for-ccm-forum.html

Vendredi 5 juillet 2013. MariaDB Storage Engine for CCM forum. CCM Benchmark is one of the leading forum provider on the web, ROI is a major concern for them and historically MyISAM was used on the forum replication cluster. Reason is that MyISAM gave better ROI/performance on data that is hardly electable to cache mechanism. Like many other big web players at an other scale, Damien need to scale on disk not because it's good, but because you can catch more with less hardware. Doing this you need to ...