New answers tagged

0

InnoDB Please note the InnoDB Architecture (picture courtesy of Percona CTO Vadim Tkachenko) If your database is read/write, I wrote about why InnoDB cannot allow multiple instances Apr 24, 2014 : Two MySQL Server accessing same database over NFS Oct 03, 2013 : Is there any way to use different InnoDB settings for different databases on the same server?...


1

NO! Do not attempt to have the same files accessed by different instances of MySQL. The code has now way of coordinating access between them. (If it did, it would slow MySQL down to a crawl.)


3

The primary database file can never be removed because it contains special page structures that exist only on that file and cannot be relocated. If you want a single database file, move all data from the secondary file using DBCC SHRINKFILE with the EMPTYFILE option and then remove the secondary file. Finally, rebuild/reorganize indexes to reduce ...


1

Space will not be the only factor in where you place the new space. If you are talking about expanding the capacity of the existing drives you should look at what do the underlying volumes have backing them. I.e how many physical drives are assigned to the drive arrays and what the RAID levels are for those arrays. For HDDs the more drives you have in an ...


0

My Data files are always kept in a separate drive from where the SQL install took place. Therefore, databases like master, model, msdb, and tempdb are always on one drive, while my (user) databases are on (one or more) separate drives. This is not so much for performance reasons as it is for Disaster Recovery/Security. it is much easier to restore a SQL ...


1

This error is produced for various reasons stated below: Too high activity - Re-running the job during a less busy period can fix this ORA-00060 deadlock error. Poor application design - As noted in the trace file: "The following deadlock is not an ORACLE error. It is a deadlock due to user error in the design of an application or from issuing ...


2

how to change the file directory of your log and data files and what are the effects Can I just change the settings of the instance to point it to the new directory, detach the existing databases move the data files and attach it back? Please share what would be the best approach in doing this. Below are two scripts I've used for this purpose ...


0

I had the same problem with the extra 4 bytes being added to the beginning of all of my files as well. Instead of using -N option in my bcp command, I changed it to -C RAW. When you do this, bcp will be prompted with the following questions: Enter the file storage type of field FileData [image]: Enter prefix-length of field FileData [4]: Enter length of ...



Top 50 recent answers are included