Run this MYSQL:
SHOW STATUS LIKE 'threads_connected';
Run this on production to see how many connections on average are used on your production database.
Then run this on your box where you're testing load with jmeter to help you match the same amount of activity in your load test.
Finding duplicates in a MYSQL table
select name, count(name) as cnt from term_data group by name having cnt > 1 order by cnt;
My new mac and I love this list of workarounds. Thanks folks.
on my mac I did:
cd /tmp ln -s /usr/local/zend/mysql/tmp/mysql.sock mysql.sock (sometimes this link gets deleted and I have to recreate it -- I will try to protect it with unix permissions)
This lets you type mysql from the terminal and login to mysql that way.
Then I did: