{"comment":{"url":"https://api.github.com/repos/following5/okapi/comments/15779832","html_url":"https://github.com/following5/okapi/commit/58d3e2964fcdbd3d62d2840e8270b4c2729d93b2#commitcomment-15779832","id":15779832,"user":{"login":"following5","id":1614754,"avatar_url":"https://avatars.githubusercontent.com/u/1614754?v=3","gravatar_id":"","url":"https://api.github.com/users/following5","html_url":"https://github.com/following5","followers_url":"https://api.github.com/users/following5/followers","following_url":"https://api.github.com/users/following5/following{/other_user}","gists_url":"https://api.github.com/users/following5/gists{/gist_id}","starred_url":"https://api.github.com/users/following5/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/following5/subscriptions","organizations_url":"https://api.github.com/users/following5/orgs","repos_url":"https://api.github.com/users/following5/repos","events_url":"https://api.github.com/users/following5/events{/privacy}","received_events_url":"https://api.github.com/users/following5/received_events","type":"User","site_admin":false},"position":32,"line":91,"path":"okapi/services/caches/search/nearest.php","commit_id":"58d3e2964fcdbd3d62d2840e8270b4c2729d93b2","created_at":"2016-01-30T12:49:51Z","updated_at":"2016-01-30T12:49:51Z","body":"My experience with the migration from MySQL 5.1 to MariaDB 5.5 is that we cannot rely on how the server optimizes the SQLs.There was a statement which was running 100 times slower on MariaDB because the server chose another index. So I prefer to separate this from the where_conds."}}