This seems to be an overlooked area that could really use some insight. What are your best practices for: making an upgrade procedure backing out in case of errors syncing code and database changes testing prior to deployment mechanics of modifying the table etc... ...
I downloaded a VM image of a web application that uses MySQL. How can I monitor it's space consumption and know when additional space must be added? ...
When I shrink a sql server database using the GUI (All Tasks->Shrink Database->Accept all defaults, click OK), it finishes quickly. But if I run this command, it takes a very very long time. DBCC SHRINKDATABASE('my_database') What am I missing? This is in SQL Server 2000. ...
I'm several layers/levels above the people involved in the project I'm about to describe. The general requirement is for a web based issue management system. The system is a small part of a much larger project. The lead pm has a tech pm who is supposed to handle this portion of the project. The lead pm asked me if it's normal for t...
I know there is an SQLite Manager Extension for Firefox but, really, I don't like to do that from within a Web Browser. That's totally uncool. And I don't want to install Firefox just for that. ;) I hope there are other good tools, although that firefox option doesn't look too bad. But let's see if there's something better out there... ...
I have a MySQL database, it is getting larger and larger and I want to move the whole database to another mount point, where I have enough storage. I want my current data to be transferred, and that new data get saved to the new position. software stack: MySQL 5 running on FreeBSD 6 ...
I just installed Oracle on my Amazon's Virtual EC2 Linux (Ubuntu) Server. Because i'm not really familiar with Oracle Database Administration I'm wondering what files and how i need to move to ESB so when i shut down or terminate my instance the data won't be lost. I have found THIS tutorial, but i'm not sure if this is what i need. ...
I am frustrated of not having a good Linux GUI administration and development tool for PostgreSQL. pgAdmin III is buggy and unusable piece of... hmm, software, compared to Windows-only PostgreSQL Maestro and EMS PostgreSQL manager. phpPgaAmin does not looks promising. EMS PostgreSQL manager can work under Wine, but such setup have a n...
I am working with a postgreSQL database that gets updated in batches. I need to know when the last time that the database (or a table in the database)has been updated or modified, either will do. I saw that someone on the postgeSQL forum had suggested that to use logging and query your logs for the time. This will not work for me as t...
What are the differences between the Oracle SYS and SYSTEM built in accounts? Edit: Apart from 3 letters! ...
Is there a tool that I can give a few people access to so that they can quickly modify the contents of our database? I'm looking for something easy to use and general purpose. phppgadmin is going to be too complicated for some of the people that will be using it. I really like the django admin, but some of the constraints that Django ...
Is there a way to restore an Oracle 11g instance from raw data files only? What is the minimum amount of information needed to reconstruct the config files? ...
...and how should those permissions be granted. I work in a large IT dept with 70+ applications, some in SQL server and most in oracle. Each system has a prod, QA and Dev instance. We (I'm a developer) have readonly access to prod/qa, which I'm fine with. In SQL server development instances devs are given db_owner, which works totall...
I'm deploying a client application to several thousand windows machines. Each machine will use a sqlite database as a local datastore, ultimately writing data to a remote server. So the sqlite db won't really grow over a few MB over time, since data will be added and then later deleted. SQLite is supposed to be zero-administration, but a...
How to detect a column included in WHERE clause but used in indexed? Little Background: Until the time the table has few number of records things will be okay, once it started having millions of records then index should be created for a column which is used in WHERE clauses in stored procs, inline queries etc., Since we have hundre...
I'm looking for a simple database admin tool that will allow non-technical users to perform data-entry into a database (imagine a striped down version of phpMyAdmin). It would preferably allow the developer to set restrictions on which tables and fields can be modified. Edit: Most of the tools posted, so far, are developer oriented. I'm...
I would like to understand how this happened. I was running a query that would take a long time, but should not lock up any table. However, my dbs were practically down - it seems like it was being locked up by "FLUSH TABLES WITH READ LOCK" 03:21:31 select type_id, count(*) from guid_target_infos group by type_id 02:38:11 select type_...
I know this sounds weird, but apparently one of my columns is locked. select * from table where type_id = 1 and updated_at < '2010-03-14' limit 1; select * from table where type_id = 3 and updated_at < '2010-03-14' limit 10; the first one would not finish running even in a few hours, while the second one completes smoothly. the only ...
When i run a mysql select statement, it takes very long because i have already previously deleted a very large number of rows. Is there a way for the table to start scanning from the bottom, as opposed to from the top? ...
I truncated several huge tables, but the mysql file and database appears to remain at the same size. Does truncate table delete the data from mysql as well? ...