administrators

Impersonation only works when running as a service, won't work at login since it runs under that users context.

You could also just try increasing the max connections.

In the my.ini file just add something like
max_connections = 1024

you can check the existing max_connections with a query:
SHOW VARIABLES LIKE "max_connections";

Not really sure what else to try. You could try adding the following to your connection string in web.config for the clientapi to try and close connections faster.

ConnectionIdleTimeout=5

<add name="toems" connectionString="server=localhost;port=3306;database=theopenem;Uid=root;Pwd=password;Allow User Variables=True; ConnectionIdleTimeout=5;" providerName="MySql.Data.MySqlClient" />

or disable pooling

Pooling=false

<add name="toems" connectionString="server=localhost;port=3306;database=theopenem;Uid=root;Pwd=password;Allow User Variables=True; Pooling=false;" providerName="MySql.Data.MySqlClient" />

Sorry, that is beyond the scope of Theopenem and is not available.

There wouldn't be any way to do this currently. The next version will provide a way to write your own SQL queries.

You need to create an image cleanup policy.
https://youtu.be/ZmMzStsFnEI?t=1269

Alternatively when using the image prep tool, just uncheck the Enable WinLogon Finalizing Background option.

I would start by increasing the memory available to Mariadb. You want it to be about 80% of your available memory to get as much of the working set into memory as possible.

In c:\program files\mariadb\data\my.ini
Change or add this line.
innodb_buffer_pool_size=12GB

make sure it's under the [mysqld] section and not the [client] section.

Then restart mariadb service.

Thanks. 1.5.7 is behind schedule it's shaping up to be much larger than anticipated and facing some challenges. It's probably still a couple months away. Mainly just going through the forum and implementing suggestions.

Definitely not want you want to do. You probably just need to create boot files in admin settings->pxe-> global boot menu, also in pxe settings select the correct bootloader and click update, that will copy the correct files to the correct location.

Yes, just copy the images folder from the old to the new, but you will need manually recreate the images in the webui, using the same name.