search

kamal2222ahmed / jiffy-web

Automatically exported from code.google.com/p/jiffy-web
Other
0 stars 0 forks source link

MYSQL Improvement -- performance_log_inserter.pl #4

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
Issue:
When ingesting a log-file, MySQL will complain that it cannot find table
"jiffy.measurement_20080627".

Solution:
On line #328
[http://code.google.com/p/jiffy-web/source/browse/trunk/ingestor/performance_log
_inserter.pl#328]
replace "measurement" with "MEASUREMENT".

-old------
$sqlString = "INSERT INTO " . $DBASE .
".measurement_$entry->{table_partition} ($SQL_FIELDS) VALUES ($SQL_VALUES)";
==========
$sqlString = "INSERT INTO " . $DBASE .
".MEASUREMENT_$entry->{table_partition} ($SQL_FIELDS) VALUES ($SQL_VALUES)";
-new------

Original issue reported on code.google.com by GeorgeC...@gmail.com on 24 Sep 2008 at 9:39