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

Search results for Comparing MySQL performance

Unix+clones Comparing MySQL performance
Post date: April 12, 2005, 03:04 Category: Benchmarks Views: 57
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.
Linux NPTL vs. NPGT vs. LinuxThreads
Post date: April 24, 2005, 05:04 Category: Benchmarks Views: 159
Tutorial quote: Ulrich Drepper recently offered some interesting benchmark results, comparing the time it takes to create and destroy threads with different threading models under various conditions. The tests were run using a 2.5.37 development kernel, comparing LinuxThreads, NGPT 2.0.2 and NPTL 0.1.
Unix+clones Using MySQL to benchmark OS performance
Post date: April 12, 2005, 03:04 Category: Benchmarks Views: 93
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 Considerations for the system architect: Performance
Post date: April 20, 2005, 06:04 Category: Miscellaneous Views: 86
Tutorial quote: For many developers and engineers, performance is often an afterthought. But when a product functions as designed and has proven stability and the right feature mix, success in the marketplace often depends upon performance. Architectural decisions define the ultimate feasible performance of any product. In this article, learn how performance-monitoring technology initially developed for mainframes can help you improve your own code's performance.
Debian How To Set Up A Load-Balanced MySQL Cluster
Post date: March 31, 2006, 14:03 Category: Software Views: 13
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.
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 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 How To Set Up Database Replication In MySQL
Post date: December 14, 2005, 14:12 Category: Software Views: 81
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.
Linux Performance Tools for Optimizing Linux: Process-Specific CPU
Post date: June 1, 2005, 03:06 Category: Optimizing Views: 140
Tutorial quote: The tools to analyze the performance of applications are varied and have existed in one form or another since the early days of UNIX. It is critical to understand how an application is interacting with the operating system, CPU, and memory system to understand its performance. This chapter will help you understand where the bottleneck in your system is occuring, and how to fix it.