Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MySQL abuse/overload


h4x0r

Recommended Posts

Hey guys, been running into a problem on a new host...something is causing excessive use on the mysql server and I'm about to get suspended if I can't get this resolved. I'm a little worried about the indexing of my products and have included a link to a screen shot of my products table from phpmyadmin...I circled in red what I am worried about...should my cardinality for idx_products_date_added be that low? I would have thought it would be the same as PRIMARY. I'm not a mysql genius so I'm not entirely sure if this is correct or not.

http://rhino-technologies.com/index.JPG

 

I have already checked and optimized every table in my db...any thoughts or suggestions here would be GREATLY appreciated!

Link to comment
Share on other sites

bump...

 

anyone? thoughts? suggestions?

 

 

http://www.oscommerce.com/forums/lofiversion/i...hp?t209264.html

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

Yes, thank you for that useful, albeit utterly off topic, response. Isn't there be a newb forum you should be trolling? It's just rather presumptuous to lump my thread in with 'help vampires.' Figuring as how I've already searched this forum and google for info on my subject matter, as well as currently looking at the mysql docs so as to better educate myself on the matter, I would say that responses such as yours are a greater detriment to the online community than some of these 'vampires.' Aside from that, I've only bumped this thread once per day. If you have suggestions on a way I could rephrase what I'm asking or ideas on details I have unknowingly left out then I will gladly do my best to include them. Otherwise unless you actually have some way of contributing in a beneficial method, then stop trolling and GTFO of my thread.

Link to comment
Share on other sites

It`s your attitude thats gets you the vampire 'tag', tutting just because you don't gat an answer strait away!! You abviously think that we're obliged to answer your query. 'I've only bumped this thread once per day' you should`nt bump at all, you should take the time to ask yourself, why has no-one answered me, what have I missed/not done?

 

If you had bothered to read the many post on this topic you would already know what extra info is required, but no you think we should do that for you.

 

We cant read your mind or have access to your code, so if you don`t provide all the info that might be needed you wont get an answer.

 

NB. Swearing only gets you banned.

 

:angry:

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

Your attitude stinks - that's why you haven't been getting a helpful response.

 

But I'll give you a little hint. In osCommerce admin you have "Display Category Counts" turned on - which relates to cataloging and displaying the number of products in a category alongside the category name. You've got roughly 8000 products, so each time someone loads a page a sql query has to be made which returns a record of the number of those products. That's why your MySQL Query count is so high.

 

For future reference look for the thread "A Store Speed Optimisation In Progress", which tells you this and more about how to reduce unnecessary MySQL queries.

 

Vger

Link to comment
Share on other sites

I won't try to justify my attitude...I know my response was charged. I'm just fed up with unhelpful responses such as that. While that article was good and all that, it comes from an idealistic elitist mentality. This is a support forum and as long as they exist, you're going to end up with people who ask stupid questions or want someone else to do their work for them. Yes, those people are frustrating to deal with, but as long as there is a a 'support' forum then they will always be there.

 

@Spooks: I didn't think I was asking anyone to do my work for me...I didn't think I was demanding a response. In hindsight I could probably have titled my thread a little differently. Yet, Spooks, this is twice in my thread that you have made grave assumptions about what I have or have not done. I already mentioned that I searched through the forum and google...most likely, I'm not using the correct search phrases otherwise I would have run into this whole slew of posts you're referring to. I'm probably not able to find them because I don't know -exactly- what it is I should be searching for. Originally I had asked about indexing and whether or not there was a discrepancy between my indexes...I even included a screenshot to show what I was talking about. I was NOT asking whether or not any certain code was or was not correct otherwise I would have included it... I really did try to include what I thought was relevant to the question I was asking.

 

@Vger: Thank you for at least pointing me in a direction. It is much more helpful just having an idea of where to look.

Link to comment
Share on other sites

Tip - Searching these forums!

 

1. The Forums' own Search facility is total pap.

 

2. Searching Google for the phrase you are trying to find is no good - too many results.

 

3. Answer = whilst on the forum input the search phrase into the Google search box in the Google Toolbar, and then click on the link to "Search only on www.oscommerce.com/forums."

 

4. That way the results you get will be relevant to what you want to find out.

 

Vger

Link to comment
Share on other sites

Ahhh, I don't use tool bars in my browsers...too much clutter imo. However, using the same principle I could just run a google search using a 'site:http://www.oscommerce.com/forums' prefix.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...