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

Search results for High Performance MySQL


Postfix performance tuning

Post date: May 21, 2005, 11:05 Category: Optimizing Views: 3424 Comments
Tutorial quote: Postfix is fast out of the box, but like other packages, you can usually tune it to work even faster. Furthermore, there are situations where Postfix may not perform as well as you expected, whether because of hardware or software limitations on the server system or other adverse conditions, such as a big influx of spam or undeliverable mail. This article shows you how to find and analyze the most common performance problems.

Profiling in Linux Performance Tuning

Post date: December 18, 2005, 21:12 Category: Optimizing Views: 3433 Comments
Tutorial quote: This chapter covers several methods to measure execution time and real-time performance. The methods give different types of granularity, from the program’s complete execution time to how long each function in the program takes.

Firebird database Configuration

Post date: May 5, 2006, 17:05 Category: Installing Views: 2138 Comments
Tutorial quote: Firebird is a relational database offering many ANSI SQL-99 features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names since 1981.

Firebird is a commercially independent project of C and C++ programmers, technical advisors and supporters developing and enhancing a multi-platform relational database management system based on the source code released by Inprise Corp (now known as Borland Software Corp) under the InterBase Public License v.1.0 on 25 July, 2000.

Aggregating network interfaces

Post date: February 12, 2006, 07:02 Category: Network Views: 2991 Comments
Tutorial quote: Using more than one hard drive to achieve better performance and fault tolerance is very common. Less well known is that it's also possible to aggregate more than one network interface into a single logical interface. In Linux, this is handled by the bonding driver. Benefits of doing this are much the same as the benefits of aggregating discs using RAID: if one device dies, your server carries on working and by using two devices in parallel, performance can be improved.

Building a Linux Cluster, Part 1

Post date: April 18, 2005, 03:04 Category: Network Views: 2383 Comments
Tutorial quote: Linux clusters have escaped. As the general popularity of the Linux operating system increases, more complex solutions built with it are becoming increasingly common in the "traditional" (more conservative) IT world. Linux computer clusters, whose provenance was originally universities and research institutions such as the U.S. National Laboratories, are showing up in increasing numbers as high-performance computing solutions within such areas as oil and gas exploration, computer-aided engineering, visualization, and software development. Linux clusters providing highly-available web, mail, and other infrastructure services are also increasingly common. If past computing history is any indicator of future trends, widespread use of Linux clusters in the mainstream IT world cannot be far behind.

How To Back Up MySQL Databases Without Interrupting MySQL

Post date: May 12, 2007, 23:05 Category: System Views: 3583 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.

Installing and securing Squid

Post date: March 13, 2006, 15:03 Category: Software Views: 4776 Comments
Tutorial quote: Squid is a high-performance proxy caching server for web clients, supporting FTP, gopher, and HTTP data objects. Unlike traditional caching software, Squid handles all requests in a single, non-blocking, I/O-driven process. Squid keeps meta data and especially hot objects cached in RAM, caches DNS lookups, supports non-blocking DNS lookups, and implements negative caching of failed requests. Squid supports SSL, extensive access controls, and full request logging. By using the lightweight Internet Cache Protocol, Squid caches can be arranged in a hierarchy or mesh for additional bandwidth savings.

After the installation and base configuration of squid we will add another layer of security by chrooting it.

How to Increase ext3 and ReiserFS filesystems Performance in Linux

Post date: May 14, 2007, 00:05 Category: System Views: 4653 Comments
Tutorial quote: This tutorial explains how to increase ext3 and ReiserFS filesystems Performance in Linux.The ext3 or third extended filesystem is a journalled file system that is commonly used by the Linux operating system. It is the default file system for many popular Linux distributions

Network Performance Fine Tuning in openSUSE & SUSE

Post date: October 8, 2008, 23:10 Category: Network Views: 4246 Comments
Tutorial quote: openSUSE and SUSE Linux sets default values for some of the network related Kernel parameters. With Kernel 2.6 (default in recent releases of openSUSE & SuSE Linux), there are some fine tuning you can do to improve Network performance and get that extra out of your system.

Configuring Apache for Maximum Performance

Post date: February 12, 2006, 09:02 Category: Optimizing Views: 3818 Comments
Tutorial quote: Apache is an open-source HTTP server implementation. It is the most popular web server on the Internet; the December 2005 Web Server Survey conducted by Netcraft [1] shows that about 70% of the web sites on Internet are using Apache.

Apache server performance can be improved by adding additional hardware resources such as RAM, faster CPU, etc. But most of the time, the same result can be achieved by custom configuration of the server. This article looks into getting maximum performance out of Apache with the existing hardware resources, specifically on Linux systems. Of course, it is assumed that there is enough hardware resources - especially enough RAM that the server isn't swapping frequently. First two sections look into various Compile-Time and Run-Time configuration options. The Run-Time section assumes that Apache is compiled with prefork MPM. HTTP compression and caching is discussed next. Finally, using separate servers for serving static and dynamic contents is covered. Basic knowledge of compiling and configuring Apache and Linux are assumed.
Web-based applications and online marketing solutions - LumoLink