New answers tagged

0

Another way to copy files to the networked computer is to use source computer domain credentials - http://dba.stackexchange.com/a/128282/51798


6

You've addressed a boatload of items in your question. Thanks for being so thorough! Just a couple of things I notice off hand: How various hardware / load factors influence what should be done. Are you running a 24x7 instance? What is the load around the clock? I notice you have backup compression disabled; is that by design for the test, or ...


0

After one week investigation on Sql Server and having taken offline 3 more databases, it seems that I finally fixed the problem by rebuilding indexes on msdb system database. I took a look at fragmentation of indexes and most of them were over 50% average. Rebuilding indexes, sql job for integrity and full backup system databases came back to normal time ...


0

Issue the command: service mysql restart --skip-networking This prevents all TCP/IP connections. You can login as root@localhost and the client program will use the socket file rather than TCP/IP. Do all your DDL work. Can you shut down the web-server (if you're using one)?


0

Partial solutions: As root, do SET GLOBAL read_only = ON;. This will prevent write operations by every one by root. SET GLOBAL max_connections = 1;. But the trick is to grab that "1"; I don't have a clean way to do that. Note: With either trick, you may need to kill the existing connections in order to kick the connected users out. And "connection ...


0

As said by Brad Silva, you can skip connections, but you need to restart the mysql server anyway ( with --skip-networking ), as skip_networking is a read only variable. When finished, restart mysql without this parameter. EDIT: When I say it's a read-only variable, I mean you cannot simply set it in the console, like other variables you can switch at ...


0

Those changes will have no affect on the amount of time system backups take to run. As a first step I would change the job schedules so that the Integrity checks and System backups are not running at the same time. Also make sure that there are no other jobs running at the same time as either of these. If you don't have monitoring in place, jump on the ...



Top 50 recent answers are included