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 ...


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

Unfortunately, yes, you'll need to reduce the size of your root LV. (You could reduce the size of swap, too, but that's already a fairly small volume) Even if you can use that 4MB, a snapshot of your root volume will become invalid quite quickly when LVM runs out of "free" disk space. You get prompted with a text box asking how much of your disk to use ...


3

When reading the configuration file, the mysql command line client only reads configuration directives found in the [client] and [mysql] sections, while mysqldump only uses configuration directives found in the [client] and [mysqldump] sections. If your socket directive in the config file is in the [mysql] section but not the [mysqldump] section then you ...


3

As you probably know, you've deleted your InnoDB data file. Your options are basically to restore from backup if you have one, or hire a data recovery company with MySQL knowledge to see what they can salvage off the disks. Some of the MySQL consulting firms like Percona and Pythian might be able to help you there, but it won't be cheap, and they might not ...


3

It depends a great deal on your workload - the write volumes and write patterns on the master. The standby is essentially doing continuous crash recovery. It reads write-ahead logs containing the changes the master made to the tables and applies that to its own tables. It does this using a single worker, so it doesn't benefit significantly from I/O ...


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

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. ...


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

Well, I have some advice for you. Given https://help.ubuntu.com/12.04/serverguide/mysql.html, As of Ubuntu 12.04, MySQL 5.5 is installed by default Go with the 5.5.x version they supply, and update accordingly. If you don't want to do that and really want 5.5.29 for a specific reason, go for mysql-5.5.29-debian6.0-x86_64.deb as Ubuntu was derived ...


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

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

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

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


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

You need to visit the MySQL download page. Select your preferred platform (I prefer Debian Linux). And then select your OS-type (32-bit or 64-bit). Click on the Download button. It will ask if you want to Sign Up or Login, just choose the No thanks, just start my download. If you are downloading the .deb file on the terminal right click the link and choose ...


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

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

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

This isn't a database problem at all. The tipoff is the "using password: NO" in the error message. Ensure that you're sending a password in your authentication as follows: Command line The correct syntax for the CLI client is: $ mysql -uroot -ptest Or you can just use -p (with no value), which will prompt you for a password. Note that there's no space ...


1

Assuming this isn't an Internet connection issue ("Connection failed" is a needlessly obscure message), then this looks like a problem with the particular Ubuntu mirrors your system is trying to use, rather than something specific to MySQL. The answer posted on What to try when apt-get install xxx Results in Connection Failed seems like it should get you ...


1

hmm, scratch my earlier answer about a trailing ';' I still suspect it's "hanging" because it is not a complete statement, it's waiting on you to complete it. (don't have a db2 instance available at the moment to test unfortunately) try this: CREATE DATABASE mytestdb AUTOMATIC STORAGE YES It's a good idea to run db2 list applications in another ...


1

Simple answer, drop the -h localhost. With -h localhost it connects over TCP/IP sockets. Without it, it will connect over UNIX domain sockets. These are set differently for auth methods in the pg_hba.conf. So try this: john@host:~$ su - santa santa@host:~$ pg_dump myapp_db -U santa --no-owner -W > myapp_db_backup.sql


1

MySQL has built-in support for importing data from CSV files, just use the command-line client : mysql -u <user> -p (replace <user> with your MySQL username and enter the password when asked to) Then, tell MySQL to use your database : USE <database>; (replace <database> with the database name) And finally, use this to ...


1

Create the first table, then load each table into the merged_table: CREATE TABLE merged_table LIKE `1`; INSERT INTO merged_table (url,title,content) SELECT url,title,content FROM `1`; INSERT INTO merged_table (url,title,content) SELECT url,title,content FROM `2`; INSERT INTO merged_table (url,title,content) SELECT url,title,content FROM `3`; ... ... ; ...



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