Can indexes be stored in Mysql

General discussion related to "Everything".
Post Reply
winxsj
Posts: 2
Joined: Sun Jan 02, 2022 1:48 am

Can indexes be stored in Mysql

Post by winxsj »

Searching through the ETP server for multiple users with a large number of files will lag and even cause server crashes when sorting.
NotNull
Posts: 5458
Joined: Wed May 24, 2017 9:22 pm

Re: Can indexes be stored in Mysql

Post by NotNull »

Everything can take up quite a bit of RAM (roughly 100 bytes per file/folder, so 20 million files/folders will use 2GB RAM) as the entire database will be loaded into memory.
Does your server have enough free RAM for that?
void
Developer
Posts: 16680
Joined: Fri Oct 16, 2009 11:31 pm

Re: Can indexes be stored in Mysql

Post by void »

I will consider a SQL backend for Everything.
Thanks for the suggestion.


Fow now, please make sure you are indexing all information and have fast sort enabled for all properties:
  • On your Server, in Everytihng, from the Tools menu, click Options.
  • Click the Indexes tab on the left.
  • Check Index file size.
  • Check Index folder size.
  • Check Index date created.
  • Check Index date modified.
  • Check Index attributes.
  • Check Fast size sort.
  • Check Fast date modified sort.
  • Check Fast date created sort.
  • Check Fast attribute sort.
  • Check Fast path sort.
  • Check Fast extension sort.
  • Click OK.

If Everything is crashing, please send a mini crash dump to support@voidtools.com

An Everything Server is in development.
Post Reply