Cleanup Big mongodb Collection

Recently i  have come across one small problem that i needed to fix. I had many records in a DB that i do not needed. I could not delete the entire collection, as i needed some of the records to be left alone. I have come up with this script, which allows me to delete records

sphinx mysql command line

I’ve been searched for a method on how to work using sphinx from console, I needed to access the interface in order to see what’s indexed, how is stored and  also test my searches. After my google searches i’ve ended up with this. mysql -h 127.0.0.1 –prompt ‘SphinxQL>’ –port 9312