Go Back   vb.org Archive > Community Discussions > Forum and Server Management
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 04-25-2010, 02:03 AM
swiftor's Avatar
swiftor swiftor is offline
 
Join Date: Nov 2008
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Optimal PHP Memory Limit and MySQL Packet Size?

A friend of mines vb4 install is way faster than mine, even though we have similar traffic and hosts.

I did noticed that on his admin page he had different settings for his PHP memory limit and so on. The below are mine, do any seem like they may be hindering performance?

Web Server Apache v2.2.14
PHP 5.3.1
PHP Max Post Size 64.00 MB
PHP Maximum Upload Size 64.00 MB
PHP Memory Limit 64.00 MB
MySQL Version 5.0.90-community-log
MySQL Packet Size 16.00 MB

Thanks!
Reply With Quote
  #2  
Old 04-25-2010, 11:53 PM
Angel-Wings's Avatar
Angel-Wings Angel-Wings is offline
 
Join Date: Sep 2007
Posts: 206
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

These values are a bit high - aren't they ?

PHP Max Post Size 64.00 MB
PHP Maximum Upload Size 64.00 MB

64 MB uploads ?

But except these values, do you use the same OS with the same MySQL & Apache configuration on the same hardware with the same Addons to really have data to compare ?

May be the other MySQL DB is configured different or Apache
Reply With Quote
  #3  
Old 04-26-2010, 12:01 AM
swiftor's Avatar
swiftor swiftor is offline
 
Join Date: Nov 2008
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That I'm not sure about. It was another colleague who had setup these values I believe.

Is having those values too high going to harm performance?
Reply With Quote
  #4  
Old 04-26-2010, 09:51 AM
Angel-Wings's Avatar
Angel-Wings Angel-Wings is offline
 
Join Date: Sep 2007
Posts: 206
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well, you may waste resources you might need somewhere else.

I've a max_post_size of 5 MB, max_file_upload of 4 MB since the largest possible attachement I allow is 3.5 MB.

Still, except these values, don't forget your Webserver and Database - also Firewalls might give some performance impact while being useless in the most cases
Reply With Quote
  #5  
Old 04-26-2010, 10:59 AM
swiftor's Avatar
swiftor swiftor is offline
 
Join Date: Nov 2008
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks! I'll see about toning down those numbers.
Reply With Quote
  #6  
Old 05-19-2010, 03:21 PM
walt59 walt59 is offline
 
Join Date: Nov 2009
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Swiftor,

Are you a shared, vps, or dedicated server?

Thanks,

Walt
Reply With Quote
  #7  
Old 05-19-2010, 03:33 PM
swiftor's Avatar
swiftor swiftor is offline
 
Join Date: Nov 2008
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I recently transitioned to a dedicated server, but did not adjust my settings
Reply With Quote
  #8  
Old 05-19-2010, 07:06 PM
walt59 walt59 is offline
 
Join Date: Nov 2009
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks!
Reply With Quote
  #9  
Old 08-03-2010, 05:17 AM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Angel-Wings View Post
Well, you may waste resources you might need somewhere else.

I've a max_post_size of 5 MB, max_file_upload of 4 MB since the largest possible attachement I allow is 3.5 MB.

Still, except these values, don't forget your Webserver and Database - also Firewalls might give some performance impact while being useless in the most cases
Where do you set the "largest possible attachement" size at?
Reply With Quote
  #10  
Old 08-03-2010, 07:37 AM
Angel-Wings's Avatar
Angel-Wings Angel-Wings is offline
 
Join Date: Sep 2007
Posts: 206
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Boofo View Post
Where do you set the "largest possible attachement" size at?
Usergroup Options & Attachment Manager in the Admin Panel
Reply With Quote
Reply


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

Forum Jump


All times are GMT. The time now is 11:14 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04530 seconds
  • Memory Usage 2,247KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete