… buffer all content it gets from PHP script which means many megabytes for large files. Partial file sending happily was added in lighttpd… as OS cache has single page granularity (meaning 100 bytes file will still take 4KB in cache). For serving large set of files (which… main server to get the file. Also it frequently does not make sense to use disk cache for static content as getting…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
… the rows to the Binary Log Cache before writing it to the Binary Log Files. If that cache is not big enough to store the temporary data it will create a on-disk cache on… report to follow this issue: http://bugs.mysql.com/bug.php?id=66237
Comment: NO Security vulnerability in Percona Server / XtraDB Cluster provided binaries
June 13, 2012 By 13 Comments
… in PHP: [root@caffeine ~]# php -i | grep “Configure Command” Configure Command => ‘./configure’ ‘–cache-file=../php-5.4.3.cache‘ ‘–with-config-file-path=/etc’ ‘–with-config-file-scan-dir=/etc/php.d…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… shards (adjust to your number of nodes) php genconfig 20 > shards.ini Running the test …2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb-flush-log-…TRANS_TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=…
Comment: Alternatives of PHP ?
September 14, 2006 By 28 Comments
… result, you might consider storing intermediate values to file. At the far end of this way of … Perl check out http://cpan.uwinnipeg.ca/htdocs/Cache-FastMmap/Cache/FastMmap.html for example One advantage of Perl … like to solve this kind of problem (unlike PHP). Browse CPAN – Perl’s XML tools a also …
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…formating, so > database connection may become the issue. Caching should be > good help in this case though….such as > you do with directories to group files. I think this makes a lot of > sense… however start > to crawl. > So developing you PHP applications use test database with reasonable > amount …
Comment: Cache Performance Comparison
September 17, 2007 By 74 Comments
… a cache that’s basically an array? How would you use this in a real world PHP program — as an include file with records stored in an array? If so, I think pitting it against eAccelerator or MySQL query cache is pathetic. Including a file and refering to array elements will be highly…
Comment: APC or Memcached
September 27, 2006 By 23 Comments
… hard to make APC distributed as well. The distribution of cache entries in Memcached is managed by the client API. Basically…_table). One could write a PHP class that takes care of this, and inserts/requests cache entries from/into the different nodes… use APC both for local caching, and distributed caching. The same method applies to file based or database based caching. For illustration see http…
Comment: Opening Tables scalability
March 20, 2007 By 27 Comments
… “show processlist” is “opening tables”. We have many php and system tweaks but this problem seems to …useable tables – best performance setting for us is table_cache=0. Now it’s hosted on Linux 2.6 …this cause worse performance problems – like hosting >10 000 000 files in one directory (3 files per …
Comment: 5.0.83-build17 Percona binaries
August 6, 2009 By 19 Comments
… vastly improves small file access whether reading or writing, key for db operations! (http://www.pcper.com/article.php?aid=669&type… is mounted on the drive 7) Relocate the innodb log files to a directory on a seperate partition on a standard…=/var/lib/mysqlnonssd/ 8) Make sure you bypass the OS caches innodb_flush_method=O_DIRECT 9) We get the best…
