Login or Register to Ask a Question and Join Our Community


MySQL DevZone RSS

FC Inter Milan Using MySQL 5.1 Partitioning and Event Scheduler

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Web Development MySQL DevZone RSS FC Inter Milan Using MySQL 5.1 Partitioning and Event Scheduler
# 1  
Old 09-10-2008
FC Inter Milan Using MySQL 5.1 Partitioning and Event Scheduler
If you are a football (soccer) fan, then F.C. Internazionale may mean something to you. Or perhaps its more common name, Inter Milan sounds familiar? Next in our Use Case Competition articles, here's Corrado Pandiani's experience, about using MySQL to power inter.it, one of the most popular soccer sites in Europe. Not only that, but inter.it is using the latest MySQL 5.1 technology.

More...
Login or Register to Ask a Question

Previous Thread | Next Thread

6 More Discussions You Might Find Interesting

1. OS X (Apple)

Inter-shell communication

If I open two bash shells and telnet from Shell 2 to a remote server (on the Net), is there a way to direct input from Shell 1 to the telnet shell? The telnet shell is a limited environment with a specific command set. I want to direct commands from Shell 1 and, if possible, put 1-second... (2 Replies)
Discussion started by: xinUoG
2 Replies

2. Programming

help with write-read locks inter-process

I need help!Many Thanks! Now,I try to manage the shared memory inter-process . Inevitably,I have to deal with the synchronous. I know the pthread_rwlock in posix,and I compile ,then run successfully in Red Hat Enterprise 4. I have a doubt about whether the Posix supports the system such as... (1 Reply)
Discussion started by: weizh
1 Replies

3. Programming

C program using IPC (inter process communication)

i want to write a C chat program that communicates over IPC(inter process communication), that could be run using 2 seperate terminal windows within the same computer. so that wat u type in one terminal window , should appear on the other and vice versa... could some one please help me with the... (2 Replies)
Discussion started by: localp
2 Replies

4. UNIX for Advanced & Expert Users

Inter-process communication:pipes,doors,etc.

Hi, I am thinking about writing a log daemon for a multi-processed ksh application (yes - I know that high-level language would be a better option). My question is as follows: If many processes (many scripts) will try writing to a single log file: print "message" > common.log Will it work or... (2 Replies)
Discussion started by: adderek
2 Replies

5. Shell Programming and Scripting

event scheduler/tracker script

Dear All, I am writing an event tracker shell script as part of a personal project. I am trying 2 write a sort of date math function using the GNU date command. This function would allow 2 search 4 future events, like looking 4 events 1 or 2 days ahead 4 instance. I've used the date command b4... (1 Reply)
Discussion started by: theangrybeaver
1 Replies

6. Programming

Inter Process Communication

unix IPC i would like to know the method of usage of semaphores on shared memory segments the topic seems very difficult to understand mainly when difrent proceses communicate instantly and how do i avaoid deadlock situation (2 Replies)
Discussion started by: kamathanil
2 Replies
Login or Register to Ask a Question

LEARN ABOUT CENTOS

pmdamysql

PMDAMYSQL(1)						       Performance Co-Pilot						      PMDAMYSQL(1)

NAME

       pmdamysql - MySQL database PMDA

DESCRIPTION

       pmdamysql is a Performance Co-Pilot PMDA which extracts live performance data from a running MySQL database.

INSTALLATION

       pmdamysql uses a configuration file from (in this order):

       o   /etc/pcpdbi.conf

       o   $PCP_PMDAS_DIR/mysql/mysql.conf

       This file can contain overridden values (Perl code) for the settings listed at the start of pmdamysql.pl, namely:

       o   database name (see DBI(3) for details)

       o   database user name

       o   database pass word

       Once this is setup, you can access the names and values for the mysql performance metrics by doing the following as root:

	       # cd $PCP_PMDAS_DIR/mysql
	       # ./Install

       If you want to undo the installation, do the following as root:

	       # cd $PCP_PMDAS_DIR/mysql
	       # ./Remove

       pmdamysql is launched by pmcd(1) and should never be executed directly.	The Install and Remove scripts notify pmcd(1) when the agent is
       installed or removed.

Binary Status values in text
       Some of the status values are in the form of YES/NO or ON/OFF.

       Since these cannot be intepreted by tools like PMIE, they have been duplicated with a _num extension and the values of 1 (YES/ON) or 0
       (NO/OFF).

   Eg:
       o   mysql.slave_status.slave_io_running

       o   mysql.slave_status.slave_io_running_num

FILES

       /etc/pcpdbi.conf
	   configuration file for all PCP database monitors

       $PCP_PMDAS_DIR/mysql/mysql.conf
	   configuration file for pmdamysql

       $PCP_PMDAS_DIR/mysql/Install
	   installation script for the pmdamysql agent

       $PCP_PMDAS_DIR/mysql/Remove
	   undo installation script for the pmdamysql agent

       $PCP_LOG_DIR/pmcd/mysql.log
	   default log file for error messages from pmdamysql

SEE ALSO

       pmcd(1), pmdadbping.pl(1) and DBI(3).  # vi: sw=4 ts=4 et:

3.8.10							       Performance Co-Pilot						      PMDAMYSQL(1)