Ubuntu is a desktop and server operating system based on Debian GNU/Linux. Note that http://askubuntu.com is specifically dedicated to Ubuntu questions.

learn more… | top users | synonyms

0
votes
1answer
2k views

MySql 5.5 in ubuntu repository

Sorry for duplicate question. I am looking for the best way to install mysql 5.5 on ubuntu. So far, there are few options: Installing from tar.gz Installing from PPA. Alien on RPM. All of them ...
1
vote
1answer
4k views

How to set a specific directory location for individual MySQL database?

Is it possible to set each database in MySQL to use a separate datadir? I'm running a userdir development (sandbox) server and would like to put the MySQL data files for the database(s) for that user ...
3
votes
1answer
551 views

oracle 11g seems to die every 2 days, how can i debug what's happening?

I installed oracle 11g on ubuntu 11.10, but it seems that every couple of days I'll get to work and the database isn't running but the listener is. To fix it, all I have to do is login and start it ...
2
votes
1answer
2k views

Ubuntu Multiple MySQL instances and Apparmor

I am trying to set up multiple instances of MySQL on an Ubuntu dev machine and running into AppArmor problems. I get this error in the syslogs: kernel: [227631.776360] type=1400 ...
2
votes
3answers
3k views

Installing Oracle 11g on Ubuntu 11.10

Does anyone know to how to install Oracle 11g on Ubuntu 11.10?
1
vote
0answers
812 views

Why can I not start mysql server on ubuntu after change the innodb_flush_log_at_trx_commit value to be 2?

Why can I not start mysql server on ubuntu after change the innodb_flush_log_at_trx_commit value to be 2 ? updated to answer the 3 questions: mysql> show variables like 'version%'; ...
8
votes
2answers
3k views

View Postgresql Memory Usage

I'm running Postgresql on a Ubuntu server and need to be able to monitor its memory usage. Currently I have scripts running in a one-minute cron job that monitor/log various statistics and need to ...
5
votes
1answer
1k views

Substantial difference between database size under MySQL and actual size on disk

When I check the size of my databases under MySQL I get this: MariaDB [(none)]> SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB", ...
4
votes
1answer
8k views

Connection to an oracle db from another computer

I have installed Oracle 11g to an ubuntu, I can connect to DB using sqlplus from the localhost, But I cannot connect from another computer, I have configured my tnsnames.ora as followed; ELIF = ...
1
vote
2answers
707 views

Mysql master-master permission replication issue

I came to know it's safe to replicate mysql database to have the users and permissions replicated, from a post in ServerFault is-it-ok-to-replicate-mysql-db. I have setup master-master replication ...
1
vote
2answers
475 views

Moving MySQL database from UniServer to Ubuntu Server?

I have set up Ubuntu Server 11.10, and plan to host my website on it. Until this point I was using UniServer to host it in a portable fashion. Using the built in MySQL. This is fine, and through ...
5
votes
5answers
8k views

MySQL said “InnoDB: Initializing buffer pool, size = 128.0M”, does it mean it is using 128MB RAM?

I am just using a very few InnoDB tables (e.g. less than 1MB), but during MySQL startup, it said InnoDB: Initializing buffer pool, size = 128.0M Does it mean even I am using in such a small size, ...
2
votes
2answers
4k views

Mysql consumes a lot of memory

Here is my situation. I have an ubuntu server monitored by nagios. recently nagios sends alarms regarding the memory consumption on the server. I logged into the server and executed the top command ...
2
votes
1answer
3k views

Is there a PPA for MySQL 5.5 for ubuntu 10.10 and 11.10?

I want to install MySQL server 5.5 on ubuntu 10.10 and 11.10 servers but have not yet found a problem free PPA or installation method as of yet. Has anyone managed to do this with the said versions of ...
3
votes
4answers
10k views

How to Add Federated engine after installing Mysql

I have Mysql 5.5.18 and upon show engines: show engines; +--------------------+---------+------------------------------------------------------------+--------------+------+------------+ | Engine ...
2
votes
4answers
1k views

INFORMATION_SCHEMA Selection Error

I'm trying to select data from information_schema but I'm getting the following error. How can I fix this? mysql> SELECT * FROM information_schema.tables ; ERROR 1018 (HY000): Can't read dir of ...
4
votes
2answers
2k views

Trying to get multiple mysql instances running on Ubuntu dev box

I'm trying to get multiple instances of mysql running on a dev box for some testing. This guy is running ubuntu so the setup's a little different than our production setups. I'd like to find the ...
11
votes
2answers
30k views

List the database privileges using psql

I'm in the middle of a database server migration and I can't figure (after googling and searching here) how can I list the database privileges (or all the privileges across the server) on PostgreSQL ...
2
votes
2answers
4k views

Postgresql - Recovery using recovery.conf

I am trying to recover a database using recovery.conf file for making point-in-time copy. On recovery.conf file, I added a recovery target time as below. recovery_target_time = '2011-06-16 04:10:00 ...
2
votes
1answer
324 views

MySQL Replication not working properly on Ubuntu Lucid Lynx Server

I have two Linux boxes. On the master following is the configuration file (my.cnf) log-bin = master-bin log-bin-index = master-bin.index binlog-do-db = test_db server-id = 1 master ...
3
votes
2answers
2k views

PostgreSQL: SET-ing from psql arguments

Following this answer regarding limiting resources per query in PostgreSQL, I've been advised to set a timeout value for query execution: SET statement_timeout TO '1min'; This is great, but ...
4
votes
2answers
2k views

What's a free client for Oracle 8 on Linux / Ubuntu? [closed]

I need to connect to a legacy Oracle 8 database. Oracle SQL Developer would be my tool of choice, but the current version doesn't support Oracle 8 anymore. I tried Squirrel too, but the connection ...