MySQL load statistics, Apache log analysis

We are looking to develop a script with the following functionalities: Objective / Purpose: The objective of the script is to give the detailed the usage of server resources serving thousands of free-web-hosting accounts per user. The overall purpose of the script will be to give the administrator the information on what is the load on the server by each user for the following services: Disk usage, Bandwidth usage, MySQL load, Hits to the website (Apache log). Disk and Bandwidth usage: This data is already being collected and stored in a MySQL table together with the username and available quotas. This data will have to be transferred into a new table (a few tables) along with the other parameters stated below. MySQL load: An algorithm will have to written based on the following idea: [login to view URL] whereby it will run and summarize the total load of a MySQL per user into a mysql table. The following statistics are necessary to be collected with an interval stated in the parenthesis and formatted to extract information per user and the mysql server as a whole. SHOW STATUS (every second) SHOW PROCESSLIST (every minute) SHOW TABLE STATUS (every 24 hours) ??" for every database inside mysql Every user in the system has from 0 to 7 databases hosted whereby the database name is as follows: _<…> Apache log: Configure the format of the apache log and write a script that will analyze the number of daily hits to the pages of each user and record this statistic into a mysql table. Note: Users are subdomain of our domain or registered domains. Directory structure: /www/u/s/e/username/htdocs/ Presentation: Least important part When bidding we ask you to present examples of past work in this field and state briefly on how you expect to expect to execute this project. Regards FreeWeb7 ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Linux CentOS 4.4-32, MySQL 4.1.11, Apache 2, PHP 5.1.6, Perl, Cronjob