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

Linux

Optimizing Desktop Performance, Part I

Post date: May 16, 2005, 23:05 Category: Optimizing Views: 3660 Comments
Tutorial quote: If you have complained about the speed of OpenOffice.org or Firefox or about the amount of time Linux takes to boot up, this set of optimizations should change your perception. Linux can boot up quickly, the word processor can spring open and the browser can fly. So, let's make these adjustments so your computer can fly.
Linux

Performance Tools for Optimizing Linux: Process-Specific CPU

Post date: June 1, 2005, 07:06 Category: Optimizing Views: 3131 Comments
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.
Linux

Optimizing Desktop Performance, Part II

Post date: May 24, 2005, 18:05 Category: Optimizing Views: 3346 Comments
Tutorial quote: As we discussed in last week's article, for most of its existence, people have distributed Linux as a workstation or a server rather than as a desktop. The default workstation that evolved has existed mostly for use by developers. So, when you install a Linux distribution with a graphical interface, it generally looks like what a developer might want. In addition, it performs similar to how many UNIX workstations work, which can seem slow.

In this article, we continue to look at the Linux desktop in a different light. Here, we think of it as a computer system with a fast interface that we can optimize for the knowledge worker and consumer.
Linux

How To Back Up MySQL Databases Without Interrupting MySQL

Post date: May 12, 2007, 23:05 Category: System Views: 3559 Comments
Tutorial quote: This article describes how you can back up MySQL databases without interrupting the MySQL service. Normally, when you want to create a MySQL backup, you either have to stop MySQL or issue a read lock on your MySQL tables in order to get a correct backup; if you do not do it this way, you can end up with an inconsistent backup. To get consistent backups without interrupting MySQL, I use a little trick: I replicate my MySQL database to a second MySQL server, and on the second MySQL server I use a cron job that creates regular backups of the replicated database.
Linux

Tunneling MySQL connections through SSH

Post date: January 2, 2007, 20:01 Category: Security Views: 3407 Comments
Tutorial quote: This is a description of how to set up a secure tunnel between your MySQL Server and a locally running MySQL Administrator using Putty. By creating a secure tunnel to your MySQL server using Putty, you can grant localhost access to powerful applications like MySQL Administrator while at the same time, make your server appear as if it isn't even there. In effect, make your MySQL server disappear from the outside world.
Linux

Application optimization with compilers for Linux on POWER

Post date: May 23, 2005, 16:05 Category: Optimizing Views: 2708 Comments
Tutorial quote: The Linux on POWER platform offers more than one option to produce binary C/C++ code. In addition to supporting both 32- and 64-bit runtime environments simultaneously, Linux on POWER has two compiler collections. The GNU Compiler Collection, or GCC, is consistent with other Linux implementations with specific exceptions for the POWER architecture. GCC is the leading compiler for portability but also features a number of performance enhancements for optimizing code. The IBM XL C/C++ compiler for Linux on POWER is derived from the high performance compiler for AIX but uses the GNU linker and assembler to create ELF objects that are fully compatible with objects produced by GCC. This document provides side-by-side comparisons of how these two compilers are controlled, overviews of what the compilers are capable of, in terms of optimization, and tips for writing code that is more easily optimized with either of these compilers.
Unix+clones

MySQL Master Master Repliction

Post date: September 18, 2006, 14:09 Category: Benchmarks Views: 5753 Comments
Tutorial quote: When we need to replication mysql servers with each other some time for synchronizing for HA. In my case I need the mysql servers for which two masters must be synchronized with each other so that if any one drops down, other could take care of the one and data must not be lost. Similarly when one goes up, it will still be used as slave for the live one.

Here is a basic step by step tutorial, that will cover the mysql master and slave replication and also will describe the mysql master and master replication.
Debian

How To Set Up A Load-Balanced MySQL Cluster

Post date: March 31, 2006, 19:03 Category: Software Views: 3772 Comments
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.
Debian

How To Set Up A Load-Balanced MySQL Cluster With MySQL 5.1

Post date: June 17, 2008, 09:06 Category: Installing Views: 3325 Comments
Tutorial quote: This tutorial shows how to configure a MySQL 5.1 cluster with five nodes: 1 x management, 2 x storage nodes and 2 x balancer nodes. This cluster is load-balanced by an 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).
Linux

Check Your Mysql Server Performance with MySQLTuner

Post date: November 30, 2008, 20:11 Category: Software Views: 2728 Comments
Tutorial quote: MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved.
Web-based applications and online marketing solutions - LumoLink