Questions tagged [database-administration]
296 questions
1
vote
0 answers
Move one site in Wordpress Multisite setup
I have a Multisite Wordpress setup with a dev box and a live. Whenever my developers change a theme on one of the sites or add a page/post/any other content on the deb box, I have to take the whole db and all wordpress files and move them to live.
I…
Toqeer
- 1,241
- 3
- 14
- 20
1
vote
2 answers
Low priority batch processes on live Mongo database
We want to run MapReduces on our live Mongo database, mainly so that we can extract metrics. However, we've had some bad outages caused by these MRs bogging down the Mongo server (in particular 100% disk IO). We think it's due to missing indexes.
Is…
moinudin
- 205
- 1
- 3
- 7
1
vote
3 answers
Are there measurable benefits to running XFS on EC2
I am looking at creating a PostgreSQL database image (to run on Amazon EC2) and I have heard good things about XFS.
However, since ultimately you are running in a VM, the gain of XFS on EC2 might not be as great as on a barebone system.
Am I going…
Goro
- 664
- 3
- 9
- 18
1
vote
1 answer
Table Space and Data Sized increased multiple times after power failure
We had a total power failure on our 2 node cluster using SQL Server 2008 (10.0.2531) Standard Edition. After recovery, everything is running fine. One issue I discovered is the Table Size and the Data Space Used has increased multiple times the…
Big Johnson
- 11
- 1
1
vote
3 answers
Configuring keepalives with TOAD client communication
I have a scenario where long-idle sessions of TOADSoft client communication with the Oracle server seem to be torn down as they timeout on an intermediate state-full firewall.
These sessions could be idle for multiple hours!
It is not acceptable to…
nik
- 7,100
- 2
- 25
- 30
1
vote
1 answer
SQLVDI error - attempt to release mutex not owned by caller
I've started getting some errors in the App event log of one of our database servers (Windows 2003 & SQL Server 2005). The nightly full database backups are completing successfully however immediately after the job success is written to the event…
Chris W
- 2,670
- 1
- 23
- 32
1
vote
1 answer
Index Proposals
As a theoretical database question, if you are asked 'which indexes would you propose and why?' are the answers from primary, clustering and secondary index? How would we know if we should introduce one of those vs a B-Tree?
This should be from a…
Torbal
- 43
- 3
1
vote
2 answers
create a 'definition' file from Oracle
I have inherited an oracle database, and have no Oracle experience. I have been tasked with building a 'clone' of the database on a new server. I am searching around, but not finding the things I am looking for, and perhaps my terminology is…
Brian
- 1,233
- 2
- 14
- 25
1
vote
1 answer
MySQL connection issue with error 2003 / 111
I'm running a mysql server using the following command:
mysqld --no-defaults --user=root --port=3310 --bind-address=0.0.0.0 --skip-grant-tables &
My understanding is that this command starts up a mysql server daemon as user root that will listen…
Kowshik
- 111
- 4
1
vote
2 answers
[MySQL]multiple-masters single-slave
Is is possible to have a setup where multiple mysql servers (containing different databases) are replicated in a single mysql slave server ?
If yes, how to do it ?
Knight Samar
- 119
- 1
- 10
1
vote
5 answers
Mysql large database backup
How can I backup a large database in mysql?
Folder size of Database is more than 5GB & contains 1.5 Lakh tables.
I have tried to backup server through phpmyadmin but no luck.
user103373
- 198
- 6
- 19
1
vote
4 answers
Mysql Slow queries log
Is their any way to filter mysql slow queries database specifically from /var/log/mysql/mysql-slow.log file. I have a mysql server with 5 live databases. I am trying to optimize this server.
Also I want to know what are the best practices for…
user103373
- 198
- 6
- 19
1
vote
3 answers
Can we restart a SQL Server instance remotely?
I am connecting to SQL server 2008 R2 from a remote machine, but when i right click on the instance in object explorer it shows me Start,Restart,Stop, Pause, Resume options disabled
I am connecting to default instance on server "DEXTER" [ip:…
Aamod Thakur
- 111
- 1
- 5
1
vote
6 answers
SQL 2005 Database Not Accessible
I've moved a database from sql 2000 to a new 2005 server. Everything was fine until I logged into Sql Server Management studio with one particular user. It looks like i logged in successfully but when I try to expand the database I get 'The database…
Sean
1
vote
2 answers
Sql Server 2008 R2 connection error
I have installed Sql Server 2008 R2(express edition) on my server and now I want to connect to that server from my client.
But it shows the following error:
cannot connect to SMSERVER\SMTECH
How can I solve this?
Kishore Jangid
- 129
- 1
- 1
- 7