Ubuntu is a desktop and server operating system based on Debian GNU/Linux. Note that http://askubuntu.com is specifically dedicated to Ubuntu questions.
6
votes
2answers
918 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 ...
4
votes
1answer
491 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", ...
1
vote
2answers
390 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 ...
2
votes
2answers
1k 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 ...
1
vote
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
2answers
928 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 ...
2
votes
1answer
297 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
678 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 ...
