Mint Forum

I have a standard gridserver account with (mt). they now want to charge me an extra $20/month because they claim that my MySQL usage doesn’t work for them. They’re complaining about one line in the report:

44 Hit:Insert 0.18:1

And the explanation from their Run MySQL Report function:

The other ratio is Hit:Insert. This ratio indicates QC effectiveness. Ideally, the MySQL server should insert a bunch of stable queries into the QC, then get a lot more hits on them. Therefore, this ratio should be heavy on the hit side if the QC is effective. If it is heavy on the insert side, then the QC is not really helping much and it is probably too volatile. Consider a Hit:Insert ratio of 1:1. This practically means that a cached result is only used once before it is replaced. This completely defeats the idea of a query cache. A worse ratio, like 0.34:1, indicates that some results are not even hit before they are pruned or replaced.

My site really doesn’t get that many hits but Mint looks to be the culprit. I contacted (mt) technical support asking if I should stop using mint.

(mt) said this: I have rebooted your container just now. In our experience MINT does indeed cause many problems with sites running in the SmartPool v.2, so this will most likely resolve your issues.

So their response is that I should stop using mint? That doesn’t seem good, particularly about a site that’s “in partnership” with them, whatever that means.

Can anyone offer advice as to how to clear this up and continue using mint? Something I can configure either in mint or (in the limited way that I have access to) in mysql?

I don’t want to go back to google analytics but neither do I want to pay $20 more a month just to deal with a query cache issue on a site that gets, at best, 2500 hits a day (fairly evenly distributed).

Help!

And thanks!

Thank you for the reply! I, too, was amazed. It’s certainly possible that Pepper is the issue. Installed and running are:

Default Backup/Restore Trends iPhone Outbound Fresh View Referrer Rollup User Agent 007 Parsel Popupdaytime Download Counter

I wish I knew more about how to debug the situation on my own, but I’m at a loss as to where to begin.

Suggestions?

It looks like the Secret Crush Pepper might be the culprit on the first query (but that query is only run when expand a specific visit). The second query would appear to be something from the Searches pane of the Default Pepper but I can’t find that query in the source code. In both cases !='XXX' XXX is always an empty string so maybe it isn’t those Pepper responsible for those queries.

Try turning off “Stagger pane loading” in your Preferences and then adding ?benchmark to your Mint url. The Mint Benchmarks that appear below the footer will tell you which Pepper pane’s queries are taking the most time. (Only the tabs that are active onload are displayed in the Benchmarks so if you change tabs and want to see how long the query took you will have to reload the entire Mint interface after changing the tab.)

Hi tjtjt!

I realise I have the exact same issue, and MT has pumped my MySql container.

Shuan, I think this is a serious issue, particular if MT is your partner. I also get the same list of slow querys as tjtjt.

Can you advice? I might have to toss my Mint installation as well.

Here is the link to my problem: haveamint.com/forum/troubleshooting/143 … ediatemple

I assumed you had Secret Crush installed based on the problem queries you provided (they seemed closest to Secret Crush queries). I would recommend uninstalling third-party Pepper and seeing what (mt) has to say (if anything).

Here’s what I think is the problem: (mt)’s grid servers are optimized for reading from the database but Mint is constantly writing to the database. You can’t cache INSERTs and its hard to cache SELECTs when the database is constantly being updated.

As far as “in partnership” goes, that means that I use their hosting. There is very little coordination beyond that.

Same problem here and looking for a solution. I haven’t had a chance to try and figure the problem out so I opted to just let my hosting charges increase by $20. I’d like to call them and get it back down to the normal fee, obviously.

Using MT here as well.

I use Grid noticed some peppers like Durations kit performance pretty hard. I run with Secret Crush and it is clear if you turn staggered loading on that it is the long pole in the tent from a latency perspective.

I have noticed the mint include hits for 750ms of load time and removing secret crush doesn’t improve this.

With regard to the Durations pepper, do NOT install it. It is poorly written and will hit your server every 15 seconds FOREVER as long as someone’s browser is open to your site. My server was getting killed and Dreamhost discovered that “recalc.php” (one of the Duration pepper’s files) was getting hit 800,000 TIMES A DAY (my site only does about 5,000 pageviews a day).

Here’s the worst part, however: even after you completely remove the pepper, your site continues to get pounded by any computers which still have your site open. It’s now been 5 days since I removed this pepper and my site is still getting pounded. I guess people like to keep sites open in tabs for days.

I contacted the developer of this pepper and his only response was that it’s not meant for high-traffic sites and that I should change the defaults. Too late for that. Stay away from this pepper, at least until it’s rewritten.

I’m looking at a $250 dollar hosting charge this month and I think it’s due to the durations pepper.

Is there ANYTHING that can be done to resolve this issue? I’ve completely uninstalled Mint and deleted all files and code from my WP install.

From this thread I’m understanding that as long as it’s cached in people’s browsers I’m going to continue getting charged.

Is this the case. And, again, is there anything at all that can be done?

I simply don’t have the resources for hosting fees like this, but I certainly don’t want to shut down my site.

Thank you all for your help.

Things you don’t understand, are not automatically “poorly written”.,it really true….

Buy WoW Gold Buy World of Warcraft Gold MapleStory Mesos