Welcome, Register for free! or Login below:
EduGeek.net RSS Feeds Register FAQ Members Social Groups User Map Calendar Search Today's Posts Mark Forums Read

Go Back   EduGeek.net Forums > Coding and Web Development > Coding
Reply
 
LinkBack Thread Tools Search Thread
Old 13-08-2009, 07:13 PM   #16
PEO
 
PEO's Avatar
 
Join Date: Oct 2007
Posts: 1,803
uk uk england
Thanks: 343
Thanked 102 Times in 69 Posts
Rep Power: 43 PEO has much to be proud of PEO has much to be proud of PEO has much to be proud of PEO has much to be proud of PEO has much to be proud of PEO has much to be proud of PEO has much to be proud of PEO has much to be proud of
Default

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
  Reply With Quote
Old 13-08-2009, 07:16 PM   #17
 
SYNACK's Avatar
 
Join Date: Oct 2007
Location: Auckland, New Zealand
Posts: 3,282
new zealand
Thanks: 164
Thanked 811 Times in 669 Posts
Blog Entries: 4
Rep Power: 168 SYNACK ooh
SYNACK ooh SYNACK ooh SYNACK ooh SYNACK ooh SYNACK ooh SYNACK ooh SYNACK ooh SYNACK ooh SYNACK ooh SYNACK ooh SYNACK ooh
Send a message via MSN to SYNACK
Default

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
  Reply With Quote
Thanks to SYNACK from:
PEO (13-08-2009)
Old 13-08-2009, 07:20 PM   #18
 
Michael's Avatar
 
Join Date: Dec 2005
Location: Birmingham
Posts: 4,820
uk uk england
Thanks: 85
Thanked 681 Times in 519 Posts
Rep Power: 137 Michael ooh
Michael ooh Michael ooh Michael ooh Michael ooh Michael ooh Michael ooh
Default

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; 13-08-2009 at 07:23 PM..
  Reply With Quote
Thanks to Michael from:
PEO (13-08-2009)
Reply

EduGeek.net Forums > Coding and Web Development > Coding

Similar Threads
Thread Thread Starter Forum Replies Last Post
[CLOSED] Misc: EduGeek Database Error EduTech EduGeek.net Site Problems 10 15-05-2009 01:57 AM
EduGeek Blogs - Public or Private/EduGeek only? mb2k01 General Chat 4 13-04-2009 04:08 PM
Is EduGeek faster since we moved the database? (Poll) Dos_Box Comments and Suggestions 25 20-07-2007 05:32 PM
Moving the EduGeek Database Ric_ General EduGeek News/Announcements 28 20-07-2007 08:19 AM
Help - database corrupted 'Unrecognized database format' sidewinder Windows 4 28-02-2007 10:37 AM



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search Thread
Search Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:45 PM.
Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.
Copyright EduGeek.net




website uptime

© 2005 - 2009 EduGeek.net
SERVER: 4
no new posts