Mint Forum

Oh guys. Help.

In the last month, Mint blew out my allocated MySql database allotment 3 times. As a result Media Temple automatically upgraded my site to a personal MySql container on my grid service. That is going to cost me an additional $20 a month. This is something my site revenue cannot support.

Does anyone know what to do? I have even followed cravemonkey’s advice and open a perpetual database connection. Somehow the drain is still there.

I did a MySql query and 3 instances all refer to mint visits as a bottle neck.

Urchin tells me that 77.3% Page Query comes from my mint directory.

Currently my mint is running the peppers: locations, user agents, feedburner, adsense

Can anyone help as if this is not going to work, I will have to drop the use of this great stats package and use Google’s (shock horror!)

Thanks in advance Lmr.

Hi Sam,

I get about 700-1K hits a day, 7-10K a week and about 35-45K a month.

Is that alot? I dont think so…can anyone else advice?

No probs Sam, however do you have this same issue with your MySQL blow out?

@lingmiester I don’t have any issues with Mint & (mt). My site is doing about ~500 hits a day without any problems.

@grettir I have two Mint installs on (mt) and both are still collecting data.

…and, of course, they weren’t foolish enough to start blocking Mint installs without notifying anyone.

Instead, I was foolish enough to improperly upgrade a pepper and then botch the basics when troubleshooting the problem.

I had the same problem with my host which isn’t MediaTemple. As soon as my visits hit about 750/hr, the database server would crash. The MySQL report showed mint_visit as a loced process, so I disabled mint. That took care of the problem. I’m now checking to see if I can run it without the third party peppers without crashing. Hopefully that will work.

Ren

BTW, I’m on MT.

My Durations Pepper can cause a lot of MySQL Queries if the preferences aren’t adjusted for the site.