Tag Info

New answers tagged

1

It looks that server lookup is taking time while searching for the host over the network and in order to minimize the lookup time add the entries in hosts file as entries in hosts file (/etc/hosts) does minimize the lookup time.


0

As you already mentioned documentation that you cannot use table level filtering on replication. You might like to try another approach instead. Replicate whole database and change all tables except those you need to use to BLACKHOLE engine. alter table X engine=BLACKHOLE;


1

My reason why to not to use innodb_file_per_table is performance. I did some tests for our database with 450 tables on mysql 5.5.45 Linux CentOS release 6.7 For unit tests which inserts fixtures into the database before each test (not using all tables everytime) and also tests itself does work with database a lot (inserts, update, deletes, selects) the ...


1

With the changing of the clock times on the Master there might be loss of data for the slave a slave may replay a query it already processed Rather than risk either of these extremes, you should schedule a brief downtime. Here is what you should do: STEP 01: Stop all writes to the Master SET GLOBAL read_only = 1; FLUSH TABLES WITH READ LOCK; STEP ...


0

The 'big' players don't even put the images on the same machine. Instead they have "image servers" globally distributed and optimized for pumping out readonly images. In their case, the benefits of distributed processing outweighs the occasional inconsistency (link to non-existent image; vice versa). Yet other machines handle virus checking, scaling, ...


2

This syntax does not use the listener at all: sqlplus -prelim / as sysdba But you faced an authentication error, because the OS group based SYSDBA authentication failed. Check the below: cat $ORACLE_HOME/rdbms/lib/config.c There you should see a line like this: #define SS_DBA_GRP "John" Only those users can use / as sysdba that are members of the OS ...


1

"The listener supports no services" says it all. Is your database running? sqlplus /nolog as sysdba This should tell you if you are connected to an idle instance or if the database is running. Is the database is running? Are you using dynamic or static registration? Once the database has been registered with the listener you should be able to connect. ...


3

You can do this two ways. Use the mysql client SOURCE command. mysql> SOURCE mysql_stuff.txt or mysql> \. mysql_stuff.txt or, you can use the mysql client from the shell. $> mysql -u my_user -pmy_password my_schema < mysql_stuff.txt Note - no space between -p and the actual password. If you don't put in the password, you will be prompted for ...


0

I was using one of two ways to get a random row: SELECT * FROM mytable ORDER BY RANDOM(); and SELECT * FROM mytable LIMIT 1 OFFSET <random number>; The offset method was faster for low offset numbers, otherwise super slow. An offset of 1 million took ~600 msec, while 100 million was 60 seconds (average query time for midpoint offset was 2.5 ...


1

The best way would be to enable binary logging on the Slave. Why ? With binary logging enabled on the Slave, each INSERT, UPDATE, DELETE recorded in the binary logs comes with the server_id where the SQL statement originated. What if log-slave-updates was enabled ? If you have log-slave-updates enabled on the Slave, every INSERT, UPDATE, DELETE from the ...


0

You can set the default SID and your Oracle home in your .bash_profile file. ORACLE_SID=ORCL; export ORACLE_SID ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME Save the change, then you can source the file without logging out. source .bash_profile If you have more than one database on the ...


3

This is really a Unix/Linux question, but it does relate to Oracle, so I'll give an answer. In Unix, the system makes great use of what it calls "spawning" (or "giving birth"). When you run a command, a new process is created which takes all of its information from the parent. Essentially, it's a copy of the parent - it's a new bash shell, which then sets ...


0

It is a socket file used for inter-process communication, you have to stop the local MySQL server and make sure the mysql.sock doesn't exist. Then you have to re-create the socket file to send the connection to the correct destination (in your case, it is Amazon RDS). There are many ways to create a socket file, for example you can use socat, and the ...



Top 50 recent answers are included