1
vote
0answers
59 views

Unexplained excessive database response times - very powerful hardware, tiny database

I've a strange problem that's repeatedly troubled me across 3 different servers now. The problem Please see the graph from NewRelic showing the huge amount of time spent in the database. The ...
0
votes
3answers
78 views

Amazon Linux EC2 Webserver / MYSQL Upgrade – Traffic causing error establishing a database connection

To give you a little background, I currently have a website that allows users to upload photos. The website was initially on a GoDaddy shared server, but recent surges in traffic have forced me to ...
1
vote
1answer
90 views

Choosing the right database/storage engine for iptables ulogd

I'm looking for some help choosing a database backend for a iptables ulogd setup. We are going to swap out our current proprietary firewall solution with iptables and one of the requirements is to ...
0
votes
1answer
351 views

Users database empty after Samba3 to Samba4 migration on different servers

I have to migrate a Samba 3 to a new Samba 4 server. My problem is that the database on the samba 3 server seems a bit empty. The secrets.dtb file is only 20K whereas the “pbedit -L |wc -l”command ...
1
vote
1answer
309 views

Large lag on mysql replication (Relay_Log_Pos and Exec_Master_Log_Pos does not increase)

Today my two slave's (one mysql 5.1 and second MariaDB 5.5, master is mysql 5.1) started lagging. Similar situation are quite often with lags rises to even 10000 seconds, because slaves have worse ...
1
vote
0answers
53 views

Legacy BSD PTYs instead of /dev/pts?

I'm trying to use an old database that only accepts connections from legacy BSD style pseudo-terminals /dev/ttyp's or /dev/tty's. It does not recognise /dev/pts/9 style PTYs. Connections via SSH. I ...
0
votes
1answer
212 views

MariaDB Galera Cluster hang after issue cluster command

When trying to cluster two MariaDB Galera servers on RHEL 6 together using the command: mysqld -uroot --wsrep_cluster_address=gcomm:// and the screen then sits there, and looks at me with this ...
2
votes
4answers
402 views

How can i create in incremental backups of mysql databases

I have linux centos 6.4 server with mysql5.6 I have the cron job for making hourly mysql database backups like this Its in python os.popen("mysqldump -u %s --password=%s -h %s -e --opt ...
-1
votes
2answers
253 views

How to regain access to myql server and dump database?

We retake the management of our server and now we need to make some reverse engineering. We gave to an external company the development of our new Website and they need a dump of database from old ...
0
votes
1answer
250 views

Understanding postgreSQL's indent, md5, password in pg_hba.conf

If I have the following in my pg_hba.conf # TYPE DATABASE USER CIDR-ADDRESS METHOD local all all trust local all all ...
-1
votes
1answer
33 views

InnoDB Failure of some kind [closed]

I have MySQL 5.5 installed. I tried to install Joolma but it failed. I went into their sql and replace EGNINE=InnoDB with MyISAM and the install worked. InnoDB is listed under SHOW ENGINES; Any idea ...
-1
votes
1answer
39 views

Improving Database Performance [closed]

I've heard that you can do something like the following in my.cnf to get better performance: tmpdir = /dev/shm I'm running MariaDB and wondering is this a good idea? All it does it create the ...
1
vote
2answers
725 views

MySQL Table not repairing

Table info: Database name: user_motiva Table name: wp_options.frm wp_options.MYD wp_options.MYI wp_options.TMD when I do a mysqlcheck -r --all-databases it gets hung on that table even if you ...
1
vote
1answer
2k views

How to calculate max_connections for PostgreSQL and default_pool_size for pgbouncer?

Is there a rule or something I can use to calculate a good number for max_connections, default_pool_size and max_client_conn? The defaults are odd. PostgreSQL defaults to max_connections=100 while ...
0
votes
1answer
327 views

Setup HA postgres database, failover concept

I want to setup a HA postgres database. I setup master and slave database with synchronous streaming replication on different physical servers. When there is an error in the replication, the slave db ...
-1
votes
1answer
174 views

MySQL Configuration on my.cnf [closed]

[mysqld] core-file default-storage-engine=MyISAM max_connections = 5000 max_user_connections = 5000 key_buffer = 1024MB myisam_sort_buffer_size = 512M join_buffer_size = 256M read_buffer_size = 256M ...
0
votes
1answer
203 views

Binding MySQL to run from the public or private LAN IP address - which one is faster

So we have 2 servers all running at the same web host. We have bind MySQL to listen on the public ip-address of the database server and the web server connects to it from the public ip. Both servers ...
1
vote
0answers
328 views

Server quit without updating PID file on multiple mysql installation in linux

Iam trying to install one version of mysql in a LINUX machine. The system contain already another version of mysql installation. I prefer manual installation. Copy the extracted tarball into a ...
1
vote
2answers
761 views

Ulimit settings in Oracle 11g on Linux 5

Is there an issue with "Ulimit -Hn" being set too low (at 1024) when (Oracle recommend 65536)? This is for Oracle 64-bit 11g on Linux 5. It is one of the settings that appears to be woefully short ...
1
vote
1answer
2k views

Mysql PID Error, Locking Database

I changed my.cnf file to add some parameters in it but after restarting the service it failed to start giving locking error. i removed locks using rm command and again trying to restart but it not ...
1
vote
3answers
125 views

Database select error

Database select error its my problem and when I restart my mysql to fix this error this problem solve but after 30 minutes or after hours again this error happen again. I put link here screenshot ...
1
vote
0answers
135 views

Hosting 25 Websites at home on a 16Megabit upload/60Megabit Download with Dynamic IP Pros and Cons [closed]

Problem: I was hosted on dedicated server for about £500 a month, then I moved to colo for £200 a month and now I am finally moving the server from colo to my home internet. The servers with ...
1
vote
2answers
338 views

What is the standard system architecture for MongoDB

I know this question is too vague, so I would like to add some key numbers to give insights about what the scenario is Each Document size - 360KB Total Documents - 1.5 million Document created/day ...
3
votes
2answers
465 views

Re-assigning raw SAN disks from Solaris to Linux

We have a SYBASE IQ database running on Solaris using raw devices as underlying storage for the database. We would like to migrate this environment from Solaris to Linux. Is it possible to just ...
0
votes
1answer
58 views

Index Proposals

As a theoretical database question, if you are asked 'which indexes would you propose and why?' are the answers from primary, clustering and secondary index? How would we know if we should introduce ...
1
vote
1answer
218 views

How does MySQL 5.5 and InnoDB on Linux use RAM?

Does MySQL 5.5 InnoDB keep indexes in memory and tables on disk? Does it ever do it's own in-memory caching of part or whole tables? Or does it completely rely on the OS page cache (I'm guessing that ...
1
vote
2answers
55 views

Database of services and related information for various Linux distributions

I am looking for a database/list of common services and related information dovering various linux distributions. For instance for MySQL, the list would indicate that the init script is at ...
0
votes
4answers
495 views

Assign a timeout period for MySQL queries

At the moment on our server, my boss has shell access and runs SQL directly through the mysql application, but sometimes he creates a bad query and the MySQL DB dies until i can kill it (or wait out ...
-3
votes
1answer
291 views

How to setup a mail proxy which logs all emails to a database?

I'd like to setup a POP/SMTP proxy which logs all emails to a database. Nginx does support POP3 and SMTP but I didn't find any possibility to log the mails to a database. Unfortunately the existing ...
1
vote
2answers
3k views

Connect to Oracle Database that is hosted in a Virtual Machine from the host machine

Good day, I've just setup a Virtual Machine (using VirtualBox) of Oracle Linux with Oracle Database in it. After setting it up, I can verify that I can connect to it using sqlplus (sqlplus of the ...
0
votes
2answers
2k views

Setting up Oracle Database in Oracle Linux

Good day, I am trying to install Oracle Database in Oracle Linux. However, it is looking for some dependencies. Anybody knows where I can get them? Package: gcc-3.4.6 FAILED Package: ...
0
votes
2answers
636 views

Installing Postgresql 8.3.7 in Debian Squeeze

I am tring to install postgresql-8.3.7 into Debian Squeeze OS. It is throws me following error. unmet dependency libkrb53, libpq5 . Whether postgresql-8.3.7 is compatible with Debian Squeeze ...
0
votes
1answer
734 views

How do I view MySQL slow log?

# ls error.log mysql-slow.log.1.gz mysql-slow.log.3.gz mysql-slow.log.5.gz mysql-slow.log mysql-slow.log.2.gz mysql-slow.log.4.gz mysql-slow.log.6.gz This is what I see. How do I view ...
0
votes
2answers
125 views

How to rebuild RPM Database

I'm trying to rebuild the RPM DB Files to conform to the new md5sums of the files, so when the rpm is uninstalled, those files will still be removed. I have a application that Installs with RPM, but ...
0
votes
2answers
163 views

database for storing network traffic

I am developing a software to monitor network traffic and I need a database server that would be very fast in storing and querying packet header fields. I know there is a .pcap file format, but it is ...
0
votes
1answer
1k views

informix + Fatal error in shared memory creation

please advice how to solve this problem I have linux with informix DB its fail on - Fatal error in shared memory creation su - informix -sh-2.05b$ oninit -v ONCONFIG ...
0
votes
1answer
197 views

linux + Informix cant startup + external EMC storage

I have Linux machine with Informix DB from the Informix log I see the following please advice what could be the problem ( my Informix cant startup ) 13:40:45 Warning: ONCONFIG dump directory ...
1
vote
2answers
404 views

How to convert Mysql database to Postgresql in Linux?

I have a large Mysql database containing tens of tables which I need to convert to Postgresql. I have tried a couple of ancient Perl scripts which I found here and there but none of them did the job ...
1
vote
2answers
164 views

How to dump database to be used with no credentials

I am wondering how can I generate a dumped database so that it can be restored without requiring the original database username and password? Ideally I'd like to know the pg_dumpall as well as ...
1
vote
1answer
110 views

my.cnf in server directory, why

On my Ubuntu machine, I have installed MySQL . I notice that there are /etc/my.cnf file which contain the content (only two lines): innodb_buffer_pool_size = 1G max_allowed_packet = 512M While ...
-1
votes
1answer
67 views

/data/tmp on database server? [closed]

I am on a Linux ubuntu machine with MySQL installed. My teacher gave out an assignment which mentioned "copy cars.dat to /data/tmp on the MySQL database server" without any explanations, I do not ...
0
votes
3answers
1k views

“chown mysql:mysql /data/tmp” command

I am on a Linux ubuntu machine with MySQL installed. If there is a MySQL installation on a Ubuntu machine, I saw some people doing the following thing: sudo chown mysql:mysql /data/tmp I get ...
4
votes
3answers
222 views

What hardware & software consideration does a major website require to properly manage 1000+ servers? [closed]

Sorry for such a high level question. I understand the basics of server load balancing, but the concept of managing 30,000 servers is a bit foreign to me. Is it really just the same concept of ...
0
votes
2answers
97 views

Server configurations for hosting MySQL database

I have a web application which uses a MySQL database hosted on a virtual server. I've been using this server when I started the application and when the database was really small. Now it has grown and ...
1
vote
3answers
92 views

Multiple physical server Linux DB and app environment: necessary to live near the data center?

With a physical server environment, is it advisable to live in the same major city as the data center, even if there are better data center options halfway across the country? Hosting and bandwidth ...
2
votes
1answer
730 views

MySQL : max_allowed_packet Greater than 1 GB is it possible?

In the field of Digital forensic , a packet size of 1GB is very common and I am getting trouble. Using in-house python script , we extract text out from archives , some files are as big as 4 GB and ...
3
votes
3answers
599 views

Using SSD drives in a raid in an operation involving little to no deletes

From what I've been able to understand when reading about the case with Solid State drives and raids, the problem is that TRIM cannot be used for them in a raid configuration, thus, resulting in the ...
0
votes
1answer
60 views

how mysql replication

I'm doing mysql replication (master - slave). There are a few questions Can I assign replication for some databases and not all databases that are on master (for example, ON master server there are ...
0
votes
3answers
423 views

Get back the Disk space from Postgresql

I have one database in linux server which has huge number of data's. Due to the updation and deletion operation it has consumed most of the from my hard disk. The main reason is that the version ...
3
votes
1answer
3k views

“service mysqld stop” times out (then found out that “mysqld dead but subsys locked”)

I installed mysql and server via yum on my 64bit CentOS 5 server. It starts up fine but when I try to stop it it stalls out and then I have to "Ctrl-C" it. Then I run a "service mysqld status" and it ...