June 19, 2013

Post: SQL Injection Questions Followup

… to clear up some of the misconceptions that many other blogs and articles have about this security risk.  You can register….mysql.com/doc/refman/5.5/en/string-literals.html for more information on string literals. Allan F. asked: Q: Is it… is that you can try embedding a string-termination quote into an input data string, followed by invalid SQL syntax: http://example…

Post: Identifying the load with the help of pt-query-digest and Percona Server

… # Boolean: # Full scan 100% yes, 0% no # String: # Databases wp_blog_one (264/84%), wp_blog_tw… (36/11%)… 1 more # Hosts # InnoDB…/0%)… 309 more # Last errno 0 # Users wp_blog_one (264/84%), wp_blog_two (36/11%)… 1 more # Query_time distribution… # Tmp table on 100% yes, 0% no # String: # Databases wp_blog_one (105/70%), wp_blog_tw… (34/22%)… 1 more # Hosts # InnoDB…

Comment: How to find wrong indexing with glance view

string‘s crc32 value. Now instead of doing WHERE string = ‘value’ I do WHERE string_crc32 = ’4958494034′ for example. Since I now added string… my index had to be in the middle and the string_crc was last. I was somewhat cleaver with my queries… want to check out his Join Fu slides on his blog.

Comment: PHP vs. BIGINT vs. float conversion caveat

…, I don’t see any strings there. Peter just made a typo. I explicitly mentioned conversion TO string, in bold. > in both… me, this is enough of a reason to make a blog post to warn the readers about such caveat. > To be… solution in some scenarios. It’s only the float to string conversion which suddenly, and unexpectedly, fails.

Comment: Database access Optimization in Web Applications.

… and more packets. – Conversion to the string and back is expensive for certain amount of strings. … Try benchmarking it for example with…. I write a big deal about query optimization in the blog. This list is to say when there are things implemented…

Post: MySQL opening .frm even when table is in table definition cache

… me from several years ago. I’ve since discovered the blog post in which I mention it: drop table fail (on… (“header”) check if it’s a view by doing a string compare for “TYPE=VIEW\n” being the first bytes of the… Forge Internals document on the FRM file format Stewart’s blog post on the FRM file format (from early 2009, towards…

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

… it’s actually possible to do this in a single blog post) than what MyISAM gives us. Recall that we have… of varchar type Uh… Does this mean that my next blog post should be entitled, “When is a VARCHAR Not Really… enter search phrases that include initials, numbers, or any other string of length less than 3 (the default), I think you…

Comment: How to change innodb_log_file_size safely

…: innodb_log_file_size = 64M (without the “B” in “MB” string) This works on my site on a Debian Squeeze system…_buffer_pool_size). According to my previous posts in this blog a dynamic innodb log file RECREATE did NOT seem to…

Comment: Percona XtraBackup 1.6

Sweet, has the bug been fixed where innobackupex won’t recognise MariaDB version string http://blogs.skysql.com/2011/03/using-xtrabackup-and-incremental.html ? Thanks

Comment: Percona XtraBackup 1.6

Sweet, has the bug been fixed where innobackupex won’t recognise MariaDB version string http://blogs.skysql.com/2011/03/using-xtrabackup-and-incremental.html ? Thanks