Performance of Sockets vs. TCP/IP connections on localhost?
Hi all! Simple question: What is fastest when doing a connection to a local machine? TCP/IP or connecting via the socket? the application is a ACL helper program under Squid which makes a persistent connection to the database (100 parallel programs runs on the machine each connecting to the MySQL database) Regards -- Lasse Laursen · VP, Hosting Technology NetGroup Processing Aps Phone: +45 3370 1526 · Fax: +45 3313 0066 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL and FreeBSD 5.x - Using LinuxThreads or not?
Hi all, We are about to upgrade one of our database servers to a Dual Xeon machine with HT. We have been testing FreeBSD 5.x for 6-7 months on a Uniprocessor box and we haven't had any problems with the platform. We would like to use FreeBSD 5 on our new database server since the SMP support is superior in the new release compared to the 4.x branch. I did some reading on the topic at Jeremy Zawodny's website: http://jeremy.zawodny.com/blog/archives/000697.html and he suggests that the best solution is to use LinuxThreads when compiling MySQL under FreeBSD. His initial article covered FreeBSD 4.x - http://jeremy.zawodny.com/blog/archives/000203.html Have any of you had any experience with stability/performance under FreeBSD 5.x and MySQL 4.0.x? Should the LinuxThread library still be used when compiling for maximum performance or has the problems been solved in Regards -- Lasse Laursen · VP, Hosting Technology · NetGroup A/S St. Kongensgade 40H · DK-1264 Copenhagen K, Denmark Phone: +45 3370 1526 · Fax: +45 3313 0066 - Don't be fooled by cheap finnish imitations - BSD is the One True Code -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Performance / Stresstest of MySQL
Hi, We are doing some optimization of our MySQL databases (tweaking the my.cnf file) to try to get better performance. We run MySQL 3.23.49 on a FreeBSD 4.5 machine and we are looking for some programs that can stresstest the servers. I have had a look at http://osdb.sourceforge.net/ but it doesn't seem to compile under FreeBSD. What kind of tests do you guys/girls perform to find the best configuration of your systems? Yours -- Lasse Laursen <[EMAIL PROTECTED]> - Systems Developer NetGroup A/S, St. Kongensgade 40H, DK-1264 København K, Denmark Phone: +45 3370 1526 - Fax: +45 3313 0066 - Web: www.netgroup.dk - We don't surf the net, we make the waves. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Performance Monitoring/Counters
Hi all, Which tools would you recommend to performance monitoring of a MySQL database server? I'm thinking of the following: System: CPU utilization, disk I/O. RDBMS: buffer cache hit ratio, transactions/sec, connections. Yours -- Lasse Laursen <[EMAIL PROTECTED]> - Systems Developer NetGroup A/S, St. Kongensgade 40H, DK-1264 København K, Denmark Phone: +45 3370 1526 - Fax: +45 3313 0066 - Web: www.netgroup.dk - We don't surf the net, we make the waves. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
