Displaying 3 results from an estimated 3 matches for "rows_affected".
2004 Jun 22
0
Perl Script for pulling information from a mysql database
...uot;);
$sth->execute();
while ($hash = $sth->fetchrow_array) {
unless ($gotit) {
$return = $hash;
$gotit++;
} else { warn "got multiple SQL returns when exepecting only
one"; }
}
return $return;
}
sub SimpleSQL {
my($sql) = $_[0];
my $rows_affected;
$rows_affected = $dbh->do($sql);
return $rows_affected;
}
sub Action {
my($action) = @_;
# print"Performing: $action\n";
$warn=`$action 2>&1`;
if ($warn) {
chomp($warn);
$prepare = "ERROR: $warn. Command was: $action";
# print"WHOOPS: $warn...
2013 Oct 08
4
'puppet storeconfigs export' killed
...uery and returns the data,
according to MySQL''s slow-queries.log:
# Time: 131008 17:06:14
# User@Host: puppet[puppet] @ [172.20.59.127]
# Thread_id: 169 Schema: puppet Last_errno: 0 Killed: 0
# Query_time: 189.509563 Lock_time: 0.000136 Rows_sent: 6168111
Rows_examined: 12712154 Rows_affected: 0 Rows_read: 18446744073709551613
# Bytes_sent: 2426331478 Tmp_tables: 0 Tmp_disk_tables: 0
Tmp_table_sizes: 0
# InnoDB_trx_id: A93
SET timestamp=1381244774;
SELECT `hosts`.`id` AS t0_r0, `hosts`.`name` AS t0_r1, `hosts`.`ip` AS
t0_r2, `hosts`.`environment` AS t0_r3, `hosts`.`last_compile` A...
2004 Jul 02
24
TC Hashing Filters
Hey all,
I had asked a question a little while ago about CPU usage being
outrageous while using tc and a cbq qdisc. Ed was very kind and offered
a few suggestions. One of these was to look at hashing. So after
pounding away at it for about a week, I have a general understanding of
how it works and have tried to implement it. Unfortunately, and quite
obviously since I''m posting here, it