Re: performance of jailed processes

From: Dag-Erling Smørgrav (des_at_des.no)
Date: 03/30/04

  • Next message: Dag-Erling Smørgrav: "Re: performance of jailed processes" 
    To: Robert Watson <rwatson@freebsd.org>
Date: Tue, 30 Mar 2004 22:52:01 +0200

    Robert Watson <rwatson@freebsd.org> writes:
    > Somewhat more painful suggestion, but could you generate ktraces against a
    > mysql client doing the query inside and out of jail, then using whatever
    > flag sets relative timestamps on kdump, diff the two and see where the
    > substantial differences begin?

    I'll give it a shot tomorrow.

    > 13 seconds is too long for most of the potential things I have in mind...

    although the query only returns one row, it's a pretty big row, so 13
    seconds could be explained by per-syscall or per-packet overhead.

    DES 

    -- 
Dag-Erling Smørgrav - des@des.no
_______________________________________________
freebsd-current@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-current
To unsubscribe, send any mail to "freebsd-current-unsubscribe@freebsd.org"
  • Next message: Dag-Erling Smørgrav: "Re: performance of jailed processes"

    Relevant Pages

    • Re: performance of jailed processes
      ... >> mysql client doing the query inside and out of jail, ... I've had quite a bit of luck resolving mysql problems in jail using this ... approach, fwiw, during some confusion relating to UNIX domain sockets at ...
      (freebsd-current)
    • Re: Sarge problems with MySQL and DBI / DBD::mysql
      ... > with the mysql client. ... successfully returns 0 rows, so $dbh->selectrow_arrayis "undef". ... so the part of your query after the "or" gets run. ... error message which claims the query produced a DBI error, ...
      (Debian-User)
    • Re: DBI Issue with MySQL query
      ... It was a typo. ... The following query works fine from the MySQL client: ... LOAD DATA INFILE 'data.txt' INTO TABLE 'db.table' FIELDS TERMINATED BY '|' ...
      (perl.dbi.users)
    • Re: DBI Issue with MySQL query
      ... Don't put single quotes around the table name. ... The following query works fine from the MySQL client: ... LOAD DATA INFILE 'data.txt' INTO TABLE 'db.table' FIELDS TERMINATED BY '|' ...
      (perl.dbi.users)
    • Re: DBI Issue with MySQL query
      ... Don't put single quotes around the table name. ... The following query works fine from the MySQL client: ... LOAD DATA INFILE 'data.txt' INTO TABLE 'db.table' FIELDS TERMINATED BY '|' ...
      (perl.dbi.users)