|
|||||
|
Sun Optimized AMP Stack for the Solaris 10 OS . Sun offers a new recipe for success — the Solaris OS + AMP (Solaris 10 OS, Apache, MySQL, and PHP). For customers committed to the open AMP stack, this “recipe” provides the same Web applications they know and use, but on a more secure open-source . . . → Read More: Sun Optimized AMP Stack for the Solaris 10 OS MySQL is a very strange database. That’s why it has such strange bugs It does support cross-database delete, but only if you do not specify aliases for tables. Unfortunately, there are situations, when aliases are vital If you still use INI file for some of your PHP-projects configuration, I guess it is time for you to migrade to YAML which is more flexible and has way more expressiveness. Here is a little tool to help you in migration process <?php require “Spyc.php”; if ($argc != 3) die(“I need 2 parameters: in_file.ini, . . . → Read More: ini2yaml in PHP MySQL console has a long history of not properly counting column-widths for multibyte data. This was fixed in 4.1.12/5.0.25 Although, with a little catch. You have to start mysql console with “–default-character-set=utf8″ key or it will fall back to it’s “classical” behavior Nathan Neulinger made a patch for memcached, which adds it ability to work over local unix sockets. This might give memcached one more speed-boost in one-server cases. Patches address server-part and perl-based client part. It shouldn’t be difficult to make similiar patch for PHP Original note can be found at gmane.comp.web.cache.memcached. This patch didn’t have . . . → Read More: gmane.comp.web.cache.memcached Jay Pipes recently wrote about a problem in mysql, which basically is, that prepared statements do not use query cache, which results in not-as-good-as-it-could-be performance. You should read the details yourself here: Minding My P’s and Q’s (Prepared Statements and Query Cache Episode 3). Essential part of the message is, that he looks for volunteers . . . → Read More: MySQL: prepared statements vs. query cache. help request |
|||||
|
Copyright © 2012 Alexey Zakhlestins blog - All Rights Reserved Powered by WordPress & Atahualpa |
|||||
