Go back to fronty page View most popular entries View latest additions Submit tutorials to UnixTutorials.info
UnixTutorials logo

Search results for Optimizing DSPAM + MySQL 4.1

Unix+clones Optimizing DSPAM + MySQL 4.1
Post date: April 2, 2006, 18:04 Category: Optimizing Views: 16
Tutorial quote: DSPAM is a scalable and open-source content-based spam filter designed for multi-user enterprise systems. It's great at filtering out spam but on busy mailservers the pruning of the MySQL databases takes way too long time ...
Unix+clones Optimizing C/C++ programs using the GProf profiler
Post date: May 24, 2005, 14:05 Category: Optimizing Views: 68
Tutorial quote: One of the most important things to keep in mind while optimizing an application is: optimize where it counts. It is no use to spend hours optimizing a piece of code that usually runs for only 0.04 seconds anyway.

GProf provides a surprisingly easy way to profile your C/C++ application and spot the interesting pieces right away. A small case study shows how GProf was used to reduce the running time of a real-world application from over 3 minutes to under 5 seconds, by identifying 2 data structures as important and optimizing those.

Historically, the program goes back as far as 1982, when it was introduced on the the SIGPLAN Symposium on Compiler Construction. It is now a standard tool available on virtually all flavors of UNIX.
Debian How To Set Up A Load-Balanced MySQL Cluster
Post date: March 31, 2006, 14:03 Category: Software Views: 12
Tutorial quote: This tutorial shows how to configure a MySQL 5 cluster with three nodes: two storage nodes and one management node. This cluster is load-balanced by a high-availability load balancer that in fact has two nodes that use the Ultra Monkey package which provides heartbeat (for checking if the other node is still alive) and ldirectord (to split up the requests to the nodes of the MySQL cluster).

In this document I use Debian Sarge for all nodes. Therefore the setup might differ a bit for other distributions. The MySQL version I use in this setup is 5.0.19. If you do not want to use MySQL 5, you can use MySQL 4.1 as well, although I haven't tested it.

This howto is meant as a practical guide; it does not cover the theoretical backgrounds. They are treated in a lot of other documents in the web.
Gentoo PureFTPD with MySQL Auth + MyPhpAdmin
Post date: June 11, 2005, 04:06 Category: Network Views: 155
Tutorial quote: Simple guide on how to setup Pure-FTPD on Gentoo with MySQL authorization.
OSX Optimizing Mac OS X performance
Post date: January 18, 2006, 11:01 Category: Optimizing Views: 58
Tutorial quote: This FAQ provides recommendations for optimizing MacŪ OS X performance. Additionally, it provides advice and links to advice for troubleshooting certain Mac OS X performance problems.
Gentoo Apache with mpm-worker + PHP 5 + SSL + MySQL 4.1
Post date: June 5, 2005, 18:06 Category: Network Views: 125
Tutorial quote: We can do Apache 2 with mpm-worker with PHP 5, along with SSL and MySQL 4.1. I tested my configuration with Apache 2.0.53, PHP 5.0.4, and MySQL 4.1.11.
Unix+clones How To Set Up Database Replication In MySQL
Post date: December 14, 2005, 14:12 Category: Software Views: 80
Tutorial quote: This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures though.

In this tutorial I will show how to replicate the database exampledb from the master with the IP address 192.168.0.100 to a slave. Both systems (master and slave) are running Debian Sarge; however, the configuration should apply to almost all distributions with little or no modification.
RedHat Tips & tricks: Performance tuning
Post date: November 25, 2005, 19:11 Category: Optimizing Views: 134
Tutorial quote: Advanced tips on optimizing your Red Hat server.
Unix+clones Using MySQL to benchmark OS performance
Post date: April 12, 2005, 03:04 Category: Benchmarks Views: 92
Tutorial quote: It seems to be an exciting time for *nix operating systems, with a number of them recently releasing new versions that bring the addition of expanded features and claims of improved performance. If you're using GNU/Linux, OpenBSD, NetBSD, FreeBSD, or Solaris as a database server, you've probably recently considered an upgrade or switch to another OS in that list due to marketing hype and hearsay. This article will show you how to benchmark operating system performance using MySQL on these OSes so you can find out for yourself if you're missing out. While this may not necessarily be indicative of overall system performance or overall database application performance, it will tell you specifically how well MySQL performs on your platform.

The following operating systems were used for the comparison testing:
- FreeBSD 4.11
- FreeBSD 5.3
- NetBSD 2.0
- Linux 2.6
- Linux 2.4
- Solaris 10 x86 (build 69)
- OpenBSD 3.6
Unix+clones Comparing MySQL performance
Post date: April 12, 2005, 03:04 Category: Benchmarks Views: 56
Tutorial quote: With the introduction of the 2.6 Linux kernel, FreeBSD-5-STABLE, Solaris 10, and now NetBSD 2.0, you might be wondering which of them offers superior database performance. In my previous article, I discussed the tools I chose to test these venerable operating systems and the methodology by which they were tested. The result is this MySQL performance comparison between OpenBSD 3.6; NetBSD 2.0; FreeBSD 5.3 and 4.10; Solaris Express (build 69); and Linux 2.4 and 2.6 (Gentoo-based). Read on for the results.