+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
Coding Thread, Edugeek Database in Coding and Web Development; I have about 8GB installed on the server. I cant see anything in mysql or joomla that would allow me ...
  1. #16
    PEO
    PEO is offline
    PEO's Avatar
    Join Date
    Oct 2007
    Posts
    2,088
    Thank Post
    437
    Thanked 149 Times in 94 Posts
    Rep Power
    71
    I have about 8GB installed on the server. I cant see anything in mysql or joomla that would allow me to set min and max cache sizes so I am assuming it is all done auto magically

  2. #17

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    10,691
    Thank Post
    824
    Thanked 2,570 Times in 2,187 Posts
    Blog Entries
    9
    Rep Power
    731
    Quote Originally Posted by PEO View Post
    I have about 8GB installed on the server. I cant see anything in mysql or joomla that would allow me to set min and max cache sizes so I am assuming it is all done auto magically
    Looks like it is configurable in the mysqld service config, here are some guides:

    MySQL Server Memory Usage | MySQL Performance Blog
    MySQL :: MySQL 5.0 Reference Manual :: 7.5.8 How MySQL Uses Memory
    Troubleshooting Memory Usage - RimuHosting

  3. Thanks to SYNACK from:

    PEO (13th August 2009)

  4. #18

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    8,941
    Thank Post
    232
    Thanked 1,510 Times in 1,206 Posts
    Rep Power
    328
    All those numbers aside, I believe youtube uses MySQL, which goes to show how scaleable it really is.

    I know with MS SQL you can specify memory limits, but by default it will use as much as possible to speed everything up. I suspect MySQL behaves the same by default. Only on very large configurations you may need to tweak accordingly.
    A good example with MS SQL is when using Sims. It will quite easily use anywhere between 600MB to 1200MB with a server with 2GB of memory installed.
    Last edited by Michael; 13th August 2009 at 07:23 PM.

  5. Thanks to Michael from:

    PEO (13th August 2009)

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. [CLOSED] Misc: EduGeek Database Error
    By EduTech in forum EduGeek.net Site Problems
    Replies: 10
    Last Post: 15th May 2009, 01:57 AM
  2. EduGeek Blogs - Public or Private/EduGeek only?
    By mb2k01 in forum General Chat
    Replies: 4
    Last Post: 13th April 2009, 04:08 PM
  3. Is EduGeek faster since we moved the database? (Poll)
    By Dos_Box in forum Comments and Suggestions
    Replies: 25
    Last Post: 20th July 2007, 05:32 PM
  4. Moving the EduGeek Database
    By Ric_ in forum General EduGeek News/Announcements
    Replies: 28
    Last Post: 20th July 2007, 08:19 AM
  5. Replies: 4
    Last Post: 28th February 2007, 09:37 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •