I configured MySQL service on a netscaler 10.5. When I perform some MySQL benchmarks using mysqlslap, the first time it runs correctly, the 2ed time I have an error message:
When I run it the first time: mysqlslap -hlb_mysql --concurrency=10 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-load-type=read --engine=InnoDB Benchmark Running for engine InnoDB Average number of seconds to run all queries: 0.044 seconds Minimum number of seconds to run all queries: 0.044 seconds Maximum number of seconds to run all queries: 0.044 seconds Number of clients running queries: 10 Average number of queries per client: 0
When I run it the 2ed time: mysqlslap: Cannot run query CREATE TABLE t1 (intcol1 INT(32) ,intcol2 INT(32) ,charcol1 VARCHAR(128),charcol2 VARCHAR(128),charcol3 VARCHAR(128)) ERROR : No database selected
When I wait a few minutes, it runs correctly again. After executing, I see about 16 persistent connection on the database originating from the NetScaler.
Any ideas how I could solve this problem? Regards, Peter
Aucun commentaire:
Enregistrer un commentaire