[how to] How do you find the right Path? [closed] |
- How do you find the right Path? [closed]
- Why is a hash match operator in this very basic query
- Restore standby database with undo rollback file
- Limiting number of results in a Partition using OVER(PARTITION BY)
- Very fast replication
- mysql optimize table crash
- which postgres do i have installed? what directory needs to be in my path to run initdb?
- mysql master master replication issue
- Copying my Oracle 10g Express database to another PC
- MySql Cluster for educational use
- Oracle 11g R2 on CentOS 6.3, and Net Configuration Assistant
- mysql second slave not syncying while first slave works fine
- Mysqldump from the Amazon RDS
- MySQL - ERROR 1045 (28000): Access denied for user
- For a InnoDB only DB, which of these elements can be removed?
- MySQL inserts/deletes slowing down after a while after Start/Reboot
- Is it possible to have extra tables in a Slave with MySQL Replication
- MySQL 5.1.67 - Replication failure Mysql, Master Log Truncated or corrupted
- Replication issue - CREATE SELECT alternative?
- SQL Server replication subscriptions marked as inactive
- How to drop a DB2 instance when the instance owner was removed
- How to Convert Horizontal to Vertical Array?
- Ensure correct username when using pg_restore
- How to script out push subscription creation at the subscriber?
- Can I monitor the progress of importing a large .sql file in sqlite3 using zenity --progress?
- Why is Database Administration so hard?
- Are there any good tools for monitoring postgresql databases
- How do I list all databases and tables using psql?
| How do you find the right Path? [closed] Posted: 31 Mar 2013 03:34 PM PDT Now, I understand that this might be the wrong place to be posting, and i apologize if it is, but I am out of ideas and out of my depth in trying to understand the system/path of becoming a DBA. I have just started to teach myself SQL and I really enjoy it, so naturally the first question that comes to mind is,"How do I turn this into my career?" I've been searching all the forums I can find to try and understand what it is that I need to do to get on the right path, with no luck. I have found a great deal of useful websites, but nothing that can help me right now. So now I turn to you ladies and gents, I am aware that it wont happen over night and I'm not worried about starting at the bottom and working my way up which brings me to my question(s)... Where do I start? How do I start? What position am I supposed to be applying for? Thanks in Advance, Fabian. |
| Why is a hash match operator in this very basic query Posted: 31 Mar 2013 04:31 PM PDT I'm beginning to learn some about looking at execution plans and making queries more efficient Consider these two basic queries and their execution plans index being used: Even though the first query supposedly has the higher cost by a 4:1 margin it runs faster than the second one. Why is it that a simple distinct added to the query will add the (what I assume to always be bad, corrections are welcome) hash match operator? And why does it have the higher query cost relative to the second query if it runs faster. |
| Restore standby database with undo rollback file Posted: 31 Mar 2013 05:57 PM PDT I made full backup to specific database and restore it with stand-by recovery where data-base in read-only I tried to insert value or edit to table in this database but not inserted this values stored in undo rollback file I want after I restore database to read-write How I can recover this inserted value to table and cheak it existed in the table ? |
| Limiting number of results in a Partition using OVER(PARTITION BY) Posted: 31 Mar 2013 05:56 PM PDT In the following query, why is it that we have to limit the results returned from each Partition by using the clause Query Query that does not work Error: |
| Posted: 31 Mar 2013 05:05 PM PDT I used this guide to make replication between my two db servers : http://wiki.postgresql.org/wiki/Streaming_Replication But, when I updated a row on master server it will be available in slave instantly. It should be asynchronous , isn't it? What I am missing? Thank You |
| Posted: 31 Mar 2013 11:27 AM PDT When I try |
| which postgres do i have installed? what directory needs to be in my path to run initdb? Posted: 31 Mar 2013 10:41 AM PDT I need to use postgresql with ruby on rails. I have these directories and This 2nd directory name is confusing. In finder, when I'm in the directory is actually one directory with forward slashes in the name. usr/local/Cellar/postgresql. It's in terminal where I see the :'s "brew info postgres" returns the following: So do I have postgres installed properly? Do I have 2 versions? One in Library/PostgreSQL and one in /usr/local/Cellar (via HomeBrew)? Regarding trying to use initdb to create my first postgres database: I have ohmyzsh installed and I am trying to run the initdb command but getting command not found. Which path should I put in my path statement so that it can find the command? /usr/local/var/postgres/server.log did not exist, so I created it. pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start says server is starting and when I do ps auxwww | grep postgres I get: so I think that means it is running, right? Well I found initdb script file in both Library and brew locations. I navigated to the brew directory containing initdb and tried to run the initdb command and got zsh: command not found. I then navigated to the Library containing initdb, tried to run it, and got the same results. Isn't the current directory part of the path because I'm IN IT? Summary of my questions:
|
| mysql master master replication issue Posted: 31 Mar 2013 05:18 PM PDT I have set the 2 database servers with master-master replication. On both servers, the following parameters are showing properly when I check the slave status Slave_IO_Running: Yes Slave_SQL_Running: Yes But there is a database size difference between these 2 serves Could some one give me the solution for this? |
| Copying my Oracle 10g Express database to another PC Posted: 31 Mar 2013 07:36 AM PDT I have Oracle 10g Express. How can I make a copy of my database and application? I don't want to make a back up, I want to move my DB and application to another PC. |
| MySql Cluster for educational use Posted: 31 Mar 2013 09:50 AM PDT I am student and I am writing Master of Science paper about in-memory databases. I want to use MySql Cluster for benchmarks in my work. |
| Oracle 11g R2 on CentOS 6.3, and Net Configuration Assistant Posted: 31 Mar 2013 10:41 AM PDT this is my first time to install Oracle 11g R2 on Linux. I made all instructions in Oracle documentation. But in the installation process, the Net Configuration Manager is failed. I continued the process, and after it finished, I couldn't connect to the sqlplus. This is my and Output of I open But the program told me that the port is in use. I deleted it and added a new one but the same warning that port is in use ** Solution: ** Finally I found the solution, that I didn't change permission to be owned by |
| mysql second slave not syncying while first slave works fine Posted: 31 Mar 2013 10:14 AM PDT I have a master (m) - slave (s1) setup using mysql 5.1.45 When I try to add a second slave (s2) the slave lags behind and never catches up on the sync. Even after having synced the s2 with the whole system offline and there were (Seconds_Behind_Master = 0) after a few hours the s2 gets out of sync. Strange is that s1 is always on sync. any ideas? iperf results between servers: vmstat for s2 top output on s2 |
| Posted: 31 Mar 2013 10:02 AM PDT I have a Mysql database deployed on Amazon web services RDS. I am running a crontab which runs mysqldump command. The problem is it freezes the rds instance and my website will be down for more then half and hour almost. It will be inaccessible. Is there any way to stop the freeze during the dump and website will be accessible during the dump also. |
| MySQL - ERROR 1045 (28000): Access denied for user Posted: 31 Mar 2013 10:25 AM PDT I just installed a fresh copy of Ubuntu 10.04.2 LTS on a new machine. I logged into MySQL as root: I created a new user called repl. I left host blank, so the new user can may have access from any location. I checked the user table to verify the new user repl was properly created. I then exit, try to login as user repl, but access is denied. Why is access denied? |
| For a InnoDB only DB, which of these elements can be removed? Posted: 31 Mar 2013 10:41 AM PDT So, I'm trying to set up a Drupal 7 my.conf file that's combining best practices from various performance blogs. I'm realizing though that some of them are older than others, and many aren't assuming InnoDB. So of this list of configs, which are irrelevant if you're building for InnoDB. |
| MySQL inserts/deletes slowing down after a while after Start/Reboot Posted: 31 Mar 2013 10:49 AM PDT The Setup here is: OS: Ubuntu 12.04 (1 Core and 1.75 GB of RAMO) MySQL Version: 5.5 There are about 8 to 9 tables in the database. On initially starting mysql the queries are fast at around 0.05 - 0.10 seconds, however after sometime the INSERTS and DELETES slow down to around 1 - 2 seconds, however the SELECTS are still around 0.05 - 0.10 seconds. Then after rebooting the system the situation reverts back to how it was in the beginning of the previous paragraph. Everything is fast, but then INSERTS and DELETES slow down tremendously after a while. Note: I'm just doing simple inserts and deletes on very few records, and the database starts with empty tables in the beginning. Any insight? Edit: Create Table of 1 of the Tables |
| Is it possible to have extra tables in a Slave with MySQL Replication Posted: 31 Mar 2013 12:58 PM PDT As my title mention I have a Master and a Slave database. Master if for operations data and my slave mainly for reporting stuff. The issue is that I need to create extra tables on reporting that can't be on the master, but the way my replication is set (the simplest one mentioned by the official doc) at the moment, this breaks the replication system. How could I add tables on the Slave without Master caring about it ? Is it even possible ? |
| MySQL 5.1.67 - Replication failure Mysql, Master Log Truncated or corrupted Posted: 31 Mar 2013 01:11 PM PDT I have run into some issues with replication After an in-place upgrade of mySQL from 5.0.77 -> 5.1.67 rel 14.4 Percona replication between a master and multiple slaves is causing issues. slaves are at the same level as master. The replication mode is mixed (SBR and RBR) The master seems to be truncating the log incorrectly, seemingly at random, and slaves subsequently stop replicating due to corrupt log being sent through. mysqlbinlog also segfaults when trying to read the log. This is the error being thrown by the slaves (table names/server names obfuscated):
currently the only way to recover is via full refresh of the slaves. Would there be an issue on the master server? No disk / network / logging indicates a reason why the mysql master would incorrectly truncate the log. What could be causing the master to incorrectly truncate or not close off the log properly? I'd be happy to hear about any extra detail which might be required to help answer this question! |
| Replication issue - CREATE SELECT alternative? Posted: 31 Mar 2013 11:58 AM PDT I've an MySQL 5.1 slave for our BI team. They need to make some CREATE SELECT with big select queries (several million lines). As CREATE SELECT is a DDL, if the replication attempts to update some rows in same tables than the SELECT statement, replication is blocked until the freeing of the CREATE SELECT. Do you now a good non-blocking alternative to thoses CREATE SELECT statements? I thought to an SELECT INTO OUTPUT FILE then LOAD DATA INFILE but they will fill out our disks as BI guys like to do... :) Max. |
| SQL Server replication subscriptions marked as inactive Posted: 31 Mar 2013 02:58 PM PDT Is there any way to force SQL Server NOT to mark subscriptions as inactive, ever? It happens sporadically when there are connection issues and I don't want to have to reinitialize the subscription every time. Note, I'm not talking about the subscriptions being marked as expired...just as inactive. Thank you. |
| How to drop a DB2 instance when the instance owner was removed Posted: 31 Mar 2013 09:58 AM PDT This is a real sticky situation. I was handed over a machine (running an AIX 7.1), and my first task was to re-install DB2 server on it. But someone before me had conveniently removed an instance owner account, and probably recreated it. Now, the problem is this: 1) When I try to uninstall DB2, it says the instance is active and has to be dropped first. 2) When I try to drop this instance, DB2 says there is no such instance. I am quite new to DB2 administration. Not sure how to proceed here. Any help is appreciated Thanks |
| How to Convert Horizontal to Vertical Array? Posted: 31 Mar 2013 10:58 AM PDT I need to create a query (suitable for Standard Edition) that has data from multiple columns (Columns 1-6 with corresponding Sample data: |
| Ensure correct username when using pg_restore Posted: 31 Mar 2013 07:58 AM PDT I have just installed postgres 9.1.6 on a local Ubuntu server. Now I'm trying to restore a database dump from a database on Heroku. The local database is setup like this: Now, when I try to restore the the dump I use the following command: Now in psql with As you can see, the ownership of app_production database has now turned from app_user to postgres. I would have expected the owner of the app_production database to still be app_user, so what am I doing wrong? BTW, The
Another thing is, that the owner of the dump is the user that the database was having on heroku, which would be something like |
| How to script out push subscription creation at the subscriber? Posted: 31 Mar 2013 12:58 PM PDT I'm trying to set up a push subscription to a SQL Server publication from the subscriber. I could set up the subscription at the publisher using the Replication Wizard in Management Studio. However, I would prefer to script the process relative to the subscriber so I can automate the deployment of a new SQL Server subscriber instance. Initially, I'm happy to prompt for the name of the publisher before deployment. If I can get this working, I will look for a way to inject the correct value for my environment automatically. What is a simple way to do this for a SQL Server instance that has to create multiple subscriptions at different publishers? I'm open to using any supported SQL Server scripting solution: SMO, RMO, Sqlcmd, WMI, PSDrive, even pure T-SQL. I've attempted to solve this problem in two ways. The first is a complete solution using T-SQL, but it involves some manual steps. Using T-SQLI have a manual solution in T-SQL. The solution is based on the output of the Management Studio Replication Script Generator output. Using Management Studio, I run the following script to generate a T-SQL script that I can run at the publisher: On the MYSUBSCRIBER instance, the output would look like this: I copy the output and execute the script at the publisher instance to set up the subscription. I think I can't automate this in pure T-SQL without editing the script before running it, because T-SQL by design does not handle user input. Using PowerShell and RMOPowerShell has simple ways to process user input, so this seems like a good way to prototype the automation process. MSDN has an eight-step guide to set up a push subscription using the .NET Replication Management Objects (RMO). Here are the first two steps:
I'm trying to translate these steps into a PowerShell script, but I can't get past step 2. In the following code examples, I use fictional object names. I believe this does not affect the answerability of the question because the error message is identical when I use the real object names. First attempt: setting the propertiesMy first attempt is to create the TransReplication object then set its properties. The code looks like this: When I execute this script, I see the following error: It looks like it's failing becuase it can't convert the type Second attempt: overloading the constructorMy second attempt is to specify the property values of the TransReplication object in the constructor. The code looks like this: When I execute this script, I see the following error: It looks like the New-Object cmdlet can't find the three-argument constructor documented by MSDN:
As far as I can tell, I'm overloading the constructor correctly. Am I doing something wrong? Is there something unusual about my environment? Am I better off using another solution? |
| Can I monitor the progress of importing a large .sql file in sqlite3 using zenity --progress? Posted: 31 Mar 2013 01:58 PM PDT I'm trying to monitor the progress of a sqlite3 command importing a large .sql file into a database using I've tried the following which will import the file, however progress is not shown: I know I need to provide Can anyone help me? |
| Why is Database Administration so hard? Posted: 31 Mar 2013 05:26 AM PDT I know a lot of Database Administrators and they are all over 28-29 years old. Is all database administration like that? I mean, is this about getting experience more than at least 7-8 years? Or is being a database administrator so hard? |
| Are there any good tools for monitoring postgresql databases Posted: 31 Mar 2013 11:33 AM PDT I am planing to have very soon few highly loaded postgresql databases. I have some expirience managing mysql databases with high load, but now we have to use postgresql. I want to know what are the best tools for day-to-day database management and status reporting. (Of course console is the best one, but I want to know about other options too) All expirience is welcome! |
| How do I list all databases and tables using psql? Posted: 31 Mar 2013 08:45 PM PDT I am trying to learn PostgreSQL administration and have started learning how to use the When I log in with I have tried |
| You are subscribed to email updates from Recent Questions - Database Administrators Stack Exchange To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment