June 20, 2013

Post: SQL Injection Questions Followup

… to escape input that contains non-printing characters. The standard API function mysql_real_escape_string() is aware of binary bytes, and will escape appropriately… moves too much computation load onto their database server.  Their MySQL server became CPU-bound, while their multiple PHP application servers…

Comment: Why MySQL could be slow with large tables ?

…=” .$_REQUEST['USER_PASSWORD'] ; Probably down to the way you mySQL table is setup. I’d be more concerned about your… further up the script you have a $_REQUEST['USER_PASSWORD'] = mysql_real_escape_string($_REQUEST['USER_PASSWORD']); otherwise some little script kiddy is…

Post: Cache Performance Comparison

…, so this is kind of peak performance MySQL can provide. Of course for your real queries cost of database access will normally… of error control or other precausions like string escaping which you will need in real application. Also due to the same reason… used, but if Unix Socket is used to connect to MySQL MySQL Query Cache will be faster. The explanation for this is…