RLPVT Posted August 30, 2012 Posted August 30, 2012 Based one some threads I have read that I may have a setting out of whack and this may be causing my IP Content to be really slow. Can someone confirm if this is way out of wack and if I Need to change something? max_heap_table_size 268435456 max_tmp_tables 8192 I took this right from the "Show Variables" command in mysql This seems WAY out of wack to me. Could this be why I am having such delays on my IP Content? The forum runs fine though. If this is incorrect then is there a command to run to set these? hanks
Luis Manson Posted August 30, 2012 Posted August 30, 2012 why dont you profile the code? i had a weird problem with ipc and thid that. it showed me in how long it took earch function to complete :)
RLPVT Posted August 30, 2012 Author Posted August 30, 2012 It just seems the two numbers are way out wack from one to another
Luis Manson Posted August 31, 2012 Posted August 31, 2012 im not sure if ipc uses temp tables for this, but there is something weird with those valuse, why dont you try tuning-primer to see what sugest?
Grumpy Posted September 1, 2012 Posted September 1, 2012 256 MB temp table size and you can have 8192 tables. What's so strange about it? Most of IP.C's content's tables contain blobs/texts. So, they don't touch the tmp tables anyway.
Luis Manson Posted September 1, 2012 Posted September 1, 2012 256 MB temp table size and you can have 8192 tables. What's so strange about it? Most of IP.C's content's tables contain blobs/texts. So, they don't touch the tmp tables anyway. Thanks i confused myself and the op :SFrom MySQL manual:max_heap_table_size This variable sets the maximum size to which user-created MEMORY tables are permitted to grow.max_tmp_tables The maximum number of temporary tables a client can keep open at the same time. (This variable does not yet do anything.)
RLPVT Posted September 3, 2012 Author Posted September 3, 2012 Some folks on another thread said tuner suggested making changes, I wanted to just see if anyone directly involved with IP Content would have a suggestion. Ever since I had it installed the forums are perfect and no issues, IP Content still runs slow and when I try to go from the forums back to the page it will take anywhere from 5 to 10 seconds to respond in almost all cases, Since it is my home page kind of irritating. I have opend tickets and still no luck. Thought someone might have an answer.
Dmacleo Posted September 3, 2012 Posted September 3, 2012 if going from some other site to your content page (what is url?) is it fast while going from forums index to content page slower? I have seen such on mine, getting rid of htaccess helped me a bit and if you have multiple htaccess that also slows it.
tomturd2 Posted September 3, 2012 Posted September 3, 2012 Just run mysqltuner.pl or tuning-primer.sh and change the values to what they say. That's a good start!
Marcher Technologies Posted September 3, 2012 Posted September 3, 2012 Some folks on another thread said tuner suggested making changes, I wanted to just see if anyone directly involved with IP Content would have a suggestion. Ever since I had it installed the forums are perfect and no issues, IP Content still runs slow and when I try to go from the forums back to the page it will take anywhere from 5 to 10 seconds to respond in almost all cases, Since it is my home page kind of irritating. I have opend tickets and still no luck. Thought someone might have an answer. Rob, I'm going to tell you the same thing I told you over a year ago, get a sys admin to look at your system directly, do not take random advice, worse yet from a script I have personally seen give horrible recommendations regarding mysql tuning, until you do have such an individual look directly at your server, you are shooting blind... I will see if I can hound Rhett or Gary over there for you. You need a sysadmin, which I am not, nor claim to be, to do a run-down of your configs, finetune, and test the results thereof if you want factual resolution, not the guess-timations of any random individual willing to respond here. Hopefully you will listen this time.
RLPVT Posted September 3, 2012 Author Posted September 3, 2012 Tried asking IPB and they had no solution and host company sees nothing wrong. I am reaching right now.
Rhett Posted September 3, 2012 Posted September 3, 2012 I'm seeing about 3 seconds loading your content page and about 2 seconds loading your forums, with the number of queries that you have on your content page, this seems about right. Can you explain where you are seeing the differences in loading times? Thank you
RLPVT Posted September 3, 2012 Author Posted September 3, 2012 from the forums. Stay on the page in the forum and got to the home after a few minutes and it takes forever but this delay issue does seen to be intermittent. Marcher has seen so he knows what I am referring too.
RLPVT Posted September 4, 2012 Author Posted September 4, 2012 No it's shared but I never have an issue with any other part responding slow other than content page
Rhett Posted September 4, 2012 Posted September 4, 2012 No it's shared but I never have an issue with any other part responding slow other than content page Ahhh all makes sense now... shared hosting on a typical host will have anywhere from hundreds to thousands of sites on the same server, when troubleshooting items like this, it's nearly impossible to come up with any outcome, as each and every site on the server will effect your performance. there are too many factors at play with shared hosting in most cases to even spend 5 minutes on it. It's like shooting in the dark as anything you do or nothing you do can show different results each and every time. If you are having trouble, I would suggest finding a better hosting solution, the randomness of this issue fits perfectly into it not being your site at all.
Dmacleo Posted September 4, 2012 Posted September 4, 2012 will ask again, are you using multiple htaccess files?
Recommended Posts
Archived
This topic is now archived and is closed to further replies.