Tag Info

New answers tagged

1

Perhaps you should dump the users and load the users into the VM Here is my post : Export all MySQL users After running the code in it and saving it to a file called MyDatabaseUSers.sql, you log into mysql on the VM and run this: mysql> source MyDatabaseUSers.sql This will create all the users with the same grants and passwords. Don't worry: ...


-1

@Jeevitha , While this question is off-topic on http://dba.stackexchange.com/ as I understood from this question what you are looking is for a software recommendation Pls use this stack exchange community to post questions for software recommendation. However I would like suggest that if you could look into Postgres Enterprise Manager,It includes the ...


0

When you have disable innodb, dont' forget to remove all innodb-related tables from Dbs. For example "mysql" database has 5 of them: root@ustimen.co$ mysql mysql -e 'show table status' | grep Unknown | awk '{print $1}' innodb_index_stats innodb_table_stats slave_master_info slave_relay_log_info slave_worker_info


0

You can detect any ddl changes by using trace file. below is script to get changes. SELECT te.name AS eventtype ,t.loginname ,t.spid ,t.starttime ,t.objectname ,t.databasename ,t.hostname ,t.ntusername ,t.ntdomainname ,t.clientprocessid ,t.applicationname FROM sys.fn_trace_gettable ( CONVERT ...


0

Check this out: [https://docs.oracle.com/cd/E11882_01/install.112/e47798/reqs.htm#NTDBI002][1] [http://docs.oracle.com/cd/B28359_01/install.111/b32006/reqs.htm][2] Probably you will get answers for such questions quickly if you google them.


0

You can use dbms_metadata to export to generate entire DDL of an Oracle schema, given the post I pointed out earlier in comment: How to generate entire DDL of an Oracle schema (scriptable)? Using the same package, you can generate the tablespaces DDL: select 'select dbms_metadata.get_ddl(''TABLESPACE'',''' || tablespace_name || ''') from dual;' from ...


1

Judging by the answer you gave in response to @Ozzie, I'm not sure you can do what you want. You can export the metadata of an 11gR2 database using expdp (Data Pump) and the METADATA_ONLY flag. See http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_export.htm This will export the structure of your data. This won't include redologs, controlfiles, ...


-2

What about specifications relating to price point such as size and color of a shoe.If the shoe colour is black and available sizes for that color are 6,7,8 each having different price points.How do you design it then


1

I wouldn't expect a copy operation to increase file sizes unless the file size was too small to begin with. SQL Server will first use unallocated space within data files before growing the file. Similarly, if the log file is large enough for the operation, that file shouldn't grow either. Also regarding log space usage, some operations can be minimally ...


1

Per the PostgreSQL tablespaces documentation: If a database is created without specifying a tablespace for it, it uses the same tablespace as the template database it is copied from. Per the CREATE DATABASE documentation: By default, the new database will be created by cloning the standard system database template1. You could either alter the ...


2

You can also look at the application event log. For SQL 2008 R2 instances, the event ID to filter on would be 8957 (at least for success codes).


3

Method 1: Easy way The Best way that i am using as of now is ola hallengren's SQL server Maintenance solution for SQL Server Integrity Check. Within this solution it gives you an option of storing the output or logging it to a table as per you're convenience: LogToTable Log commands to the table dbo.CommandLog. Please read the complete web link as ...


1

When talking about memory storage, the Hotel analogy also works well. But in this kind of hotel only one person is allowed in a room at a time; a man or a woman. This represents bit data. Ones and zeros. The max capacity of the hotel is 512 people. Before your hotel opens you decide to allocate only half of your rooms for guests. The allocated space is ...


0

Will you ever search by those parameters accross different products? It does not seem very probable to me. If you do not need to manipulate those in sql, only retrieve them for any given product, then store it as xml/json/anything in one blob column (or dynamic column on MariaDB). You then can get one product with all variants and maybe "filter" them by ...


0

This says 61. However, it could be an oversight that NDB is different.


3

Think of your database like a bucket. The ALLOCATED space is how big the bucket is, i.e. how much data it can hold. The USED space is how much water/data is actually inside the bucket. When the water gets to the top of the bucket, you need to make the bucket bigger by allocating more space.


0

I now see that Balasz has provided a solution, too. My solution works if the name of the database is FooB, and I see now that that isn't the case here. So Balas will be right. But I leave this post because it seems not to be widely known that this works. From Administrator's Guide, 31 Distributed Database Concepts, Global Name as a Loopback Database ...


1

What you described here is absolutely normal and intended. This feature is called a global database link: http://docs.oracle.com/cd/E24693_01/server.11203/e17120/ds_concepts002.htm#i1007888 It is a "side effect" when for example Oracle Internet Directory is in use, I have seen this at a few companies who have a lot of databases. More and better ...


3

In my opinion putting the tempdb in the SSD drive without looking at the performance stats is the wrong way to go. SSD drives have high cost/GB and are a premium resource that should be used in the best possible way. You will probably get better performance moving the most used database files to the SSD, given that you already have broken your database into ...


1

Version store basically cause from long running transaction or high transaction throughput. You need to look for the queries which are causing this. Other than that version store is used in following conditions: Row version which are generated by data modification transactions for features (MARS, online indexes, AFTER trigger etc) Row version which are ...


3

Why do you think clustering will help performance? There is no such thing as active/active anyway - a failover cluster exists to provide a fallback so that the database can continue running if the hardware fails (the database is only ever active on one of the cluster nodes at any one time). Clustering <> load balancing. If you mean splitting up the data ...


1

As this answer on Stack Overflow indicates there is no built in functionality to do what you want but there are alternatives: export your tables to csv files and then import into MySql using LOAD DATA INFILE. This solution does not scale well for large databases or schemas with clobs and blobs that are images or documents. SQL Developer can help you ...


0

Ugliest paste in history. Be aware if your slave does not have significantly more hardware than you M1 and M2 it will probably lag behind in replication. This requires nothing special from setting up normal replication. Copy the M1 data (either mysqldump or some other suitable solution) to the first instance, login into the first slave instance and execute a ...


1

You can easily change the schema ownership to dbo, then you should be able to drop the user, and add them back using ALTER AUTHORIZATION: ALTER AUTHORIZATION ON SCHEMA::[schema_they_own] TO dbo; DROP USER [user_name]; ALTER AUTHORIZATION ON DATABASE::[database_name] TO login_name; Now, they will be the dbo user in the database (and will have automatic ...


0

You can't use sysadmin (sa) if you register shared hosting. You need to create your database via their control panel, then you can manage your database via your CP. Or some providers allow to connect remotely. For more information, just contact your hosting provider. Good luck



Top 50 recent answers are included