The tag has no usage guidance.

learn more… | top users | synonyms

4
votes
1answer
58 views

Horizontally scaling SQLSERVER, distributing the database with Sharding

I wanted to know if there is any way to distribute a SQLServer (I'm using 2012 version) database accross multiple nodes. I'm trying to compare READ queries performance between SQLServer and Mongodb. ...
1
vote
1answer
88 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
52 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
97 views

SQL Server Performance: SELECT…INTO vs INSERT…INTO

I read couple of articles on comparing performance of SELECT...INTO vs INSERT...INTO. Some people even exaggerate that the first one is 10X or 100X faster! :) I tested it by inserting 25 million ...
0
votes
0answers
23 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
190 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
71 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 ...