Tag Info

New answers tagged

0

you need to make sure the ownership and privileges are correct for the directory, you can use the following commands to set it right: chown -R mysql:mysql /var/lib/mysql/ --your mysql user may have different name, if its different you need to change it [mysql:mysql] as needed chmod -R 755 /var/lib/mysql/ note: -R: recursive fir the directory and all its ...


1

There is no reasonable way how to do that. For example till 11gR1 SELinux was not certified to be used with Oracle database. Since 11gR2 this is at least not recommended. Let's assume that you and Oracle DBA are adult, where is the problem then? Oracle is not running with root privs. On the other hand Oracle requires many kernel tunables(sysctl) to be set ...


1

TNS Ping does not care about service or SID, all it checks is the availability of the listener, so this does not mean your connection string is correct. Connecting through SQL*Plus successfully however confirms it. Your tnsnames.ora uses SERVICE_NAME in CONNECT_DATA, but your JDBC URL uses the SID syntax. SID and service name are different concepts, and ...


0

SHOW VARIABLES LIKE '%open%'; Probably one of those is too low. At a shell prompt, do ulimit -n That will tell you what the OS is letting you have. In some recent OS builds, it was the ridiculously low value of 1024. If so, increase it to, say, 16000. Then restart mysqld and see if the SHOW increased the values. (Some default values are computed.) ...


0

wal-e backup push will NOT push any wal files to s3. So this backup will be mostly unrecoverable. Use archive_command = '... wal-e wal-push %p' on master to make this backup usable.


0

I think I found the problem. Apparently the nohup command ended at the | symbol, so when the session expired the second part of the command stopped with the session. To get round this I ran: nohup sh -c 'mysqldump -hxxx -P3306 -uxxx -pxxx --dump-slave --databases a b c d --ignore-table=a.xxx -F | mysql -h127.0.0.1 -P3306 -uxxx -pxxx' & I checked it ...


0

I got the sollution, 1:extract your new mysql file :- tar -zxf mysql-5.1.58.tar.gz 2:Rename the old errmsg.sys file which is in error file showing mv /usr/share/mysql/english/errmsg.sys /usr/share/mysql/english/errmsg.sys.old 3:copy the new errmsg.sys file to exsting place cp mysql-5.1.58/sql/share/english/errmsg.sys /usr/share/mysql/english/errmsg.sys ...


1

First of all, the GUC max_connections - a setting in postgresql.conf. Heroku obviously limits this to 20 for the "Starter Tier" and 500 for the "Production Tier". The maximum number is not limited by Postgres itself, but by available system resources. Typically, performance degrades with too many concurrent connections, so even if you can set ...


1

No, external locking is (was) only needed for MyISAM when you tried to execute several processes on the same data directory, such as two server instances, or an instance and a file repair. Sincerely, I would be surprised if that page manual was accurate and was still fully supported. In any case, it is mostly impossible to do that now, as InnoDB (default ...


0

Here's typically what I do to get Mongo installed on a brand new Ubuntu install. YMMV: ##Backup current sources list. sudo mv /etc/apt/sources.list /etc/apt/sourcesBackup.list Then open up vi to make a new sources list: sudo vi /etc/apt/sources.list Copy and paste the default sources list (the distro's I use have a custom sources list, so you might ...


0

It doesn't look like MongoDB provides a repo for Saucy: http://repo.mongodb.org/apt/ubuntu/dists/ So if you installed via Ubuntu-provided repository you have a few options: Remove the RPM and install via binaries Upgrade to Trusty Wait for Ubuntu to update its repo.


1

You can verify that no migrations are running by checking the balance with sh.isBalancerRunning() which is true if chunks are being migrated and false if not. Using BalancerState only shows you if it is enabled or disabled, not its current run state. While it depends on what the specific documentation says, I'd probably feel safer setting the balancer ...


1

Caching to Disk should be your biggest concern. Windows is notorious for caching writes to the operating through the operating system. What this means is that any transaction you write in logs, in .ibd tablespace files, in the system tablespace (ibdata1), would be at the mercy of Windows to get writes to disk. One particular option I am thinking of is ...


-1

It seems that once the shutdown immediate fails, the connection is dropped, although it doesn't show it. Exiting sqlplus, reconnecting and immediately issuing shutdown abort got things unstuck for me. From https://community.oracle.com/thread/459659


0

I am not sure what is going on on this server, but the problem was related to openVZ. For whatever reason the server decided he does not want to put the binlog on a folder which has been mounted. Still trying to solve this.


0

Personally, I am not all that comfortable with the Permissions you have. Since mysqld is not running, try the following cd /var/export/websrvDB.log mkdir junk cd junk mv ../websrvDB-bin.* . cd .. service mysql start ls -l websrvDB-bin.* mysqld should start up and create a new binary log and index file. Look at the permissions of websrvDB-bin.000001 and ...


1

This is caused by Nagle's algorithm. CouchDB sends the HTTP headers and the response body in separate calls, causing the kernel to not deliver the response body for 40ms. As a workaround, you can use this LD_PRELOAD shim to completely turn off Nagle's algorithm for the database process.


0

I solved. The problem was that I did not have the library libsasl2-modules-gssapi-mit. Once I installed everything works fine


0

check SGA region sizes - buffer pool, dictionary cache, library cache. Also check the dynamic view v$sga_resize_ops. There you might find a reason. Also these version of Oracle had a bug, which caused that Oracle could not get rid of the old exec plans if there were too many of them. You should upgrade to terminal patchset 10.2.0.5. You should also ...


1

MySQL 5.7 (still in development as of this post, but soon to be released) is the first version to include memory profiling. You have to enable memory profiling on the setup instruments (it is disabled by default) ans then you can check it with this sys view: You can get results such as: mysql> select * from sys.memory_by_thread_by_current_bytes limit ...



Top 50 recent answers are included