‘m getting the following error in my mysql.log file:

100630 2:03:39 [ERROR] /usr/libexec/mysqld: Incorrect key file for table ‘./app2_db/aix_data_user.MYI’; try to repair it

How do I fix this error and repair my table under UNIX or Linux operating systems? Read more…

July 25th, 2010 | Tags: ,

www.123searchonline.com provides the largest social network for local business owners. Services include free online advertising, free internet marketing, free local advertising, free online local business listings, free internet ads, free website traffic, internet marketing & advertising, free marketing tools, and business websites. [Visit site]

Online Business Directory: Company profiles, corporate records, financial information.

A thriving business is all about building and maintaining trust. Quality information builds trust and that’s what you get at www.123searchonline.com, the official www.123searchonline.com online business database. Much more than just a directory, www.123searchonline.com empowers our member businesses to market their businesses while building trust with customers and vendors, something www.123searchonline.com has specialized in since 2008.

www.123searchonline.com is the trusted source for business information. Build trust with www.123searchonline.com. Find and enhance your profile now. [Details]

July 21st, 2010 | Tags: , , ,
LVE is a kernel level technology developed by the CloudLinux team. The technology has common roots with container based virtualization. Yet, it is lightweight, and transparent. The goal of LVE is to make sure that no single web site can bring down your web server. Read more…
July 8th, 2010 | Tags: , ,

Dưới đây là các kiểu lửa đảo thường gặp trong môi giới tên miền mà tôi muốn chia sẻ với các bạn:
Gửi email, thư thông báo có người muốn đăng ký tên miền của mình ở một loại tên miền mở rộng khác:
Thông thường, các tên miền này có nguồn gốc .CN. Nội dung email đề cập đến vấn đề nhãn hiệu, thương hiệu, môi giới… bị đánh cắp để yêu cầu bạn đăng ký tên miền .CN để bảo vệ!
Email hỏi mua tên miền kèm theo dịch vụ định giá tên miền:
Đánh vào tâm lý muốn bán được tên miền của nhiều người, những kẻ lừa đảo thường ra một cái giá rất hấp dẫn kèm theo yêu cầu người bán sử dụng một dịch vụ định giá tên miền mà chúng chỉ định. Một khi bạn sử dụng dịch vụ này thì coi như tiền mất tật mang! Read more…

July 7th, 2010 | Tags:

Zmanda Recovery Manager (ZRM) for MySQL simplifies life of a database administrator who needs an easy to use yet flexible and robust backup and recovery solution for MySQL server. Significant features are:

* Schedule full and incremental logical or raw backups of your MySQL database
* Centralized backup management
* Perform backup that is the best match for your storage engine and your MySQL configuration
* Get e-mail notification about status of your backups
* Monitor and obtain reports about your backups (including RSS feeds)
* Verify your backup images
* Compress and encrypt your backup images
* Implement Site or Application specific backup policies
* Recover database easily to any point in time or to any particular database event
* Custom plugins to tailor MySQL backups to your environment
* MySQL backup using Linux LVM and Solaris ZFS snapshots Read more…

July 7th, 2010 | Tags: ,

A slow loris attack is one where an IP will connect to your apache server and clog up all child processes with it’s specially formed requests (I won’t get into the details as to how).

The solution is to install mod_antiloris to only allow a certain number of simulatenous connections per IP at a time (I believe they set it to 5 by default)

The registered apache mod_antiloris module is listed here:
http://modules.apache.org/search.php?id=1783

Quick install instructions:

cd /root
wget ftp://ftp.monshouwer.eu/pub/linux/mod_antiloris/installoris
chmod 755 installoris
./installoris

Note that this module is for apache 2.x, and not 1.3.

June 19th, 2010 | Tags:

How are transactions organized physically

When InnoDB creates a new transaction it is not yet committed. The database has not yet made any promises to the application and so we do not really have to make anything persistent so far.

To be fast InnoDB tries to assemble the transaction in a memory buffer, the innodb_log_buffer. It should be sufficiently large that you actually can assemble such a transaction in memory without needing to write it out in part into the redo log. A size of 1M to 8M is normal. Read more…

June 19th, 2010 | Tags: , ,

When working with InnoDB, you have two ways for managing the tablespace storage:

  1. Throw everything in one big file (optionally split).
  2. Have one file per table.

Read more…

June 19th, 2010 | Tags: ,

This page provides some basic hints for determining how to partition your data model with HiveDB.

Create a data model

Identify all of the resources that you want to store. In general you probably don’t want to put things in the hive unless you are talking about them in large powers of ten and their growth rate is also expressed as a large power of ten records per week or per month.
Read more…