Using Partitioning and Event Scheduler to Prune Archive Tables


 
Thread Tools Search this Thread
Top Forums Web Development MySQL DevZone RSS Using Partitioning and Event Scheduler to Prune Archive Tables
# 1  
Old 09-09-2008
Using Partitioning and Event Scheduler to Prune Archive Tables

First in our series of Use Case reports on new MySQL 5.1 features, we have Greg Haase of Lotame describing his innovative use of partitioning. Usually, the creators of new applications are unaware of the various tweaking that users may submit their features to, in order to achieve surprising results. We in the community team are usually on the tweaking side, and we like to surprise developers with (positive) side effects of the existing features. This time, we were caught by surprise. Greg's usage of partitioning and events is really cool!

More...
Login or Register to Ask a Question

Previous Thread | Next Thread

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to archive logs and sftp to another archive server

Requirement: Under fuse application we have placeholders called containers; Every container has their logs under: <container1>/data/log/fuse.log <container1>/data/log/fuse.log.1 <container1>/data/log/fuse.log.XX <container2>/data/log/fuse.log... (6 Replies)
Discussion started by: Arjun Goswami
6 Replies

2. Shell Programming and Scripting

Extracting from archive | compressing to new archive

Hi there, I have one huge archive (it's a system image). I need sometime to create smaller archives with only one or two file from my big archive. So I'm looking for a command that extracts files from an archive and pipe them to another one. I tried the following : tar -xzOf oldarchive.tgz... (5 Replies)
Discussion started by: chebarbudo
5 Replies

3. UNIX for Dummies Questions & Answers

Proper use of prune...

My goal was to find any directories inside of any directory called "09_Client Original" not modified in the last 30 days. $ find /Volumes/Jobs_Volume/ -type d -name "09_Client Original" -exec find {} -mtime +30 -type d -maxdepth 1 \; The results of this find are passed along in a perl script... (1 Reply)
Discussion started by: guriboy
1 Replies

4. Shell Programming and Scripting

Converting tables of row data into columns of tables

I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated. Input: test_data_1 1 2 90% 4 3 91% 5 4 90% 6 5 90% 9 6 90% test_data_2 3 5 92% 5 4 92% 7 3 93% 9 2 92% 1 1 92% ... Output:... (7 Replies)
Discussion started by: justthisguy
7 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
Login or Register to Ask a Question
GStreamer::Event(3pm)					User Contributed Perl Documentation				     GStreamer::Event(3pm)

NAME
GStreamer::Event - Structure describing events that are passed up and down a pipeline DESCRIPTION
The various event types are represented as subclasses: GStreamer::Event::FlushStart GStreamer::Event::FlushStop GStreamer::Event::EOS GStreamer::Event::NewSegment GStreamer::Event::Tag GStreamer::Event::BufferSize GStreamer::Event::QOS GStreamer::Event::Seek GStreamer::Event::Navigation GStreamer::Event::Custom::UP GStreamer::Event::Custom::DS GStreamer::Event::Custom::DS::OOB GStreamer::Event::Custom::Both GStreamer::Event::Custom::Both::OOB To create a new event, you call the constructor of the corresponding class. To check if an event is of a certain type, use the type method: if ($event -> type eq "newsegment") { # ... } elsif ($event -> type eq "eos") { # ... } To get to the content of an event, call the corresponding accessor: if ($event -> type eq "newsegment") { my $update = $event -> update; my $rate = $event -> rate; my $format = $event -> format; my $start_value = $event -> start_value; my $stop_value = $event -> stop_value; my $stream_time = $event -> stream_time; # ... } elsif ($event -> type eq "tag") { my $tag = $event -> tag; # ... } METHODS
structure = $event->get_structure eventtype = $event->type ENUMS AND FLAGS
enum GStreamer::EventType o 'unknown' / 'GST_EVENT_UNKNOWN' o 'flush-start' / 'GST_EVENT_FLUSH_START' o 'flush-stop' / 'GST_EVENT_FLUSH_STOP' o 'eos' / 'GST_EVENT_EOS' o 'newsegment' / 'GST_EVENT_NEWSEGMENT' o 'tag' / 'GST_EVENT_TAG' o 'buffersize' / 'GST_EVENT_BUFFERSIZE' o 'sink-message' / 'GST_EVENT_SINK_MESSAGE' o 'qos' / 'GST_EVENT_QOS' o 'seek' / 'GST_EVENT_SEEK' o 'navigation' / 'GST_EVENT_NAVIGATION' o 'latency' / 'GST_EVENT_LATENCY' o 'step' / 'GST_EVENT_STEP' o 'custom-upstream' / 'GST_EVENT_CUSTOM_UPSTREAM' o 'custom-downstream' / 'GST_EVENT_CUSTOM_DOWNSTREAM' o 'custom-downstream-oob' / 'GST_EVENT_CUSTOM_DOWNSTREAM_OOB' o 'custom-both' / 'GST_EVENT_CUSTOM_BOTH' o 'custom-both-oob' / 'GST_EVENT_CUSTOM_BOTH_OOB' SEE ALSO
GStreamer COPYRIGHT
Copyright (C) 2005-2011 by the gtk2-perl team. This software is licensed under the LGPL. See GStreamer for a full notice. perl v5.14.2 2012-03-01 GStreamer::Event(3pm)