System that handles large amounts of data in an organised fashion

learn more… | top users | synonyms (2)

3
votes
1answer
1k 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 ...
0
votes
2answers
25 views

Deleted transaction logs on microsoft exchange

We run into a big problem in our company. The disk of our Microsoft Exchange server was full and we could not receive any more emails. We seek help from another source, the guy have shown me a place ...
-5
votes
0answers
31 views

How to a database chat works? [closed]

I want create a chat with PHP and SQL. How the database chat (with messages, nick etc.) works? I've tried to create this idea: User -> Write something on the input and send it. DB: Save this ...
0
votes
0answers
3 views

What's the best practice to ensure atomic read of a database table using JDBC? [migrated]

I have an java application reading from a database table for jobs to process, and I may have multiple instances of this application running on different servers as each job is independent. Once a job ...
0
votes
0answers
6 views

Starting an Oracle database in upgrade mode?

I have an Oracle database instance running on a Windows 2012 server. I need to start it up in upgrade mode to run some configuration changes. However, I cannot find the right command to get it going. ...
1
vote
1answer
2k views

DB2 Integrity Checks and Exception Tables

I am working on planning a migration of a DB2 8.1 database from a horrible IBM encoding to UTF-8 to support further languages etc. I am encountering an issue that I am stuck on. A few notes on this ...
0
votes
0answers
24 views

Best way to avoid server outage for gaming company [closed]

I recently moved to a company that provides gaming solutions for Bingo Halls across the globe. We have handheld game devices that run our gaming apps that connect to Windows Servers (2008). Each bingo ...
0
votes
1answer
1k 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
1k views

Zabbix no free space on disk

I have zabbix 2.2.1 and 252 monitors the hosts. Currently, the database is in local and size database is 65GB is running housekeeper who clears history entries older than 30 days. Entries are deleted, ...
3
votes
2answers
5k views

How to convert a postgres database to sqlite

We're working on a website, and when we develop locally (one of us from Windows), we use sqlite3, but on the server (linux) we use postgres. We'd like to be able to import the production database into ...
0
votes
0answers
16 views

External email from specific database going to junk folder

I have migrated from Exchange 2010 to Exchange 2013, after which things are okay. I have four server plus two databases as below: Servers: CAS01, CAS02, MBX01, MBX02 Database: DB1 mounted on MBX01 ...
0
votes
1answer
2k views

Need DB2 OLEDB Driver / ODBC Driver [closed]

I am trying to establish a connection between excel and db2. I am able to successfully query and retrieve data from my DB. I am using the below connection string Provider=IBMDADB2;Database=RQAPROJ;...
14
votes
6answers
23k views

How can I diff two Oracle 10g Schemas?

I have the feeling that there are some difference between two large complicated Oracle schemas which should be identical, so decided to dump and diff them to investigate. I found an article (http://...
0
votes
1answer
4k views

Can't connect to remote mssql server

I'm trying to connect to my remote mssql server for my GunZ private server, but for some reason i get the following error Cannot connect to 94.xx.xx.xx. ADDITIONAL INFORMATION: A connection was ...
0
votes
0answers
70 views

Fatal error: mysql.user table is damaged. Please run mysql_upgrade

I resized an Azure VM and now the MySQL DB running in Windows inside the VM is dead. I am seeing the below fatal error on startup. I tried to run mysql_upgrade as it suggests but that just errors ...
0
votes
1answer
5k views
1
vote
1answer
3k views

Recover mysql database innodb 'table doesn't exist'

Our server crashed last week and we lost a lot of information. We were able to recover .frm files for the tables, ib_logfile0, ib_logfile1 and ibdata1 but no .ibd. I've tried the innodb-force-...
57
votes
5answers
70k views

How do I load a sql.gz file to my database? (importing)

I'm trying to import a gzipped SQL file into mysql directly. Is this the right way? mysql -uroot -ppassword mydb > myfile.sql.gz
1
vote
2answers
72 views

In MySQL, what do I put inside my.cnf so that all tables are UTF-8 that works with emojis by default?

I'd like every table and database (to be created) to be utf-8 that works with emojis. I understand that there are a few variables I need to define inside my.cnf: init_connect='SET ...
0
votes
1answer
3k views

Command to list event monitors in DB2

I see the following commands: drop event monitor set event monitor create event monitor But nothing like list event monitor or get event monitor. Is there a DB2 command to list all current event ...
0
votes
1answer
28 views

MySQL behaviour and disk space handling after deletions and insertions with MyISAM

I have a question about the way MySQL with MyISAM engine handles the free/empty space after deletions and how it behaves when new records are inserted. For example, think about a new and empty DB (...
2
votes
1answer
1k views

Cant open up oracle web console after install db 11gr2 and show weird symbols?

i just finished installing oracle database 11gR2. after successful install, i will usually want to open up web console at http://localhost:1158/em.. however if i open up the page i get a weird symbol ...
18
votes
3answers
24k views

MySQL: creating a user that can connect from multiple hosts

I'm using MySQL and I need to create an account that can connect from either the localhost or from another server, i.e. 10.1.1.1. So I am doing: CREATE USER 'bob'@'localhost' IDENTIFIED BY '...
0
votes
0answers
7 views

what are max_connections in amazon RDS?

I have seen a field called connections under current activity tab. My database instance has a max_connection of 52 . What does it exactly mean?
18
votes
2answers
21k views

How can I do a dump of only the table structure in PostgreSQL?

In a similar vein to this question, how would I do a schema-only dump in PostgreSQL?
3
votes
6answers
4k views

Mysql - drop database with # in name

How can i delete database with # in name? Like that: #mysql50#mysql.backup I don't know who is possible to created it, but it happened. When I try DROP DATABASE name, I have error: ERROR 1102 (42000)...
1
vote
0answers
29 views

Access database using Public External IP - Bandwidth

In an amazon EC2 instance, we pay for each GB of data transfer in/out. Which means, when are sent to server, it's data transfer in. When a user access some website hosted there, data is being ...
0
votes
0answers
22 views

Use Mysql as backend to Bind

I've bind installed on my server. I want to manage dns records and zone files through a web interface instead of directly editing the zone files on the file system. Developing a web app that ...
2
votes
1answer
10k views

Server crashed, some MySQL databases are broken. Trying to recover with InnoDB recovery, but ibdata1 seems corrupt

I've a problem. Some days ago my root server crashes after a power outage. I realised that the MySQL server won't start. In the logs I find out that an error occured with InnoDB's ibdata1. I've ...
0
votes
0answers
30 views

small client-server app & db install location

We're running Server 2008 R2 on dual 2.8 GHz processors with 32 GB memory and a partitioned 1 TB, 3-disc RAID. Seems plenty robust for our purposes. Our primary application, however, has been lagging ...
1
vote
5answers
4k views

How to check if my hard-drive are on RAID5 or RAID6? - Windows Server

I'm not sure if a server I own has been setup on RAID or not. Is there any way to check this within Windows, rather than relying on what the company support tells me? Any ideas? :)
-2
votes
1answer
94 views

Fix WSUS related DB bloating, Uninstall & Install issues on SBS Server 2008?

Environment: SBS Server 2008 DC/ Domain Server: Windows Server 2008 FE Microsoft Windows Server Update Services 3.0 SP1 - MMC SUSDB.MDF started at 14.x GB and when trying to use the Updates ...
1
vote
2answers
48 views

cassandra data migration from regular drive to SSD on production server

we want migrate our data from regular drives on production server to new SSD drives. how we can do that without taking down the node no longer than 4 hours(hinted hand-off is 4 hours) our data is in ...
0
votes
1answer
57 views

Installing postgres on Cent OS

I am having a hard time getting postgres re-installed on Cent OS 7.2.Here is what I tried. Went to YUM repo of postgres Created a temporary folder on my machine for the RPM file Did wget https://...
0
votes
1answer
126 views

ownCloud Unable to Connect to Local Database on Fedora 23 (LEMP stack, selinux permissive)

The Problem I am having a very strange issue where ownCloud seems unable to access my SQL database, using nginx, mariadb, and php-fpm running on Fedora 23. When I attempt to access the page, I get ...
0
votes
2answers
24 views

MariaDB taking ages to restore backup

So I did a mysqldump of a pretty huge db and I'm trying to restore it now using: mysql db_test < db_test.sql but it looks like it's not gonna end by the end of this year. It's been about an hour ...
1
vote
3answers
149 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 ...
0
votes
2answers
61 views

cassandra nodetool drain running for days

We are having performance problems with our cluster regarding to timeouts when repairs are running or massive deletes. One of the advice I received was update our casssandra version from 2.0.17 to 2.2....
2
votes
4answers
15k views

How do I dump view schemas for a MySQL database?

I have a MySQL database for which I wish to dump schemas for views. How do I do this? I tried mysqldump with --no-data, but that only dumps table schemas.
1
vote
0answers
22 views

Certificate is not showing up in SQL Server

I need to say first that I am not a DBA and so, my problem is getting SQL Server Configuration Manager to recognize a certificate. I have 3 SQL Instances I work on, 2 are on the same network, the ...
0
votes
1answer
29 views

Best performance- and backup-strategy with running multiple Webapps and databases on dedicated servers

my company is soon going to move our webservice-hosting to a new hoster and therefore i'm currently planing how everything will run in the future. I have to deploy at least: MsSQL-Database Server ...
0
votes
1answer
41 views

Does AWS support DBF files or Samba Shares?

We have DBF files running in our local network. It's on an Ubuntu Server running Samba shares. The DBF files are used by our in-house system running on xBase. Now we're moving everything to Amazon ...
0
votes
0answers
17 views

Where should migrations be run on elasticbeanstalk deployment process?

I'm very curious as to how people run a command like db migrate on their eb apps. If you add it as an .ebextensions I fear that when you have multiple instances for one app, there could be conflicts ...
18
votes
3answers
27k views

Third-party SSD solutions in ProLiant Gen8 servers

I was wondering if anyone had any specific experience using Intel DC3700 SSDs (or similar) in the HP (DL380p) Gen8 servers? I'm upgrading a set of database servers that use direct-attached storage. ...
0
votes
2answers
79 views

How to connect postgresql with LDAP user?

I have a server with postgresql-9.4 fresh install and I have another server with LDAP already installed. I want to connect postgresql with LDAP user that already exists. What's the basic ...
-1
votes
2answers
89 views

MS SQL Server 2 identical databases on different servers replication or mirroring to each other possible? [closed]

Hi: I have one free version of SQL Server 2012 express database running on Amazon AWS with 1 CPU and only 1 GB Ram . As you can see the CPU and RAM power are barely enough for my PHP scripts running ...
0
votes
0answers
53 views

Backing Up Multiple SQL Databases to Network Share at the Same Time

Junior SysAdmin/accidental DBA here so apologies in advance for the noob question. The previous DBA here had a SQL Backup Maintenance Plan that he would copy across 20+ database servers and have all ...
2
votes
1answer
41 views

Managing data created with an API in multiple environments

I have a staging and production environment for my application and store Stripe::Customer ids in my database. Occasionally, I want to copy production data to my staging database, but the Stripe::...
0
votes
1answer
18 views

Does transferring a database to a new SQL Server instance lose statistics and execution plans?

I am transferring a database to a new SQL Server and was wondering, will it lose it's execution plans and statistics that its collected over the years for the benefit of performance and have to start ...
15
votes
2answers
31k views

Best Mysql cache settings for 8gb RAM dedicated mysql server using only Innodb (5gb database)

I'm a pretty big noob when it comes to setting up mysql for performance. And honestly I'm not worried about the fine tuning to squeeze every last bit of performance out of mysql, but I do know that ...