Home → SMB Enterprise (Problems) →

eml with integers locks everything up?

John Whelan

06 May, 2011 05:11 PM via web

Admin Functions

• Edit
• Remove

I am running an analogies query on a single-node box and it is locking everything up.
The only thing I can think of - that is different, is the introduction of integers.
I had this happen to me before; and when I removed the integers, everything worked.
I turned on some logs - but fail to see the exact problem. I do know that where might be some negative values; which might need special handling. In MySQL, these values are set as SIGNED.
-John

1. 2 Posted by John Whelan on 06 May, 2011 06:33 PM

   

   After some more testing: I have found that using Integers with elm is MUCH MUCH slower than using just Strings. I have done a side-by-side comparison and there is a significant difference in performance.
   Is this to be expected?

   Admin Functions

   • Edit
   • Split
   • Remove

2. Support Staff 3 Posted by Yen-Min Huang on 06 May, 2011 08:41 PM

   

   We would like to gather a bit more information about your run.

   How the integers are introduced and removed? Were these extra integer categories added / removed, or they were modified from existing categories from String to Integer?

   The second question is that when using the integers, do you configure and query the integer fields with customized precision(s), radius, or number of proxies? Or, you just used the defaults?

   Are you using the analogy query directly, or is this the case that you need adjust the priorities/weights of the signature using a two-step queries? If it is the later case, which step is slow from your observation?

   Thanks.

   Yen-Min

   Admin Functions

   • Edit
   • Remove

3. 4 Posted by John Whelan on 06 May, 2011 08:58 PM

   

   The only difference between the two schema is one has an Integer type and the other uses a String type. I am using an analogy query with NO priorities or weights. I can demo this through a WebEx if you want.

   Admin Functions

   • Edit
   • Split
   • Remove

4. Support Staff 5 Posted by Yen-Min Huang on 06 May, 2011 09:55 PM

   

   We will need to investigate this call with your assistance. Jim said there is a new "xt" parameter in the "connection" query can return detailed query time breakdown. Unfortunately, the "xt" option is not available for the "analogies" query. Therefore, we need to simulate the analogy query with two calls. This is the experiment we would like you help gather the data:

   Call #!: issue your analogy query with the "si=true" or "si" depending on your version to return the signature attributes. Record the signature attributes returned.

   Call #2: issue the connection query with the signature attributes q=?(a1 a2 ...,) with the result category of your analogy target. Add the "&xt=true" as a part of query parameters. And collect the result.

   Repeat these two calls with "String" schema and "Integer" schema, then we can see what are the differences.

   Thanks for your assistance.

   Yen-Min

   Admin Functions

   • Edit
   • Remove

5. 6 Posted by John Whelan on 11 May, 2011 05:29 PM

   

   Jim: here is a copy of the MySQL full process dump you requested:

   	18895	saffron	localhost:45199	saffron_at_kingproperties_0	Query	0	NULL	CALL saffron_at_kingproperties_0.get_ids(0,2147511248,85,47867985,'27600',@com_mysql_jdbc_outparam_p_id_1,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_2,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_3,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_4,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_5,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_6,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_7,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_8,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_9,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_10,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_11,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_12,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_13,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_14,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_15,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_16,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_17,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_18,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_19,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_20,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_21,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_22,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_23,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_24,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_25,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_26,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_27,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_28,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_29,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_30,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_31,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_32,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_33,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_34,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_35,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_36,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_37,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_38,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_39,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_40,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_41,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_42,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_43,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_44,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_45,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_46,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_47,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_48,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_49,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_50,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_51,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_52,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_53,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_54,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_55,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_56,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_57,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_58,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_59,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_60,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_61,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_62,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_63,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_64,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_65,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_66,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_67,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_68,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_69,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_70,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_71,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_72,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_73,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_74,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_75,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_76,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_77,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_78,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_79,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_80,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_81,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_82,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_83,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_84,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_85,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_86,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_87,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_88,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_89,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_90,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_91,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_92,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_93,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_94,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_95,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_96,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_97,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_98,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_99,-1,0,0,null,@com_mysql_jdbc_outparam_p_id_100)

   Admin Functions

   • Edit
   • Split
   • Remove

6. Support Staff 7 Posted by Yen-Min Huang on 13 May, 2011 02:09 PM

   

   Jim provided you a patch with enhancements allowing passing down numerical settings and debugging capabilities. Please let us know how the patch work for you.

   Yen-Min

   Admin Functions

   • Edit
   • Remove

7. Jim Fleming closed this discussion on 30 Sep, 2011 03:28 PM.

Comments are currently closed for this discussion. You can start a new one.