Tag Info

Hot answers tagged

5

"no space left on the device" could also mean that the partition is out of inodes. Use df -i to check inode usage. Edit: Each file, directory, and symbolic link requires one inode. So the idea is to remove some files from the / partition. It doesn't matter how large the files are. You can of course just pick some files on the partition and move them to ...


5

All you should need is: listen_addresses = '*' and then to modify pg_hba.conf to permit connections from the desired source. This is stated in the comments on the (very old) article you were reading. Try using the main PostgreSQL documentation, or up to date tutorials, in future. See: Connection and authentication settings Client authentication


3

Neither MyISAM nor InnoDB have multithreaded query implementation. Nor do other XtraDB, TokuDB. It is a long standing issue and limitation of MySQL. I don't know that the limitation is within the MySQL server, but rather in the storage engine implementation. No one ever did it... I'm currently evaluating the column-store InfiniDB and Infobright IEE. They ...


3

I highly recommend that you do not run GRANT ALL PRIVILEGES ON *.* TO 'username'@'%'; This user has the SHUTDOWN privilege, which can allow the user shutdown mysql remotely with mysqladmin -hIP_of_DB Server -uusername -p shutdown You also do not want the SUPER privilege given remotely to just anyone. Why ? The SUPER privilege enables an account to ...


3

You seem to expect that rows with NULL values are excluded from a B-tree index automatically, but that's not the case. Those are indexed as well and can be searched for. However, since: access_type ... is null in 90% of cases that's hardly useful in your case. Such common values hardly ever make sense in an index to begin with, be it NULL or any other ...


3

I don't believe there is a way to suppress only that warning, but you can always start your mongod instance with the --quiet flag. --quiet Runs the mongod instance in a quiet mode that attempts to limit the amount of output. This option suppresses: output from database commands, including drop, dropIndexes, diagLogging, validate, and clean. ...


3

See this part of the pg_dump manpage: -W, --password Force pg_dump to prompt for a password before connecting to a database. This option is never essential, since pg_dump will automatically prompt for a password if the server demands password authentication. Don't use -W at all. In your case, it's just confusing. Also, you need ...


3

When you reboot the OS you remove all of the disk reads that have previously put into operating system disk cache (RAM). Once you've rebooted, the operating system will have to read the MySQL data from disk, which is several orders of magnitude slower than reading from cache (RAM). Optimise "fixes" this as it causes MySQL to read all of the table data from ...


2

I know the post is a little old, but it seems that many people are having issues with federated engines. When the mysql binaries are installed via yum, you already have the HA (High Availability) plugins. You simply need to load the plugins within the mysql CLI. Here is the basic process: Start mysqld if it is not already started. Make sure 'federated' ...


2

if i issue some delete/update command wrongly There is no such thing as a "wrong" delete or update command unless it is "wrong" in the sense of being syntactically invalid, referencing nonexistent objects, or attempting something for which the user does not have permission... and those aren't going to execute anyway. So you must be talking about ...


2

PostgreSQL doesn't support spanning a single table over multiple tablespaces directly. You can use table partitioning to create a "master" table, with child tables on different tablespaces. It's a bit tricky and it means you can't use foreign keys or enforce a proper unique constraint on the primary key, so it's not generally the preferred option. A more ...


2

I see two possible reasons: Your installation script is not correct and failed to create the tables correctly The CentOS installation does not have InnoDB installed (or activated). MySQL will not tell you about it if you request a non-existing storage engine (or at least not loud and clear)


2

In the link that Dimitar provided, the question itself hints at a solution - if you're putting this in a script, you could add the SET PASSWORD line with an empty password. export DEBIAN_FRONTEND=noninteractive sudo debconf-set-selections <<< 'mariadb-server-10.0 mysql-server/root_password password PASS' sudo debconf-set-selections <<< ...


2

In think your problem is that gourmet_id is declared as CHARACTER(30). If you change it to CHARACTER VARYING(30), it should work much faster. This is what happens: -> Seq Scan on counters c (cost=0.00..250342.85 rows=2725633 width=16) (actual time=0.009..1610.743 rows=2751732 loops=1) Filter: ((counter_name)::text = 'FnfHit'::text) Rows Removed by ...


2

I think there are two unrelated problems here: 1) failure to connect on Unix domain socket This part of ps output: /opt/PostgreSQL/9.3/bin/postgres -D /home/dev/postgres_data indicates that you're not running postgresql as packaged for Ubuntu. Ubuntu doesn't install its binaries inside /opt (it doesn't even create /opt) and your data directory ...


2

What you have seems fine. I would add the following Run this on the Master. SET GLOBAL innodb_fast_shutdown = 0; SET GLOBAL sync_binlog = 1; SET GLOBAL sync_master_info = 1; This will cause everything that has been uncommitted to be committed on shutdown. Then, it flushes the binlogs to disk. On the Slaves, run this SET GLOBAL innodb_fast_shutdown = ...


1

You must install Oracle as a non-root user. Generally, that user would be called oracle, but it can be anything, as long as it's not root.


1

ok, so i found a solution, seing how apparently my default admin password got messed up i ran a ' find /oracle/ -iname 'apxchpwd.sql' Search command once i got the location of the file, i logged in sqlplus as sysdba, then ran @[complete_apxchpwd.sql_path] got prompted for the new password, typed it in, and voila


1

The comment from Barmar is correct. You do not have enough memory in the server for the InnoDB Buffer Pool. Since you got the message 140107 0:09:29 InnoDB: Initializing buffer pool, size = 64.0M followed by 140107 0:09:29 InnoDB: Fatal error: cannot allocate memory for the buffer pool you should lower innodb_buffer_pool_size below 64M in ...


1

You need root password to achieve non-interactive installation of MariaDB 10.


1

You may have been unaware of this, but everything and its grandmother done in MySQL is a question. In light of this, the real question is : To mysqld, what is a Question ? According to the MySQL Documentation on Questions: The number of statements executed by the server. This includes only statements sent to the server by clients and not statements ...


1

I would suggest you to use active-passive cluster with drbd. Active-Active leads to more problems then it solves especially if you use MySQL as database because you can't run 2 MySQL Daemons on the same Database! Creating drbd cluster is simple. You have to do the following steps on both servers. Create a partition for share Create a drbd config with the ...


1

In Feb 2009, Scahin_S wrote in [1] to use the uninstall-postgresql binary. In the same thread Sachin_S also documented a manual alternative for uninstalling 8.3 is /opt/PostgreSQL/8.3/installer/server/removeshortcuts.sh /opt/PostgreSQL/8.3 8.3 /etc/init.d postgresql-8.3 stop rm -rf /opt/PostgreSQL rm /etc/postgres-reg.ini rm -rf ...


1

a) Use an OS that is certified for installing and running Oracle Database (Ubuntu is not amongst them). Native or virtual machine, your choice. or b) here is an unofficial guide for installing Oracle 11.2 on Ubuntu Linux https://forums.oracle.com/thread/1117155 I have never tried myself, but several people succeeded installing Oracle 11.2 on Ubuntu with ...


1

The instructions you link to are out of date. They are for version 8.3 which is no longer supported. As of the time of writing this the oldest supported version is 8.4. Although even 8.4 is still supported, if you're doing a new install it's recommended that you install a newer version. The standard Ubuntu 12.04 repositories currently have PostgreSQL ...


1

If you haven't set up the environment variables, then you need to specify the full path to your executables. Postgres-XC hardly qualifies as "weird third party rubbish", it is a distributed fork of Postgres. http://sourceforge.net/apps/mediawiki/postgres-xc/index.php?title=Main_Page What version of Postgresql are you using? You show a link to 8.3 which is ...


1

Maybe it is not the finest Solution / Answer to my question, but at least it will point anybody (facing the said challenge I had in my original question) To disable listening on TCP/IP network I used this command line option when starting the server application: postgres [other arguments] -c listen_addresses='' Addition: The remaining open udp ...


1

To check if database or listener is running on Linux, you could check if Oracle processes are running, for example ps aux | grep pmon(or grep lsnr for listener). Pmon is process monitor, process responsible for "housekeeping", like freeing buffer cache or some resources that are not in use anymore. It is always running if the instance is up ( but this ...


1

custom mysql datadir? removed apparmor and still having mysql process failing to start issues? try this. may help some of you depending on your config. worked for me: when using a custom mysql (5.5) data dir as described above- ie., if the abs. path to datadir (my.cnf) is /opt/some/other/mysql even with apparmor removed/purged, you must make certain that ...



Only top voted, non community-wiki answers of a minimum length are eligible