Fattylewis.com
Buy VPN

Newznab delete category

31 Jan 2015

My newnab+ install was running a little slow. Looking at the categories, it seems i had several hundred thousand releases in the “misc” and “PC 0-day” categories. As i dont use these, i figured a good start to speeding up the box was to empty both of these categories.

Heres is how i did it -

mysql> use newznab;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> delete from releases where categoryID like '8010';
Query OK, 78060 rows affected (2 min 1.46 sec)
mysql> delete from releases where categoryID like '4010';
Query OK, 131528 rows affected (15.50 sec)
mysql> exit;

I dumped this into a php script which is called by the screen_local script. For me, it would be ideal if this was run before NN had chance to process the misc files, just to save resource. This is something ill be looking at in the future though.

Figured someone else may find this handy!

Tweet me @fatty_lewis if you like this post.

Tweet
comments powered by Disqus