Home > Tracking Campaigns > CPV Lab Pro

CPVLab Database Optimizations – Advanced Tips (5)

08-22-2013 08:43 AM #1 andy_d (Veteran Member)
CPVLab Database Optimizations – Advanced Tips

So...

Finally found a moment to bash something useful out and put it on my blog.

I realize the legendary caurmen posted something similar to this, and I only just noticed now lol, but this is more tailored to CPVLab and something I've just started using personally.

Feel free to chime in and make suggestions to improve my post, I highly doubt it's complete, but I feel like it's a good start.

http://fitaffiliate.com/2013/08/cpvl...mization-pt-2/

08-22-2013 11:03 AM #2 caurmen (Administrator)

Good stuff! Definitely agreed on the innodb_buffer_size issue - that's key for innodb tuning. Be careful you don't set it too high, though - setting it high enough that your machine starts using swap (in other words, running out of memory) can be Real Bad.

Here's a great article on that (although pretty hardcore): http://www.mysqlperformanceblog.com/...fer_pool_size/

I'd strongly recommend running a MySQL tuning script too - they're really good these days.

08-22-2013 12:15 PM #3 peanut (Member)

Hey Andy, I needed this article. CPVlab is really pain in the ass when you start increasing volume.

The interesting fact is that CPVlab on starter package at BH works faster than on 1Gb or even on 2Gb. I'm on 4Gb RAM now and will try to set innodb_buffer_pool_size to 2Gb; probably it makes a difference.

Have two more questions to you.

1. What is the max CPVlab database size you're feeling comfortable with? Atm mine is ca.300 Mb (after clearance according to your part 1)

2. How do you reactivate/ get stats from old (removed from the main db) camaigns? Do you keep them in CSV files or just launch a database backup somehow?

08-22-2013 05:45 PM #4 andy_d (Veteran Member)

Quote Originally Posted by peanut View Post
Hey Andy, I needed this article. CPVlab is really pain in the ass when you start increasing volume.

The interesting fact is that CPVlab on starter package at BH works faster than on 1Gb or even on 2Gb. I'm on 4Gb RAM now and will try to set innodb_buffer_pool_size to 2Gb; probably it makes a difference.

Have two more questions to you.

1. What is the max CPVlab database size you're feeling comfortable with? Atm mine is ca.300 Mb (after clearance according to your part 1)

2. How do you reactivate/ get stats from old (removed from the main db) camaigns? Do you keep them in CSV files or just launch a database backup somehow?

Hey bud..


Indeed, as caurmen said, just make sure not to increase your buffer size too much. I have 5gb machine at knownhost now which I'm slowly migrating over to and I set my buffer size to 2gb.. so I still have 3gb left for other processes. I basically wanted a machine capable of having a large enough buffer but with plenty of room to breath.


1. What is the max CPVlab database size you're feeling comfortable with? Atm mine is ca.300 Mb (after clearance according to your part 1)

Depends on the server you operate on. I honestly don't like my clicks database getting over 3-400MB but that's based off my performance on a 2gb BH setup. Things may still perform fine on my new server with more data. Obviously the more powerful the server the more it can handle. It's really a case-by-case basis.

Regarding backups, your best bet is to export to CSV, all of your data to a safe place before making the back up. Unfortunately I have no elegant way of going back and viewing this data, perhaps this is something for the CPVLab team to develop, or perhaps an opportunity to develop a tool to help with this..

08-22-2013 07:17 PM #5 peanut (Member)

Quote Originally Posted by andy_d View Post
Hey bud..

... perhaps this is something for the CPVLab team to develop, or perhaps an opportunity to develop a tool to help with this..
Exactly, they need to develop an addon to review backup files. I was asking CPVlab guys regarding possibility to open backup databases via local CPVlab copy installed on local machine with PHPmyAdmin and without internet access but they say I need to buy an additional license to do that...

Home > Tracking Campaigns > CPV Lab Pro