Archive for September, 2008

12
Sep

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 in [...]

free blog themes
12
Sep

include file mystery

benchmarking three different ways to include files.

free blog themes
12
Sep

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 [...]

free blog themes
12
Sep

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 [...]

free blog themes
11
Sep

PHP Optimizations

How to get additional performance out of php.

free blog themes
Free WordPress Themes