1
|
a:1:{i:0;a:37:{i:0;a:3:{s:8:"sphinxql";s:27:"SHOW STATUS LIKE '%n_\_up%'";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:7:"Counter";s:14:"command_update";s:5:"Value";s:1:"0";}}}i:1;a:3:{s:8:"sphinxql";s:26:"SHOW META LIKE '%al%found'";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:13:"Variable_name";s:11:"total_found";s:5:"Value";s:1:"0";}}}i:2;a:3:{s:8:"sphinxql";s:27:"DESCRIBE test LIKE 'g_oup%'";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:5:"Field";s:8:"group_id";s:4:"Type";s:4:"uint";}i:1;a:2:{s:5:"Field";s:9:"group_id2";s:4:"Type";s:4:"uint";}}}i:3;a:3:{s:8:"sphinxql";s:23:"SHOW TABLES LIKE '__s_'";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:5:"Index";s:4:"test";s:4:"Type";s:5:"local";}}}i:4;a:3:{s:8:"sphinxql";s:34:"SHOW AGENT STATUS LIKE '%seconds%'";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:3:"Key";s:21:"status_period_seconds";s:5:"Value";s:2:"60";}}}i:5;a:3:{s:8:"sphinxql";s:68:"SELECT *, GROUPBY(), COUNT(*) FROM test GROUP BY group_id, group_id2";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:5:{s:2:"id";s:1:"1";s:8:"group_id";s:1:"1";s:9:"group_id2";s:1:"5";s:9:"groupby()";s:20:"-2580082279533744703";s:8:"count(*)";s:1:"1";}i:1;a:5:{s:2:"id";s:1:"2";s:8:"group_id";s:1:"1";s:9:"group_id2";s:1:"6";s:9:"groupby()";s:19:"-347766872566155294";s:8:"count(*)";s:1:"1";}i:2;a:5:{s:2:"id";s:1:"3";s:8:"group_id";s:1:"2";s:9:"group_id2";s:1:"7";s:9:"groupby()";s:19:"5566688876897930752";s:8:"count(*)";s:1:"1";}i:3;a:5:{s:2:"id";s:1:"4";s:8:"group_id";s:1:"2";s:9:"group_id2";s:1:"8";s:9:"groupby()";s:19:"2157931833992668655";s:8:"count(*)";s:1:"1";}}}i:6;a:3:{s:8:"sphinxql";s:79:"SELECT *, GROUPBY(), COUNT(*) FROM test GROUP BY group_id2, group_id, group_id2";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:5:{s:2:"id";s:1:"1";s:8:"group_id";s:1:"1";s:9:"group_id2";s:1:"5";s:9:"groupby()";s:20:"-2580082279533744703";s:8:"count(*)";s:1:"1";}i:1;a:5:{s:2:"id";s:1:"2";s:8:"group_id";s:1:"1";s:9:"group_id2";s:1:"6";s:9:"groupby()";s:19:"-347766872566155294";s:8:"count(*)";s:1:"1";}i:2;a:5:{s:2:"id";s:1:"3";s:8:"group_id";s:1:"2";s:9:"group_id2";s:1:"7";s:9:"groupby()";s:19:"5566688876897930752";s:8:"count(*)";s:1:"1";}i:3;a:5:{s:2:"id";s:1:"4";s:8:"group_id";s:1:"2";s:9:"group_id2";s:1:"8";s:9:"groupby()";s:19:"2157931833992668655";s:8:"count(*)";s:1:"1";}}}i:7;a:3:{s:8:"sphinxql";s:94:"SELECT * FROM loc1 WHERE MATCH ( 'text | got | here') LIMIT 1 OPTION max_predicted_time=10000";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:2:"11";}}}i:8;a:3:{s:8:"sphinxql";s:23:"SHOW META LIKE 'local%'";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:13:"Variable_name";s:18:"local_fetched_docs";s:5:"Value";s:1:"3";}i:1;a:2:{s:13:"Variable_name";s:18:"local_fetched_hits";s:5:"Value";s:1:"3";}i:2;a:2:{s:13:"Variable_name";s:19:"local_fetched_skips";s:5:"Value";s:1:"0";}}}i:9;a:2:{s:8:"sphinxql";s:22:"SHOW META LIKE 'dist%'";s:10:"total_rows";i:0;}i:10;a:3:{s:8:"sphinxql";s:26:"SHOW META LIKE '%predict%'";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:13:"Variable_name";s:14:"predicted_time";s:5:"Value";s:3:"303";}}}i:11;a:3:{s:8:"sphinxql";s:94:"SELECT * FROM loc2 WHERE MATCH ( 'text | got | here') LIMIT 1 OPTION max_predicted_time=10000";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"3";s:3:"idd";s:2:"11";}}}i:12;a:3:{s:8:"sphinxql";s:23:"SHOW META LIKE 'local%'";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:13:"Variable_name";s:18:"local_fetched_docs";s:5:"Value";s:1:"5";}i:1;a:2:{s:13:"Variable_name";s:18:"local_fetched_hits";s:5:"Value";s:1:"6";}i:2;a:2:{s:13:"Variable_name";s:19:"local_fetched_skips";s:5:"Value";s:1:"0";}}}i:13;a:2:{s:8:"sphinxql";s:22:"SHOW META LIKE 'dist%'";s:10:"total_rows";i:0;}i:14;a:3:{s:8:"sphinxql";s:26:"SHOW META LIKE '%predict%'";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:13:"Variable_name";s:14:"predicted_time";s:5:"Value";s:3:"506";}}}i:15;a:3:{s:8:"sphinxql";s:100:"SELECT * FROM loc1, loc2 WHERE MATCH ( 'text | got | here') LIMIT 1 OPTION max_predicted_time=10000";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:2:"11";}}}i:16;a:3:{s:8:"sphinxql";s:23:"SHOW META LIKE 'local%'";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:13:"Variable_name";s:18:"local_fetched_docs";s:5:"Value";s:1:"8";}i:1;a:2:{s:13:"Variable_name";s:18:"local_fetched_hits";s:5:"Value";s:1:"9";}i:2;a:2:{s:13:"Variable_name";s:19:"local_fetched_skips";s:5:"Value";s:1:"0";}}}i:17;a:2:{s:8:"sphinxql";s:22:"SHOW META LIKE 'dist%'";s:10:"total_rows";i:0;}i:18;a:3:{s:8:"sphinxql";s:26:"SHOW META LIKE '%predict%'";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:13:"Variable_name";s:14:"predicted_time";s:5:"Value";s:3:"809";}}}i:19;a:3:{s:8:"sphinxql";s:92:"SELECT * FROM d1 WHERE MATCH ( 'text | got | here') LIMIT 1 OPTION max_predicted_time=10000";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:2:"11";}}}i:20;a:3:{s:8:"sphinxql";s:23:"SHOW META LIKE 'local%'";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:13:"Variable_name";s:18:"local_fetched_docs";s:5:"Value";s:1:"3";}i:1;a:2:{s:13:"Variable_name";s:18:"local_fetched_hits";s:5:"Value";s:1:"3";}i:2;a:2:{s:13:"Variable_name";s:19:"local_fetched_skips";s:5:"Value";s:1:"0";}}}i:21;a:3:{s:8:"sphinxql";s:22:"SHOW META LIKE 'dist%'";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:13:"Variable_name";s:19:"dist_predicted_time";s:5:"Value";s:3:"506";}i:1;a:2:{s:13:"Variable_name";s:17:"dist_fetched_docs";s:5:"Value";s:1:"8";}i:2;a:2:{s:13:"Variable_name";s:17:"dist_fetched_hits";s:5:"Value";s:1:"9";}i:3;a:2:{s:13:"Variable_name";s:18:"dist_fetched_skips";s:5:"Value";s:1:"0";}}}i:22;a:3:{s:8:"sphinxql";s:26:"SHOW META LIKE '%predict%'";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:13:"Variable_name";s:14:"predicted_time";s:5:"Value";s:3:"303";}i:1;a:2:{s:13:"Variable_name";s:19:"dist_predicted_time";s:5:"Value";s:3:"506";}}}i:23;a:3:{s:8:"sphinxql";s:92:"SELECT * FROM d2 WHERE MATCH ( 'text | got | here') LIMIT 1 OPTION max_predicted_time=10000";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:2:"11";}}}i:24;a:3:{s:8:"sphinxql";s:23:"SHOW META LIKE 'local%'";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:13:"Variable_name";s:18:"local_fetched_docs";s:5:"Value";s:1:"0";}i:1;a:2:{s:13:"Variable_name";s:18:"local_fetched_hits";s:5:"Value";s:1:"0";}i:2;a:2:{s:13:"Variable_name";s:19:"local_fetched_skips";s:5:"Value";s:1:"0";}}}i:25;a:3:{s:8:"sphinxql";s:22:"SHOW META LIKE 'dist%'";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:13:"Variable_name";s:19:"dist_predicted_time";s:5:"Value";s:3:"809";}i:1;a:2:{s:13:"Variable_name";s:17:"dist_fetched_docs";s:5:"Value";s:1:"8";}i:2;a:2:{s:13:"Variable_name";s:17:"dist_fetched_hits";s:5:"Value";s:1:"9";}i:3;a:2:{s:13:"Variable_name";s:18:"dist_fetched_skips";s:5:"Value";s:1:"0";}}}i:26;a:3:{s:8:"sphinxql";s:26:"SHOW META LIKE '%predict%'";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:13:"Variable_name";s:14:"predicted_time";s:5:"Value";s:1:"0";}i:1;a:2:{s:13:"Variable_name";s:19:"dist_predicted_time";s:5:"Value";s:3:"809";}}}i:27;a:3:{s:8:"sphinxql";s:92:"SELECT * FROM d3 WHERE MATCH ( 'text | got | here') LIMIT 1 OPTION max_predicted_time=10000";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:2:"id";s:1:"1";s:3:"idd";s:2:"11";}}}i:28;a:3:{s:8:"sphinxql";s:23:"SHOW META LIKE 'local%'";s:10:"total_rows";i:3;s:4:"rows";a:3:{i:0;a:2:{s:13:"Variable_name";s:18:"local_fetched_docs";s:5:"Value";s:1:"0";}i:1;a:2:{s:13:"Variable_name";s:18:"local_fetched_hits";s:5:"Value";s:1:"0";}i:2;a:2:{s:13:"Variable_name";s:19:"local_fetched_skips";s:5:"Value";s:1:"0";}}}i:29;a:3:{s:8:"sphinxql";s:22:"SHOW META LIKE 'dist%'";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:2:{s:13:"Variable_name";s:19:"dist_predicted_time";s:5:"Value";s:3:"809";}i:1;a:2:{s:13:"Variable_name";s:17:"dist_fetched_docs";s:5:"Value";s:1:"8";}i:2;a:2:{s:13:"Variable_name";s:17:"dist_fetched_hits";s:5:"Value";s:1:"9";}i:3;a:2:{s:13:"Variable_name";s:18:"dist_fetched_skips";s:5:"Value";s:1:"0";}}}i:30;a:3:{s:8:"sphinxql";s:26:"SHOW META LIKE '%predict%'";s:10:"total_rows";i:2;s:4:"rows";a:2:{i:0;a:2:{s:13:"Variable_name";s:14:"predicted_time";s:5:"Value";s:1:"0";}i:1;a:2:{s:13:"Variable_name";s:19:"dist_predicted_time";s:5:"Value";s:3:"809";}}}i:31;a:3:{s:8:"sphinxql";s:25:"SELECT COUNT(*) FROM test";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:1:{s:8:"count(*)";s:1:"4";}}}i:32;a:3:{s:8:"sphinxql";s:44:"SELECT id id1, COUNT(DISTINCT id1) FROM test";s:10:"total_rows";i:1;s:4:"rows";a:1:{i:0;a:2:{s:3:"id1";s:1:"1";s:19:"count(distinct id1)";s:1:"4";}}}i:33;a:3:{s:8:"sphinxql";s:69:"SELECT *, GROUPBY(), COUNT(*) FROM dist1 GROUP BY group_id, group_id2";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:5:{s:2:"id";s:1:"1";s:8:"group_id";s:1:"1";s:9:"group_id2";s:1:"5";s:9:"groupby()";s:20:"-2580082279533744703";s:8:"count(*)";s:1:"1";}i:1;a:5:{s:2:"id";s:1:"2";s:8:"group_id";s:1:"1";s:9:"group_id2";s:1:"6";s:9:"groupby()";s:19:"-347766872566155294";s:8:"count(*)";s:1:"1";}i:2;a:5:{s:2:"id";s:1:"3";s:8:"group_id";s:1:"2";s:9:"group_id2";s:1:"7";s:9:"groupby()";s:19:"5566688876897930752";s:8:"count(*)";s:1:"1";}i:3;a:5:{s:2:"id";s:1:"4";s:8:"group_id";s:1:"2";s:9:"group_id2";s:1:"8";s:9:"groupby()";s:19:"2157931833992668655";s:8:"count(*)";s:1:"1";}}}i:34;a:3:{s:8:"sphinxql";s:80:"SELECT *, GROUPBY(), COUNT(*) FROM dist1 GROUP BY group_id2, group_id, group_id2";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:5:{s:2:"id";s:1:"1";s:8:"group_id";s:1:"1";s:9:"group_id2";s:1:"5";s:9:"groupby()";s:20:"-2580082279533744703";s:8:"count(*)";s:1:"1";}i:1;a:5:{s:2:"id";s:1:"2";s:8:"group_id";s:1:"1";s:9:"group_id2";s:1:"6";s:9:"groupby()";s:19:"-347766872566155294";s:8:"count(*)";s:1:"1";}i:2;a:5:{s:2:"id";s:1:"3";s:8:"group_id";s:1:"2";s:9:"group_id2";s:1:"7";s:9:"groupby()";s:19:"5566688876897930752";s:8:"count(*)";s:1:"1";}i:3;a:5:{s:2:"id";s:1:"4";s:8:"group_id";s:1:"2";s:9:"group_id2";s:1:"8";s:9:"groupby()";s:19:"2157931833992668655";s:8:"count(*)";s:1:"1";}}}i:35;a:3:{s:8:"sphinxql";s:69:"SELECT *, GROUPBY(), COUNT(*) FROM dist2 GROUP BY group_id, group_id2";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:5:{s:2:"id";s:1:"1";s:8:"group_id";s:1:"1";s:9:"group_id2";s:1:"5";s:9:"groupby()";s:20:"-2580082279533744703";s:8:"count(*)";s:1:"1";}i:1;a:5:{s:2:"id";s:1:"2";s:8:"group_id";s:1:"1";s:9:"group_id2";s:1:"6";s:9:"groupby()";s:19:"-347766872566155294";s:8:"count(*)";s:1:"1";}i:2;a:5:{s:2:"id";s:1:"3";s:8:"group_id";s:1:"2";s:9:"group_id2";s:1:"7";s:9:"groupby()";s:19:"5566688876897930752";s:8:"count(*)";s:1:"1";}i:3;a:5:{s:2:"id";s:1:"4";s:8:"group_id";s:1:"2";s:9:"group_id2";s:1:"8";s:9:"groupby()";s:19:"2157931833992668655";s:8:"count(*)";s:1:"1";}}}i:36;a:3:{s:8:"sphinxql";s:80:"SELECT *, GROUPBY(), COUNT(*) FROM dist2 GROUP BY group_id2, group_id, group_id2";s:10:"total_rows";i:4;s:4:"rows";a:4:{i:0;a:5:{s:2:"id";s:1:"1";s:8:"group_id";s:1:"1";s:9:"group_id2";s:1:"5";s:9:"groupby()";s:20:"-2580082279533744703";s:8:"count(*)";s:1:"1";}i:1;a:5:{s:2:"id";s:1:"2";s:8:"group_id";s:1:"1";s:9:"group_id2";s:1:"6";s:9:"groupby()";s:19:"-347766872566155294";s:8:"count(*)";s:1:"1";}i:2;a:5:{s:2:"id";s:1:"3";s:8:"group_id";s:1:"2";s:9:"group_id2";s:1:"7";s:9:"groupby()";s:19:"5566688876897930752";s:8:"count(*)";s:1:"1";}i:3;a:5:{s:2:"id";s:1:"4";s:8:"group_id";s:1:"2";s:9:"group_id2";s:1:"8";s:9:"groupby()";s:19:"2157931833992668655";s:8:"count(*)";s:1:"1";}}}}}
|