The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
1answer
83 views

Things to keep in mind while editing Mysql “my.cnf” file

Today I tried to boost mysql's(installed in my system Ubuntu 14.04) performance as I have many sites(PHP/Magento) installed in my system which relies on mysql as database server, but when I edited the ...
1
vote
0answers
14 views

How to time SPARQL queries on an Oracle12c database?

I have an Oracle 12c instance setup with an Apache Fuseki endpoint sitting on top of it. I am able to query the database using the Fuseki endpoint. I want to be able to get the execution time of some ...
1
vote
0answers
44 views

Compare Traces with RML Utilities

I am new to RML and am trying to use it to capture a trace, replay it on another server and then compare the two. I have managed to capture a trace using the server side script that comes with it and ...
0
votes
0answers
19 views

Performance Comparison using extended events

I am using SQL Server 2012. In my development database I have an old (MySP_Old) and new(MySP_New) versions of a stored procedure. This procedure has around 10 big queries in it. I need to compare each ...
0
votes
0answers
14 views

Memcached innodb plugin load testing

I am testing with memcached innodb plugin for MYSQL and so far I have been able to create containers and insert data. This works well for me. I only have one issue and that is to load test/stress ...
0
votes
0answers
27 views

Replay Trace Results Slower On Better Server

I have captured a trace and replayed it using SQL Profiler on my new server capturing another trace at the same time. I am using DBSophic Qure Profiler to compare the traces as it compares each query ...
0
votes
0answers
161 views

Tunning MySQL Variables

we have a dedicated mysql server with 10 CPU and 32G of memory After doing some readings came up with those configs : # This was formally known as [safe_mysqld]. Both versions are currently parsed. ...
0
votes
0answers
70 views

How to handle too many instances of multiple tables?

If there is a table accessed by multiple DB threads ( for example 100) at a time then how many instances of that table will be opened? If I run show open tables and see that in_use column value of a ...