Archive | September, 2008

mysqlnd

The new PHP driver for MySQL is out! http://dev.mysql.com/downloads/connector/php-mysqlnd/ Anyone give it a whirl? Well we certainly did and its cool . You can read all about it by clicking the link at above. I especially like the stats that the new driver now presents to you. Here is a sample bytes_sent 68935 bytes_received 304237 packets_sent 1229 packets_received 4427 protocol_overhead_in 17708 protocol_overhead_out 4916 result_set_queries 199 non_result_set_queries 21 no_index_used 65 bad_index_used 0 buffered_sets 198 unbuffered_sets 0 ps_buffered_sets 0 ps_unbuffered_sets 1 flushed_normal_sets 0 flushed_ps_sets 1 rows_fetched_from_server 609 rows_fetched_from_client 609 rows_skipped 0 copy_on_write_saved 4895 copy_on_write_performed 4168 command_buffer_too_small 0 connect_success 401 connect_failure 0 connection_reused 0 explicit_close 401 implicit_close 0 disconnect_close 0 in_middle_of_command_close 1 explicit_free_result 1 implicit_free_result 198 explicit_stmt_close 1 implicit_stmt_close 0 Persistent cache enabled put_hits 8 put_misses 10 get_hits 18 get_misses 9045 size 10 free_items 0 references 2 Although they says its beta [...] [...more]

MySQL, PHP Comments (0)

include file mystery

benchmarking three different ways to include files. [...more]

PHP Comments (0)

MySQL Optimizations on Linux

It is important to optimize all pieces of the LAMP acronym and MySQL is not exception to the rule when deploying on the live servers Here be the compile time flags. export CFLAGS=”-O3 -march=cpu -pipe -msse2 -m3dnow -fomit-frame-pointer -mtune=cpu” CXX=gcc CXXFLAGS=”-O3 -cpu -felide-constructors -fno-exceptions -fno-rtti” As mentioned in my previous entry you can go check the GCC [...] [...more]

Linux, MySQL Comments (0)

Linux hard drive performance optimization

Everywhere on the web I read about using the hdparm utility to increase hard drive speed. However it seems that this utility does not support sata drives properly. I have access to at least 5 different machines that run linux with different sata hard drives but the hdparm command fails more or less on each [...] [...more]

Linux Comments (3)

PHP Optimizations

How to get additional performance out of php. [...more]

PHP Comments (0)