Hi
I am on Windows 10. Xampp 5.6.20
I tested the 5.0.1 development version which is the current dev tip. As you know I use the dev tip only in my production so I dont have the stable release 5.0.0 installed currently. I will install it for this and let you know how it performs on windows within next 48 hours (on or by 27th March)
Thanks
Arnab
hi @brady.miller, are you thinking that there’s something else in addition to the my.ini settings change noted above after testing and more fully described (probably overly) on issues in github ? thanks
Hi @stephenwaite , in 5.0.1-dev, there’a also been a lot of work with composer/autoloading so just wonder if that’s also a factor in the development codebase.
Will be nice to get some really specific recs on INNODB since guessing it’s just a couple settings that are really slowing things down (such as is here: https://itfirstaid.ca/server-optimization/ ; of course 1GB is a bit crazy to set but good to have it as focused as possible). Once this is settled, then will make sense to make a Optimize Speed wiki page which is linked to all the installation manuals describing the recommended INNODB settings in addition to anything else that will speed up OpenEMR (akin to the securing section, MU2 section, etc.).
Here’s the link to nice explanation by @stephenwaite on github regarding innodb settings:
Also, some good information on the innodb_buffer_pool_size (is set to 128MB by default in mysql, if not set) here:
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_buffer_pool_size
A good explanation of several settings to optimize innodb:
-brady
OpenEMR
Thanks for the links, https://itfirstaid.ca/server-optimization/ recommends using linux and deeming this post to be a windows slowness subject, maybe i’ll change the title…
the mysql refman states that 128MB is the default but when leave that option out in the my.ini i see 8MB in phpmyadmin->information_shema->innodb_pool_stats so maybe XAMPP->MYSQL (which is mariadb actually) is using some other setting which i have yet to find
the last link is the most informative and worth a read
it’s probably not true that anyone is running a system like the one that the my.ini shipped in the bundled version
“This is for a system with little memory (<= 64M) where MySQL is only used from time to time and it’s important that the mysqld daemon doesn’t use much resources”
hi,
The defaulting to 8MB is interesting and is crazy low; even more interesting that the setting appears to be buried somewhere(as an aside mariadb also defaults to 128mb so not a mariadb issue). After we get the settings hammered out, we can then place them on the wiki (and refer from the install manuals) and will use them when release the next xampp package (although this will likely be using a more modern version such as 7.0 which will likely not have the 8MB default or at least one would hope it wouldn’t).
-brady
removed, my.ini, ran sql query on mysql database and it shows the defaults, not sure what we actually need in a my.ini that would be pertinent to openemr
Do you mean that after removing the my.ini file, that the innodb_buffer_pool_size defaults to 128M (or still 8M)?
Hi.
I just realized that it would also be easy to make an updated xampp-openemr package once we have suggested mods for the the my.ini file(since is by far the most popular download, it makes a lot of sense). All it would take is unzip, modify the my.ini file, zip back up (and add a -2 to the end of the filename portion of the new zip file).
-brady
128M, thanks, might have been looking in the wrong place and the wrong setting. thinking that they are all under the mysql database and plan to investigate a little more
Just checked out that in openemr if we keep the passive reminders close, the things are a bit faster. The passive reminders take a lot of time to load and process. Cant it be made a bit faster?
After changing the my.ini file as suggested in a previous post, the openemr is definitely faster than before. Another observation is, openemr is faster in firefox than in chrome
To confirm, will it make sense to release a new openemr5/xampp package that simply has the my.ini file removed?
-brady
my vote is yes
Hi Brady,
Do we need to remove my.ini file or we need to modify it as given above.
Modification made my openemr in windows work great
Regards
Arnab
Hi @arnabnaha ,
Would be more ideal to modify it. Is there a way you could copy/paste exactly what you have in your my.ini file now. Then I’ll rebuild the xammp/openemr package with that my.ini file.
-brady
Hi brady,
I am emailing you the my.ini file i have. Hope it helps you!
Thanks and regards,
Arnab
Planned changes making on the xampp default my.ini for recording purposes:
An odd thing I noted but did not change is that the key_buffer is used rather than key_buffer_size (this is myisam specific, so didn’t touch this, though)
Hi,
I just released a new xampp/openemr 5.0.0 package with the registration bug fix and changes to mysql settings(see above post for exact setting changes). Please test and let me know if the speed is improved.
thanks,
-brady
Some very nice tips for speed optimization can be found on this thread:
In addition to Brady’s suggestion which are great, I think I have found the solution that makes continuing to use windows viable instead of frustrating. Others may not like to here this but it basically involves a new faster computer. A 10th generation I7 processor, 8GB of ram and a SSD hard drive and the speed issue seems to vanish.