Questions tagged [benchmark]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
21 views

Benchmarking MongoDB full text search vs MSSQL full text search

I'm working on a project for comparing mongodb and mssql databases performance on full text search. I started with using YCSB benchmark but now that I have a deeper understanding about this benchmark, ...
0
votes
0answers
17 views

Is querying by a PRIMARY KEY in MySQL faster than other queries?

I have two queries that return on a dataset of 200,000 records with apparently the same performance. The first looks up a primary key, and the second a varchar(32) with no special constraints. Am I ...
0
votes
1answer
34 views

Is mongodb upsert the right option for write intensive use case?

I'm designing a data model for a transactional use case which is write intensive. The write load would be 900 - 1,600 Transactions Per Second (TPS) which would account for 30 million Inserts/Updates ...
0
votes
2answers
484 views

Speed difference between Drop table and Truncate table in Postgres

I currently have a program that inserts into a database by creating temp tables, filling the tables, then merging that data into the main tables. Then dropping the tables and doing it all again. I'm ...
0
votes
0answers
9 views

Benchmark for a rowlock in mysql

I am trying to benchmark a sql transaction with a select..for update statement which uses an exclusive lock on the row and then insert a row into another table as shown below. START TRANSACTION; ...
3
votes
1answer
134 views

How to benchmark disk performance from within SQL Server?

I know of tools such as SQLIO and diskspd to benchmark IO/disk performance, but need something that can be run from the SQL Server instance itself via T-SQL, as I'm working on a Cloud-hosted ...
1
vote
0answers
150 views

pgbench - 20-30% variation in benchmark results (non-repeatable benchmarks)

Problem I'm trying to use pgbench to help me tune Postgres for my hardware, but I'm seeing a very strange behaviour. I cannot seem to get a stable number for TPS in consecutive runs of pgbench. Since ...
2
votes
1answer
336 views

Replay (re-execute) MySQL SELECT queries from a log file

MySQL Benchmarking I would like to evaluate the performance of a different MySQL instance by re-executing real queries from log files. I am aware of tools like mysqlslap, that produces random and ...
2
votes
0answers
48 views

Automating performance tests in PostgreSQL

I want to check the performance of specific queries in a Postgres database on a regular basis. Also, I want to be able to check the change in performance of different queries with any change in my ...
0
votes
3answers
120 views

SQL Server memory benchmarking - how to fill up memory?

Recently I was asked by my VMWare colleague how to cause a (non-production and bare install) SQL Server to use up the memory of a machine. The solution I found in this forum post does not cause the ...
2
votes
1answer
353 views

How to benchmark query parsing & planning in Postgres?

I'm trying to benchmark the query planning and parsing steps in PG: However, it seems that the query planner is using some sort of cache - only the first execution of EXPLAIN ANALYZE seems to report ...
2
votes
1answer
27 views

Benchmarks for custom database

I am looking for an open source benchmark tool that can easily be extended to custom databases. The reason is I have created a new NoSQL DBMS (called Borrego) that support both JSON queries like ...
-1
votes
1answer
531 views

Benchmarking Mongodb Queries Without cache

I want to benchmark some Mongodb queries by calculating their execution time but I could not find a way to do so without caching : The first time I execute a query it takes a decent amount of time and ...
4
votes
2answers
1k views

How do I get the Query Timing with sqlcmd?

Running SQL Server 2017, using the interactive REPL client sqlcmd how do I get the time for Query Execution? You can sp_BlitzErik showing this in his answer here, SQL Server Execution Times: CPU ...
1
vote
0answers
106 views

Understanding query variance in exec time in PostgreSQL?

I want to execute a set of queries many times through psql and to study running/execution time of each query. Of course, I want to run them many times to reduce effect of external factors through ...
13
votes
2answers
6k views

Why is array_agg() slower than the non-aggregate ARRAY() constructor?

I was just reviewing some old code written for pre-8.4 PostgreSQL, and I saw something really nifty. I remember having a custom function do some of this back in the day, but I forgot what pre-...
0
votes
1answer
2k views

Measuring IOPS in SQL 2014

We have a LANDEsk migration going on where several servers are being consolidated into one SQL 2014 Cluster. What would be the best way to calculate IOPS for such a scenario? The data is still being ...
1
vote
3answers
440 views

Any script to auto test tune and benchmark mysql config?

I'm looking or willing to do a script to benchmark mysql config variations for a specific system. A script that would change certain mysql config values and do a sysbench, save results, change ...
1
vote
1answer
132 views

Is it necessary to create primary and foreign keys in order to use tpc-h benchmark?

I'm doing some tests with tpc-h benchmark. The tpch-h benchmark simulates a data warehouse environment. The most important things here are the queries against the data warehouse. Therefore, does it ...
1
vote
0answers
82 views

Slow query speed using workstation processed joins with 100 Mbps connection speed?

In a department where they were complaining that a report was being run slowly, I jumped on one of the empty machines there and tried it out. It took a good 6 and 15 seconds to run. Run from a ...
2
votes
1answer
12k views

get query execution time in command prompt [duplicate]

I'm doing this query select * from rentals. This table has more than 10,000 rows and it takes more than 4 minutes to retrieve the results. But I get this time after I get the results: 10000 rows in ...
0
votes
1answer
57 views

Perfmon Counters that relate to SQLIO

I am trying to benchmark a new virtual SQL server. this will be the first time I have virtualized a production SQL server. I don't think this is a supper busy server. 100-200 users, of varying ...
0
votes
1answer
441 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 is our detailed information: Operating System: Centos 6 x64 ...
1
vote
1answer
747 views

MySQL Read/Write Benchmark

I'm trying to benchmark Read/Write speed in MySQL 5.5. Currently I have a stored procedure that insert rows with random numbers to a table and I'm measuring time of execution before and after ...
3
votes
1answer
1k 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
3answers
695 views

How to tell MySQL to ignore all indexes for a given query? [duplicate]

I've been benchmarking several queries and learning about indexes by using the explain function, profiling and the SQL_NO_CACHE option. My usual benchmarking session goes something like this: SET ...
0
votes
0answers
45 views

SQL Server 2012: query to see queries that are consuming more resources [duplicate]

I'm trying to find/build a query to show me those queries that are consuming more resources in SQL Server so that I can optimize them or at least have a statistical idea of what is really happening. ...
0
votes
1answer
2k views

Why does MariaDB 10.1.2 blow away MySQL 5.6.22 in sysbench?

Problem Maria DB is doing roughly twice the number of transactions that mysql is using standard oltp benchmark. The VM and db's are both fresh installs from vendor apt repos with default configs. ...
1
vote
0answers
393 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
1answer
409 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 ...
1
vote
0answers
448 views

Sysbench insert data between a given range

I was trying to insert 1,000,000 records of data into 1,000 tables in sysbench. But after installing about 278, sybench just crashed with the following error: FATAL: failed to execute function `...
0
votes
1answer
532 views

pgbench-tools failed authentication

I'm trying to configure pgbench-tools and went to run it per the README and got this error -bash-4.2$ ./newset 'Initial Config' psql: FATAL: Ident authentication failed for user "postgres" psql: ...
0
votes
1answer
279 views

Running identical queries in sysbench

When benchmarking using sysbench and utilizing concurrency (multiple threads) for example on a table with 1,000,000 records, does sysbench run "identical" queries in a loop on the table?
0
votes
0answers
1k 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
1answer
325 views

MongoDB Benchmark with write-intensive on geo-indexed DB

I am using PostgreSQL 9.3 on AWS RDS to store geo information into an indexed table of points. My data is write-oriented, meaning that I write nearly 1,000 points per each geo search query. I am ...
8
votes
3answers
25k views

How to benchmark Microsoft SQL Server

In my company we have multiple virtual machines hosting SQL Server 2008 R2 and some of these machines perform differently than others, some because of very busy Vmware hosts some because of slower ...
0
votes
0answers
83 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 I'...
1
vote
1answer
1k views

How can I measure the number of IOPs for a certain query

I need to estimate the max IOPs for a certain MySQL DB (one that does not exist yet). The OS is Linux and the DB is MySQL 5.1.x (though I don't think the DB brand is important for the asked topic) ...
1
vote
3answers
773 views

Clever repeatable benchmarking and bottleneck detection test bench - PostgreSQL

Has anyone usefull ideas, inspration or literature for me to design a good test bench for PostgreSQL. I need repeatable results, which are applyable in realworld and production environement (no ...
3
votes
2answers
2k views

How can I generate TPC-DS queries for PostgreSQL?

I'm using TPC-DS to run some benchmarks on a few versions of postgres that I have. I noticed that there is no template for generating the TPC-DS queries with the target database as postgres. The ...
4
votes
1answer
1k views

Running the DBT2 test results in 0.00 NOTPM

I'm trying to run the MySQL DBT2 Benchmark Tool, I have unzipped the archive and run the following commands: ./configure --with-mysql make make install mkdir /tmp/dbt datagen -w 3 -d /tmp/dbt --mysql ...
2
votes
2answers
2k views

any documentation on tpcc-mysql benchmark tool

Where can I find tpcc-mysql documentation? I google it but I can't find any documentation about it.
33
votes
1answer
23k views

How can I benchmark a PostgreSQL query?

I want to benchmark a query containing a user-defined function I have written for PostgreSQL. Are there any standard ways to run such a benchmark? I know that timing can be turned on with \timing at ...
2
votes
3answers
3k views

How to generate TPC-DS query for sql-server from templates

I know that dsqgen is used to transform the query templates into executable SQL. But when I type in the command line: "dsqgen /directory query_templates /template query1.tpl /dialect sqlserver /scale ...
3
votes
2answers
638 views

Running a TPC-C Benchmark Without sleep() i.e. key-in + think time

We are running a TPC-C benchmark against a PostgreSQL 9.2 server using JdbcRunner-1.2 implementation. During first few tests we were not getting a smooth (that is, without sudden spikes down to almost ...
0
votes
1answer
376 views

mysqlslap running very slow on a specific computer

I've recently discovered the tool mysqlslap and have run some simple tests with it. I currently have three test environments (2 Win 7, 1 Linux Ubuntu) where I can run these tests. However, running a ...
0
votes
2answers
1k views

MySQL Benchmark on FreeBSD and Ubuntu [closed]

I'd like to benchmark two db servers, one is running Ubuntu the other FreeBSD. Unfortunately we are unable to install SysBench on the FreeBSD OS. Could anyone recommend any alternatives? Or should I ...
1
vote
2answers
659 views

mysqlslap number in sql statement to change with iteration

I am trying to figure out how to increment a number in a mysqlslap query with every iteratiom. Let me explain what I exactly mean: I got a query: SELECT age FROM member WHERE id = [some number] ...
1
vote
1answer
581 views

SQL Server 2012 Performance Test

I've been given a task to test where an SQL Server 2012 can achieve better performances - we have two options: Use the SQL Server as an On-Premise machine (Standalone server that we have) Use the SQL ...
8
votes
1answer
7k views

I want to know about the IOPS (I/O Per Second) and How it influences the DB CRUD operation

I want to get a dedicated server for my Database (MySQL) which runs InnoDB Engine. There is this option in InnoDB capacity that you can define the IOPS in it. Let's say that I have a SATA 72K-RPM HDD ...