mySql settings - IP Content very slow

[RLPVT]

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]

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]

It just seems the two numbers are way out wack from one to another

[Luis Manson]

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]

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]

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 :S

From 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]

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]

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]

Just run mysqltuner.pl or tuning-primer.sh and change the values to what they say. That's a good start!

[Marcher Technologies]

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]

Tried asking IPB and they had no solution and host company sees nothing wrong. I am reaching right now.

[Rhett]

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]

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.

[Rhett]

Is this a dedicated server?

[RLPVT]

No it's shared but I never have an issue with any other part responding slow other than content page

[Rhett]

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]

will ask again, are you using multiple htaccess files?