June 18, 2013

Post: Modeling MySQL Capacity by Measuring Resource Consumptions

March 8, 2011 By 1 Comment

… model baron has published for example is good for measuring …look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/… Server you can get the value from User Statistics *************************** 1. row ***************************…0 0 0 0 0 0 # Boolean: # Filesort 0% yes, 99% no # …

Filed Under: Insight for DBAs, MySQL

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

March 4, 2013 By 7 Comments

…with a single VARCHAR column named “value“. OK, sounds easy enough: mysql: SHOW CREATE TABLE innodb_myisam_stopword\G…than those with out it. So, for example, if we change the above query to …happens: mysql: SELECT id, full_name, MATCH(full_name, details) AGAINST (‘+james +peterson arizona’ IN BOOLEAN…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

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

December 29, 2011 By 3 Comments

… atomically, not just for new connections as in MySQL. This is very helpful for measurement as otherwise …/values reported in the 95% (95th percentile) column as that gives us more accurate understanding. Now, for example … 0 0 0 0 0 0 0 0 # Boolean: # Full scan 100% yes, 0% no # String: # Databases …

Filed Under: Insight for DBAs, MySQL

Post: MySQL Server Variables - SQL layer or Storage Engine specific.

June 8, 2006 By 14 Comments

…for in memory tables. So first MySQL versions did not bother naming … have really bulk inserts 100-1000+ values per single insert statement. concurrent_insert -… all storage engines support it. For example Innodb tables do not support them…sure data hits the disk ft_boolean_syntax, ft_max_word_len, ft_…

Filed Under: Insight for DBAs Tagged With: ,

Post: FaceBook Search, Search for social networks

August 12, 2007 By 4 Comments

…index process. With Sphinx which talks directly to the MySQL database we can get some 10.000 of …using some wise ranking instead of boolean search on the first stage. For example if I would fetch 10…. of features missing which would likely be great value for the users. This is of course content search…

Filed Under: Events and Announcements Tagged With: ,

Comment: How to find wrong indexing with glance view

August 23, 2008 By 27 Comments

… like (gender, age, available, looking_for, location, has_foto) 2) booleans – gender, has_foto; enums – available, looking_for, location; integer – age… to 60 values so it can be converted to IN instead of using BETWEEN [1]. As all boolean operators are ‘AND’, mysql can… fields are mandatory. 2) You’ve selected mandatory prefix, for example (City, Gender, Age) is the most effective. Drop it :) and…

Filed Under: Insight for DBAs Tagged With:

Post: Sphinx search performance optimization: attribute-based filters

January 15, 2013 By 11 Comments

…examples below I will be using SphinxQL protocol which looks like talking to MySQL…sphinx> show meta; +—————+———-+ | Variable_name | Value | +—————+———-+ | total | 1000 | | total_found | 10309972 | | time …column for a skewed boolean attribute “ancient” which identifies…

Filed Under: Insight for Developers, MySQL Tagged With: , ,

Comment: Database problems in MySQL/PHP Applications

August 11, 2006 By 13 Comments

…with traditional database background. > Things are different with MySQL. Good design will help dictate how many …and so using IN() list of values derived > by previous query. For example you can do: > SELECT …million rows with an index on a Boolean column for example) is unlikely to be helpful unless …

Filed Under: Insight for Developers Tagged With: , ,