Taras,
Let me tell you how is this question relevant to your books library.
Firstly, i am making reference to bookslibrary and not VPS server based objects.
1) Given bookslibrary mysql db design, does bookid have a unique key index? Especially when the product is configured to treat Bookid as unique and not ISBN id as unique?
2) Which all columns would you recommend to have index to improve performance ? books_title, bookid, etc ?
My intention is to ensure that table scans are reduced by indexing any additional important fields which are searched on a regular basis.
Hope my queries are now pointing to bookslibrary software/db and look relevant.
Basically, your products successful implementation and use is our success and yours as well.
thanks,
parag