The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
95 views

Tuning postgresql.conf when benchmark

Description: We build a new database server Enterprisedb v9.3 (PostgreSQL commercial), so we use JMX to benchmark it with 1000 users. Here our detailed information: Operating System: Centos 6 x64 ...
0
votes
1answer
105 views

stress-testing MySQL slave with master's queries

A MySQL host in a slave configuration is in the testing phase before being put into production as a primary server for a specific workload. To make an estimate about how it is going to perform, the ...
3
votes
0answers
303 views

Are there any known benchmarks/statistics on UnQLite?

I came across UnQLite the other day in Stack Overflow and it has me intrigued for some software I'm working on. However, very few tests have been published on how well it performs. There are plenty of ...
1
vote
0answers
107 views

TPC-DS data generation

Is there a way to generate TPC-DS/TPC-H data using Normal Distribution, i.e., is there a way to specify the distribution type while generating TPC-DS/TPC-H? EDIT : I believe there is an option for ...
1
vote
0answers
116 views

Sysbench insert data between a given range

I was trying to insert 1000000 records of data into 1000 tables in sysbench. But after installing about 278, sybench just crashed with the following error: FATAL: failed to execute function ...
0
votes
0answers
743 views

Benchmarking MyISAM vs InnoDB using Sysbench on MariaDB-10.0.14

I performed a "read" benchmark on MariaDB-10.0.14 db server using sysbench to compare performance between InnoDB and MyISAM on a single. Below are the sysbench commands i used: Create test table in ...
0
votes
0answers
55 views

Which benchmark assess string pattern matching in a database?

I have a postgresql DB in which I do a lot of string matching ala : UPDATE table1 SET colum1 = TRUE WHERE colum2 LIKE '%teststring%'; colum2 is a whole html file As I said I do A LOT of this and ...
0
votes
0answers
216 views

How to generate TPC_DS queries for Oracle?

I have downloaded the DSGEN tool from the TPC-DS web site and already generated the tables and loaded the data into Oracle XE. I am using the following command to generate the SQL statements: ...