Tag Info

New answers tagged

1

Since the production portion of this question hasn't been answered, I have an example of where it would be useful. I'm backing up a production table to my userspace. This table contains a lot of data (~850GB compressed) and backing up through normal means isn't possible because the log file it generates (over 18GB prior to me killing the insert) cause ...


0

You can use this query to show the size of a table: SELECT table_name AS "Table", round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB" FROM information_schema.TABLES WHERE table_schema = "$DB_NAME" AND table_name = "$TABLE_NAME"; or this query to list the size of every table in the database, largest first: SELECT table_name AS ...


0

The text value shows the procedure in which the statement that is being executed resides. The Command references the action of the executing statement within the procedure To find the exact statement within the procedure that is being called, you'll need to use the statement_start_offset and statement_end_offset from dm_exec_requests. Add the following to ...


0

This seems to be a bug that was introduced in MySQL 5.6.10 and has since been fixed (although there is no bug report on http://bugs.mysql.com that I can find). The behaviour described in the question does not occur in the latest version of MySQL. Observed behaviour in MySQL 5.7.5-m15: mysql> CREATE TABLE `Test` ( -> `id` int(10) auto_increment ...


0

This error came because ALTER command was not satisfied , it could be because of any reason. Table doesn't exists ,etc. In this case Begin Tran started but it didn't went through ..so it was not able to commit. So when you close the session, SSMS ask that " There are uncommitted transactions. Do you wish to commit these transactions before closing the ...


6

Why isn't it caught? Because TRY / CATCH doesn't catch all types of errors. But you can get it to catch the non-system-critical stuff by wrapping it in an EXEC(), such as: BEGIN TRY EXEC('ALTER TABLE...'); END TRY The error in the ALTER will fail out to the EXEC, which in turn will return to the TRY / CATCH block reporting a simple, catchable error. ...



Top 50 recent answers are included