Hot answers tagged database-administration
6
I'm going to take a guess that you are using automatic storage. (Not that this could happen otherwise...it is just easy to have this happen with automatic storage.)
The problem is most likely that your database reclaimed the space for itself but did not release the disk back to the operating system. This can be shown very easily by checking the High Water ...
3
How are you coming to the conclusion that "these files contain some data even after graceful shutdown"?
Even if it's been fully flushed and uncommitted transactions cleared, etc., by using innodb_fast_shutdown = 0, the "flushing" probably means that the file is "empty" as far as MySQL is concerned, but it won't physically be full of zeroes.
If you start ...
3
The steps you outlined are correct.
I have written about this before
Feb 16, 2011 : How to safely change MySQL innodb variable 'innodb_log_file_size'?
May 30, 2012 : mysql wont start after increasing innodb_buffer_pool_size and innodb_log_file_size
Doing innodb_fast_shutdown = 1 is incomplete because ibdata1 still have other transactional tidbits that ...
3
Unfortunately, it's not possible to take an online backup of a DB2 database if it's in circular logging mode, which is the default for DB2 databases when they are created.
You can check whether your database is using circular logging by issuing:
./db2 get db cfg for dbemp | grep LOGARCH
If both LOGARCHMETH options are switched off...
First log archive ...
2
Online backups require that the database be enabled for rollforward recovery. However, this is not the default when you create a database.
In order to do this, you need to set the LOGARCHMETH1 database configuration parameter. Once you have done this, you'll need to take one offline backup (i.e., no users can be connected).
Once you've completed these ...
2
You'll have to manually query for the rows and copy then in using either T-SQL or SSIS. There's no way to take the two databases and have SQL Server just merge them into one database.
If you are using identity vales on tables you'll need to be careful of duplicate values and assign new values to the rows that you are inserting. If you have other tables ...
2
You seem to have omitted the new version of the upgraded server, but I strongly suspect it's still on 8.1 since the ALTER SEQUENCE ... OWNED BY clause was added in 8.2 (Compare ALTER SEQUENCE docs on 8.2 to ALTER SEQUENCE docs on 8.1).
You really need to understand that 8.4 and 8.1 aren't slightly different versions, they're massively different. It's like ...
2
Normally it should happen quickly.
There could be large transactions that take a while to rollback, or a long running transaction that takes ages to end.
If the time is spent for the rollback, you could crash the instance with a good and solid kill -9 on the server procs and use parallel instance recovery. Normally this should not happen but parallel ...
2
DB2 Express-C version 10 and later no longer include a full suite of administration tools as part of the installer (the "Administration Tools" you installed might only include the ones you're looking at...).
Like MySQL and SQL Server, the administration tools are now available as a separate download.
The official tool you're looking for is IBM Data Studio, ...
2
The table MY_TBL contains large binary data in a BLOB column. The documentation of the REORG command says that DB2 avoids reorganizing such objects because it is time consuming and does not improve clustering. However, DB2 can be forced to reorganize LOB data if the LONGLOBDATA option is specified. The unused space can be reused by DB2, so inserting new data ...
2
There is a small problem in your aproach, if I understood correctly, you changed the log file size, and restarted the MySQL with innodb_fast_shutdown = 0. The problem here is that you still have some transaction on log files that aren't in the ibdata. What you need to do is tell MySQL to write all changes from log files to ibdata before move the log files, ...
2
PostgreSQL does not allow you to do this inside PostgreSQL. You cannot create a database inside a transaction so procedural language functions cannot create databases or drop databases. I hope some day this is corrected, but it is the one piece of DDL that does not work inside a transaction.
What this means is you have to do it from outside the database ...
1
If your database has 16 MB of free space, and the drive it's on has plenty of free space, then don't worry about it. As long as there is sufficient space and you haven't disabled the database's ability to autogrow, then the database will grow the data file when it needs to. Of course you should set your data file's autogrow to some realistic increment, ...
1
Suppose you've a blog every blog have some users and posts. Every post belongs to a user. So in that case you can create a relation on user BELONGS TO posts in yii framework.
relation in yii can be defined as :
'VarName'=>array('RelationType', 'ClassName', 'ForeignKey')
In case of post every post belongs to a user. So relation looks like this.
...
Only top voted, non community-wiki answers of a minimum length are eligible
