RE: [Sequoia] Performance

Wed, 02 May 2007 12:02:29 -0700 

Hello Emmanuel,

        Config files are attached.  The client is on another machine (same
LAN) but could the be the problem considering the same client using direct
MySQL connection can do the same work in about 4 seconds?  Same exact
client, using Sequoia driver it takes over 100 seconds, using native MySQL
driver it takes 4.  So, while it might speed things up to put the client on
the same machine as the controller it's not going to close the 100 to 4 gap
I'm seeing now, right?

Thanks for your help,

Randall 

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Emmanuel
Cecchet
Sent: Wednesday, May 02, 2007 10:25 AM
To: Sequoia general mailing list
Subject: Re: [Sequoia] Performance

Hi Randall,
>       Controllers: 2 (v2.10)
>       Database: MySQL 4.1 X 2  Note: One DB and one controller on each 
> machine, total two machines, same subnet.
>       Group Communication: Hedera (default that comes with Sequoia v2.10,
> correct?)
>   
Hedera is just a wrapper, the real implementation is JGroups by default with
2.10 but you can also use Appia as an alternative.
>       Controller Warnings: I get one thing, but I think it's only because 
> of user error:
>
> 2007-05-02 09:40:50,212 WARN  controller.virtualdatabase.SWP_DB 
> Distributed request delete from test did not remove itself from the 
> total order queue
>
> That was only because I hadn't created test table yet.
>   
Ok, but this should not have happened anyway. Could you post your virtual
database configuration file?

Is the client executing the 1k inserts on a remote machine? If yes, could
you try to run it locally to one of the MySQL instance and see what
performance you get?

Thanks for the feedback,
Emmanuel

--
Emmanuel Cecchet
Chief Scientific Officer, Continuent

Blog: http://emanux.blogspot.com/
Open source: http://www.continuent.org
Corporate: http://www.continuent.com
Skype: emmanuel_cecchet
Cell: +33 687 342 685


_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia

BEGIN:VCARD
VERSION:2.1
N:Fidler;Randall
FN:Randall Fidler
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20050926T075331Z
END:VCARD

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.6//EN" "http://sequoia.continuent.org/dtds/sequoia-2.10.6.dtd";>

<SEQUOIA>

  <VirtualDatabase name="SWP_DB">

	<Distribution>
    <MessageTimeouts/>
	</Distribution>

    <Monitoring>
      <SQLMonitoring defaultMonitoring="off">
         <SQLMonitoringRule queryPattern="^select" caseSensitive="false" applyToSkeleton ="false" monitoring="on"/>
      </SQLMonitoring>
    </Monitoring>

   <Backup>
      <Backuper backuperName="mySQL"
        className="org.continuent.sequoia.controller.backup.backupers.MySQLBackuper"
        options="dumpServer=10.1.1.8,bindir=C:\Streetwise\MySQL\mysql-4.1.15-win32\bin"/>
    </Backup>

    
    <AuthenticationManager>
      <Admin>
       	<User username="root" password="1q2w#E$R"/>
      </Admin> 
      <VirtualUsers>
        <VirtualLogin vLogin="user" vPassword="streetwise"/>
      </VirtualUsers>
    </AuthenticationManager>

    <DatabaseBackend name="streetwiseOn8" driver="com.mysql.jdbc.Driver"
      url="jdbc:mysql://10.1.1.8:3306/streetwise"
      connectionTestStatement="select 1">
      <ConnectionManager vLogin="user" rLogin="streetwise" rPassword="streetwise">
        <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
          maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
      </ConnectionManager>
    </DatabaseBackend>

    <RequestManager>
      <RequestScheduler>
         <RAIDb-1Scheduler level="passThrough"/>
      </RequestScheduler>

      <RequestCache>
         <MetadataCache/>
         <ParsingCache/>		 
<!--       <ResultCache granularity="table"/> -->
      </RequestCache>

      <LoadBalancer>
         <RAIDb-1>
            <WaitForCompletion policy="all"/>
            <RAIDb-1-LeastPendingRequestsFirst/>
         </RAIDb-1>
      </LoadBalancer>

     <RecoveryLog driver="com.mysql.jdbc.Driver"
        url="jdbc:mysql://10.1.1.8:3306/streetwise" login="streetwise" password="streetwise">
        <RecoveryLogTable tableName="recovery" logIdColumnType="BIGINT NOT NULL"
          vloginColumnType="VARCHAR NOT NULL"
	    sqlColumnName="ssql"
	    sqlColumnType="VARCHAR NOT NULL"
          extraStatementDefinition=",PRIMARY KEY (log_id)"/>
        <CheckpointTable tableName="checkpoint"
          checkpointNameColumnType="VARCHAR NOT NULL"/>
        <BackendTable tableName="backend"
          databaseNameColumnType="VARCHAR NOT NULL"
          backendNameColumnType="VARCHAR NOT NULL"
          checkpointNameColumnType="VARCHAR NOT NULL"/>
        <DumpTable tableName="dump" dumpNameColumnType="VARCHAR NOT NULL"
          dumpDateColumnType="TIMESTAMP"
          dumpPathColumnType="VARCHAR NOT NULL"
          dumpFormatColumnType="VARCHAR NOT NULL"
          checkpointNameColumnType="VARCHAR NOT NULL"
          backendNameColumnType="VARCHAR NOT NULL"
	    tablesColumnName="tables_data"
          tablesColumnType="VARCHAR NOT NULL"/>
      </RecoveryLog>
    </RequestManager>

  </VirtualDatabase>

</SEQUOIA>

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD SEQUOIA-CONTROLLER 2.10.6//EN"  "http://sequoia.continuent.org/dtds/sequoia-controller-2.10.6.dtd";>
<SEQUOIA-CONTROLLER>
	<Controller ipAddress="10.1.1.8" port="25322">
    <JmxSettings>
    	<RmiJmxAdaptor port="1090"/>
	</JmxSettings>
	<VirtualDatabase configFile="SWP-raidb1.xml" virtualDatabaseName="SWP_DB" autoEnableBackends="true"/>
	</Controller>
</SEQUOIA-CONTROLLER>

Attachment: smime.p7s
Description: S/MIME cryptographic signature

_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia

Reply via email to