What do "key buffer size" and "total MyISAM indexes" unit sizes mean?

560

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.

Share:
560

Related videos on Youtube

brent
Author by

brent

Updated on September 18, 2022

Comments

  • brent
    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
    Joe Lloyd almost 9 years
    Thanks Wapac, It seems obvious that "M is Megabytes, K is Kilobytes," but I needed to be sure.
  • Wapac
    Wapac almost 9 years
    sure, no problem :)