The tag has no wiki summary.

learn more… | top users | synonyms (1)

0
votes
1answer
70 views

Validate SQL Server partitions and filegroups

Information: I took over a SQL Server 2005 that the previous DBA had configured three filegroups to segregate the data onto unique LUNs: G: Data (Primary) F: Audit J: Index However, the ...
3
votes
2answers
2k views

With MySQL, how long does an “ALTER TABLE … DISABLE KEYS;” statement last?

If you disable the keys (suspending indexing) on a mysql INNODB table, how long does that setting last? For a query like: ALTER TABLE users DISABLE KEYS; Do the keys get re-enabled at the end of ...
0
votes
1answer
102 views

Managing multiple storage volumes in Microsoft SQL Server

I have a backup application backed by many databases (one per client) in Microsoft SQL Server, storing files in the database as BLOBs. We are looking to move this application to Amazon EC2, and ...
1
vote
1answer
91 views

Does MS SQL 2005 encryption protect data in the case of physical server access?

I am looking into MS SQL 2005 encryption (not 2008, so TDE is out), and I believe I understand the concept of how a column is encrypted. The OS uses the service credentials to encrypt the service ...
1
vote
5answers
953 views

Moving MySQL Data from 1 RDS server to another

How do I go about moving certain data (returned by a simple query) from one database in AWS' RDS to another? An interruption of up to 20 mins is acceptable, although not preferred. My current plan ...
4
votes
3answers
225 views

Naming convention for databases and database users for access by a web application?

When installing a web application where a single user is used to talk to a single database (say MySQL, but this could apply to other RDBMSes also), you often have a sequence of events such as this: ...
0
votes
3answers
219 views

Finding an optimal balance of I/O, CPU, and RAM for MySQL

For a long time I’ve wanted to know how MySQL scales as you add more memory to the server.We looked for a balance between utilizing the hardware as much as possible, limiting the system complexity, ...
0
votes
2answers
175 views

SQL Server: best account for dbo user?

What is the best account for dbo user? I mean that if I use personal AD account for database owner, and if this account is removed from AD (e.g if I leave my job), these databases are not accessible. ...
1
vote
1answer
75 views

clustering MS SQL 2008 [duplicate]

Possible Duplicate: Sql server active/passive vs active/active clustering I have a Project in DBMS just I need something like a BIG TITLES of What TO DO. Here a brief way about the ...
0
votes
1answer
116 views

Optimizing MySQL Database for wordpress

I am maintaining a blog with self hosted wordpress. For the last 5 months, my blog isn't really active as I hit "Server Error 500". The error says "The FastCGI process exceeded configured activity ...
0
votes
1answer
120 views

Mysql slow query log issue…?

Analyzing the slow query log of my mysql database server, i found an interesting query taking more time and making issues in performance of my application.Please help me to find out the issue ? # ...
2
votes
2answers
4k views

How well does PostgreSQL perform with a large number of databases?

We have an web application whose architecture requires that any registered user (a company, actually) should be isolated from the other, i.e., I'll run the same webapp with the same data models, but ...
4
votes
2answers
2k views

After setting root password why does MYSQL still allow me to login without a password?

After setting root password why does MYSQL still allow me to login without a password from the command line? I can type "mysql" at a root unix prompt and it asks for no password and still allows me ...
0
votes
1answer
122 views

What are the dangers/consequences of reducing the SharePoint_Config_log database?

I have used DBCC ShrinkFile on a SharePoint_Config_log database and I'm wondering what the consequences of this action may be? The log file was growing upwards to >11 GB for an 8GB database and space ...
1
vote
3answers
109 views

What's the best tool for managing database evolution/versioning?

We need a tool for dealing with database evolution/versioning. And we need the best! :) Can you expert guys help us to find a great tool that has these features? Conceptual Model: The tool must ...
1
vote
1answer
112 views

Oracle EE 11.2g: how to generate fresh new redo logs

In the company I work for we are heavy users of vmware machines. Almost all our projects are developed inside a virtual environment up to the point where we have to deploy them into a production ...
1
vote
1answer
76 views

What's the best way to split client sites in a PostgreSQL installation?

I need to host several client sites using one PostgreSQL installation. What's the best way to split them -- by schema or by instance? The factors would be what makes admin easier (especially ...
3
votes
4answers
472 views

Best practices for SQL Server audit trail

I'm facing a situation today where it would be very beneficial to me and my company if we knew who had logged into SQL and performed some deletions. We have a situation where at least 2 (sometimes 3) ...
0
votes
1answer
2k views

On MySQL 5.1 for Windows, why can't I assign DBA role to the “root” user?

On MySQL 5.1 for Windows, why can't I assign DBA role to "root" user? The MySQL Workbench allows me to add all the other roles except for DBA. Also, when I "alter schema" on any table, while ...
0
votes
2answers
307 views

What Could Be Causing MySQL To Crash On A Read Query?

So I have a pretty large MySQL DB... 7 Gigs in Total size, 35 million URLs. I was querying it (using SELECT queries only) quite fast the other day. My ubuntu froze/shutdown (that's a first!) and said ...
0
votes
2answers
666 views

How to do MySQL Maintenance especially after disk is full

I have a quite large mysql database (InnoDB) running on ubuntu server virtual machine. Recently due to my fault the hard drive became full (on the physical machine) and the server got stuck and users ...
3
votes
2answers
1k views

Why is my database not available?

I have one database on my server that constantly becomes unavailable. To fix, I take it offline, then back online. Looking at the event viewer there are three errors in quick succession: FCB::Open ...
1
vote
2answers
152 views

Linux: How to rename old mysqld when upgrading MySQL?

I'm upgrading MySQL from MySQL 5.0 to Percona Server 5.1. I'm planning to just use yum remove and yum install to do the upgrade. However, I read in the documentation that it's a good idea to rename ...
1
vote
1answer
2k views

What is the best way to determine what's locking up SQL Server using a query?

Recently our SQL Server is getting bogged down by something. I was wondering what is the best way to check what could be causing the problem by querying the database. This is the best I've found so ...
2
votes
3answers
3k views

MySQL maintenance - how to clear the buffer?

We have a server running our web app (PHP / MySQL) which is SLOW. My predecessor says that: "We use to do database maintenance, which use to clear the buffer, cached and unwanted variables." And I ...
0
votes
1answer
616 views

SQL 2008. How to let user to create/alter sprocs in only one particular schema?

I have a user which can read and write but now he needs to be able to create/alter a sproc but giving him ddl_admin will make it too unsecure. I dont trust him that much. What can I do about it? Can ...
1
vote
1answer
2k views

Cannot open DTS packages in SQL 2008 x64

We are deploying a new MS SQL 2008 R2 x64 server running on Win 2008 R2 x64. We need to open DTS packages but receive the error: "SQL Server 2000 DTS Designer components are required to edit DTS ...
0
votes
1answer
2k views

Easiest way to export functions from a MySQL DB

I am migrating a bunch of changes from our dev database, consisting of some extra tables, the data from a subset of these tables, and some new functions. Using phpmyadmin I have exported the structure ...
0
votes
1answer
339 views

Can MySQL use roles without MySQL Wokbench?

I have only found documentation about roles in MySQL through the use of Workbench, is there an alternative way to set them?
1
vote
2answers
305 views

SQL Server Replication Backup

We have a new system that runs on SQL Server 2008 r2 64-bit. There is a primary on-line transactional processing (OLTP) database that accepts a high volume of updates from several thousand Point of ...
0
votes
3answers
536 views

Restoring a backup SQL Server 2005 where is the data stored?

I have two Sql Server database instances on two different machines across the network. Lets call these servers A and B. Due to some infrastructural issues, I had to make a complete backup of the ...
0
votes
1answer
2k views

How to copy marked lines in a Textpad…?

I had exported the table structure of my live Database.And open it with help of Textpad.It is very huge file and i want to copy a particular lines from the textpad.I mean,i want to copy marked lines ...
2
votes
3answers
2k views

Access to SQL Server when administrator account deleted

An interesting situation here. We have a database server, used for testing only, where someone went in and deleted the administrator login. Since this is a test server the was no other admin level ...
0
votes
1answer
209 views

Error 2003 is Occurring when connecting MYSql through SQL yog tool

i couldn't able to login to my mysql database through SQLyog tool.The screen shot of the error is shown below and i can login the database through SSH Secure Shell.
0
votes
2answers
403 views

Setting up mysql on mac

I have successfully installed mysql on my mac, and now on the command-line I can type which mysql and the mac replies back the expected path. I would like to get started with the tutorial here. But ...
1
vote
1answer
28 views

MySQL installation on Mac isn't working

I just installed mysql on my Mac per these instructions. However, at the command line which mysql and which mysqld replies nothing. How do I get from the above link to this tutorial link?
4
votes
4answers
3k views

How to shape size of SQL server resorces (RAM, CPU, and others)

It is standard story, there is fight between developers and administrators. One denunciation that database design and queries are bad while others says It is lack of hardware and amount of data. So ...
3
votes
2answers
257 views

What are some reasons why a MySQL index would be 12X the size of the table?

So we have a table that has two indexes one on the primary key and one other index on another column on the table. The index size is currently 12X larger than the table itself. What are some reasons ...
0
votes
1answer
1k views

Import remote postgresql database via ssh?

I have two machines: Remote, Ubuntu server, example.com, database: staging (owner user2, pass2), passwordless login for user1 (sudoer) via ssh Local, Ubuntu, localhost, database: local (owner user3, ...
1
vote
1answer
280 views

Database maintenance plan fails to run everytime

I currently setup a DBMP for SS2008 and i explicitly set it to run under a user that is the the serveradmin role. Also in the job (under sql server agent) generated from the above plan is set in the ...
0
votes
1answer
208 views

long dataset of small rows — infrequent writes, very frequent reads — what's the best platform?

A part of the platform I am building requires a large data table (starting at tens of millions of records, scaling to hundreds of millions within a year or two, maybe reaching billions at some point). ...
1
vote
3answers
192 views

How to automatically move specific MySQL tables from one machine to another?

I have a MySQL database with tables in the form of "shard_0", "shard_1", "shard_2", etc. I want to add another DB server and move the even-numbered shards ("shard_0", "shard_2", "shard_4", ...) to ...
0
votes
1answer
311 views

Possible to programmatically ALTER multiple MySQL tables?

I have multiple MySQL tables with names of the form "Shard_0", "Shard_1", "Shard_2" ... "Shard_n" All of them have identical table structure. They all live in the same database. Say I want to add a ...
1
vote
2answers
4k views

Any way to copy the schema from one MySQL database to another?

I have a MySQL database that contains almost 100 tables. I want to set up N additional MySQL databases on the same server, each running on a different port. And I want each additional database to ...
0
votes
1answer
149 views

SQL Database Admin or Developer?

Can someone explain the main difference between each? Which one do you consider more difficult? Which one is it easier to find and maintain a job? Im trying to start the first stepping stone of doing ...
6
votes
3answers
6k views

Becoming a DBA, what do I need to know?

Im sure this has been asked, but times change and so do SQL preferences etc... I figure this place would be the best place to ask this im sure many DBA's come here. But what do I need to know ...
10
votes
1answer
18k views

What can user do with VIEW SERVER STATE permissions?

In SQL Server 2008 there is a permissions VIEW SERVER STATE. What rights this permission give to user? What SQL Server mean by SERVER STATE?
3
votes
3answers
3k views

Shrink SQL Server data file, but not all at once?

I have a database file that's currently 150GB, but only 75GB is being used - it's because I moved all the indexes (the other 75GB) to a new data file. I'd like to reclaim at least part of the space ...
0
votes
1answer
117 views

SharePoint admin configuration inaccessible

I successfully moved three out of four SharePoint Service databases from one database server to another, except for the admin content database. Now I am unable to access the Admin Configuration on ...
2
votes
1answer
1k views

How to setup two mysql servers in Synchronization mode

Infrastructure I have two database servers, running on two different boxes. One works as a primary database for my web application and other works as secondary database. Secondary data base is ...