…Using intersect(i1,i2); Using where | +—-+————-+———+————-+—————+——-+———+——+——+————————————-+ 1 row in set (0.00 sec) As you can see in this case MySQL does the Intersection…
Comment: How to find wrong indexing with glance view
August 23, 2008 By 27 Comments
… converted to IN instead of using BETWEEN [1]. As all boolean operators are ‘AND’, mysql can use either indexes built on multiple columns or intersection of… “show people with fotos only” and mysql can use index to filter records before fetching any rows. How much it will give? Not many…
Post: SystemTap - DTrace for Linux ?
September 14, 2009 By 17 Comments
… can intersect internal MySQL function and script (measure time, count of call, statistics) what you what. I did not figure out yet how to intersect… to play with it more and do some useful scripting to get profiling of MySQL. And it seems SystemTap can re-use DTrace probes available in…
