What do "key buffer size" and "total MyISAM indexes" unit sizes mean?
M is Megabytes, K is Kilobytes,
key_buffer_size is MySQL setting related to MyISAM engine
If you use InnoDB engine for all your tables, you need only small (but non-zero key_buffer_size), you need large innodb_buffer_pool_size.
I would highly recommend this web page as it gives simple answers to otherwise very complex thing, which MySQL optimization is. So, if you do not want to spend a lot of time and just configure it to something "relatively good". Go there.
Related videos on Youtube
brent
Updated on September 18, 2022Comments
-
brent over 1 year
I have built a website using React and am now using AWS-Amplify to host it. I am trying to setup Routes that redirect to static HTML files which are located in the
/public
directory. Everything works just fine when I test locally, but the Routes don't work after the site has been deployed.This is what I have for my Routes.
<BrowserRouter> <Routes> . . // Other unrelated Routes here.. . <Route path="/page1" render={() => {window.location.href="page1/index.html"}} /> <Route path="/page2" render={() => {window.location.href="page2/index.html"}} /> <Route path="/page3" render={() => {window.location.href="page3/index.html"}} /> </Routes> </BrowserRouter>
My rewrites and redirects setting for 200 (Rewrites) is currently:
</^[^.]+$|\.(?!(html|css|gif|ico|jpg|jpeg|js|png|PNG|txt|svg|woff|ttf|map|json)$)([^.]+$)/>
The console doesn't give any warnings or errors whenever I try to access these static HTML files from the deployed site, but a null page is loaded. Is there some settings I need to modify on my Amplify application? Thanks!
-
Joe Lloyd almost 9 yearsThanks Wapac, It seems obvious that "M is Megabytes, K is Kilobytes," but I needed to be sure.
-
Wapac almost 9 yearssure, no problem :)