Questions tagged [linux]
A widely-used open-source operating system that is particularly popular on servers.
72
questions
5
votes
3
answers
4k
views
MySQL general log
Is there away to have MySQL dump its log to a remote MySQL server?
I would like to audit MySQL connections but I don't want the server to store all the information local on its own hardware.
- 53
19
votes
5
answers
84k
views
Cannot open table mysql/innodb_index_stats [duplicate]
After a fresh install of XAMPP and import from my linux live db that is working to the windows Dev-stage, I started encountering problems with INSERT. Everything else seems to work well.
The errors I ...
- 315
108
votes
6
answers
178k
views
Safest way to perform mysqldump on a live system with active reads and writes?
I'm not sure if this is true but I remember reading if you run the following command in linux
mysqldump -u username -p database_name > backup_db.sql
while reads and writes are being made to a ...
- 1,215
33
votes
5
answers
98k
views
How to properly kill MySQL?
I have CentOS 64bit with CPanel installed and I use:
service mysql stop
It just keeps ticking periods and never seems like it stops. In the logs it just posts a lot of:
130303 17:42:38 [Warning] /...
Tiffany Walker
5
votes
3
answers
6k
views
Move Complete ORACLE from one system to another
I have 2 identical server with exact disk partitions (OS CENTOS 6.4 both ) [My college central oracle server].
Entire ORACLE HOME ( bin , control files, data files everything on oracle) is on 2nd ...
- 197
1
vote
2
answers
3k
views
Cannot reset MySQL default root password after initial installation
I have installed mysql 5.7 on a Red Hat Enterprise Linux 5.5 server and when I tried to run following command after installation it is asking for a password for root@localhost.
/usr/bin/...
7
votes
2
answers
30k
views
MySQL: Row size too large (> 8126)
I have a table which has 300 columns in it. Each column is up to 255 bytes (there is a business justification for this).
When I try it create it using VARCHAR(255), I go past the limit for the ...
- 171
5
votes
2
answers
3k
views
Does a MyISAM table locks if I copy it while MySQL is running? (READ DISCLAIMER)
DISCLAIMER: I'm very aware this is not supposed to be done, but time consistency between tables aren't a concert here and Im trying whatever pops in my mind right now to have alternatives for punctual,...
- 205
5
votes
1
answer
17k
views
Moving postgresql data directory
I moved postgresql's data directory by following the following steps:
Stop postgres
cp -a source_data_directory destination_data_directory
export PGDATA=destination_data_directory
Changing data ...
- 163
3
votes
2
answers
2k
views
Can I disable the spyware in SQL Server?
There are two titles for the spyware in SQL Server,
Customer Experience Improvement Program (CEIP)
Telemetry
I'm wondering how I disable them. You can see them referenced here,
My SQL Server says ...
- 62.2k
2
votes
1
answer
2k
views
Dedicated mysql server slow response [closed]
I have server in Kimsufi with 2gb RAM but my server is very slow , with simple hosting in ovh it responds quickly ...
With pingdom.com test i have for
server: 10 sec
and simple hosting: 2sec
is ...
- 41
1
vote
1
answer
4k
views
temp table (#sql-7a87_230c32.ibd along with its .frm) still exists on slave
I executed some alter statements on my master server, which have been successfully executed on master (now there is no temp table on master) and all alter also have been replicated on slave server ...
- 223
-4
votes
1
answer
321
views
Getting errors when installing and using sp_blitz with `sqlcmd.exe`?
I installed this third party thingy, sp_Blitz.
sqlcmd -S localhost -U sa -i ./sp_Blitz.sql
But when I run
1> EXEC sp_blitz;
2> go
I get,
Warning: Null value is eliminated by an aggregate ...
- 62.2k
82
votes
4
answers
200k
views
PostgreSQL: Remove password requirement for user postgres
I understand that, upon installation, PostgreSQL has no password for its db root user (postgres):
postgres=# select usename, passwd is null from pg_shadow;
usename | ?column?
----------+----------
...
- 3,279
11
votes
4
answers
7k
views
SQL Server on Linux hangs on initial startup, no errors, and no new / updated ErrorLog file
I'm using SQL Server 2017, Release Candidate 2 (RC2) on Linux (Ubuntu 16.04).
When the server starts up, SQL Server usually starts as well. But for some reason, SQL Server won't start anymore. At ...
- 68.3k
7
votes
2
answers
13k
views
How do you directly modify the system catalogs in SQL Server 2017?
NOTE: I understand the risks involved, and the possibility of destroying a production system by doing this. I'm interested in doing it anyway.
Whenever I try to play with system catalogs, I gets ...
- 62.2k
6
votes
2
answers
31k
views
Hyperthreading & MySQL InnoDB Thread Concurrency Performance
I have a dedicated DB Server with the following specs"
Ubuntu 12.04 LTS Server
Intel(R) Xeon(R) CPU X5670
@ 2.93GHz
12 Cores
MySQL 5.5.29
64 GB RAM
RAID10
We are currently doing Hyperthreading so ...
- 91
6
votes
1
answer
3k
views
How to set 'timing on' permanently in PostgreSQL?
I work with PostgreSQL in the command line interface. I would like to activate a \timing command permanently for every database in the cluster so every time I connect to a database - this parameter is ...
- 355
5
votes
2
answers
20k
views
Change permissions of postgres copy to exported file
I have asked this question on SO but perhaps that was the wrong location. Apologies for double posting but the question may have a better audience here.
The original question is: https://...
- 205
3
votes
2
answers
5k
views
Can I find out what version of MySQL from the data files?
I have a very odd situation going on here. I had a linux box running ubuntu 8.10 and MySQL server with a Wordpress installation on it hosting an internal blog for our company. The machine that this ...
- 31
3
votes
1
answer
595
views
Postgres Backup queries on AWS after reading Postgres docs
I am reading backup section of postgresql docs before heading over to create backup strategy on my EC2 instance.
So there are 2 ways to do it.
Create a dump using pg_dump.
File level backup with ...
- 1,963
3
votes
2
answers
5k
views
MySQL Replication Troubleshooting
Here's what I did. On the master, change /etc/my.cnf:
[mysqld]
server-id=1
log-bin=mysql-bin
innodb_flush_log_at_trx_commit=1
sync_binlog=1
Save and restart mysql, then log in.
>GRANT ...
user168185
2
votes
1
answer
541
views
What differences are there with SQL Server 2017's packaging of `Binn` on Linux and Windows?
Knowing that the Binn is packaged differently on Windows and Linux, I'm wondering what differences there are between the two? Do they come with different utilities? On Linux Binn is distributed in a ...
- 62.2k
2
votes
1
answer
2k
views
Is it okay to have different lower_case_table_names value on master and slave?
I have a OSX MySQL master with lower_case_table_names set to 2. I have just setup a Linux MySQL slave with lower_case_table_names=1.
I haven't started replication on the slave, but everything looks ...
- 611
1
vote
1
answer
19k
views
MySQL slave stuck in "Reading event from the relay log"?
5.5.28-log MySQL Community Server (GPL) by Remi
binlog-format=MIXED
My problem is similar to this question.
*************************** 2. row ***************************
Id: 973415
User: ...
- 1,006
1
vote
3
answers
8k
views
Problem Installing 11.2.0 on RHEL 7 64 Bit
I have problem in stalling Oracle ASM on RHEL 7, Please advice
[root@localhost grid]# ./root.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
...
- 194
0
votes
2
answers
4k
views
Oracle sys password lost
I inherited an Oracle DB on Linux Redhat from someone who left the company and didn't tell anyone what the passwords were to the various accounts on the database itself (not Linux), including what he ...
Nex Terren
0
votes
4
answers
1k
views
Move MySQL database to another server
I need to move 20 Gb MySQL database from on Debian server to another. The problem is that there is no way to create its backup since there are almost no free HDD space on the source server. What would ...
- 133
51
votes
3
answers
183k
views
How to make MySQL table name case insensitive in Ubuntu?
I am using Ubuntu 13.10 and MySQL 5.6 and I know database name and table name are case sensitive in Ubuntu (and some other *nix environments) by default.
Now, I want to make MySQL work as case ...
java baba
27
votes
2
answers
164k
views
Mongo Create a user as admin for any database raise an error
I am trying to create a simple user with the rights permission to access to any database and can do any actions. When I trying to execute the createUser command I got this error:
db.createUser({ user:...
- 675
19
votes
4
answers
71k
views
Taking MySQL dump from another machine
I have a MySQL db on Machine A and I want to access the mysqldump from machine B.
Both machines are running on Linux and I also have the credentials of both, but I can't access the mysqldump. What ...
- 337
14
votes
1
answer
18k
views
How do I totally remove SQL Server 2017 on Ubuntu?
The docs has instructions about how to remove SQL Server. However, this leaves certain packages behind. How can I remove all traces and uninstall SQL Server 2017?
- 62.2k
14
votes
9
answers
26k
views
What tools are there for data masking? (MySQL, Linux) [closed]
I'm looking for (ideally free, open-source) data masking tools. Do any such exist?
Note: this related question deals with tools for generating test data, but in this question I'm more interested in ...
- 477
14
votes
5
answers
63k
views
Cannot output MySQL data to file
I am trying to output the data from an MySQL table to a file but getting permission errors:
$ pwd
/home/dotancohen
$ mkdir in
$ chmod 777 in/
$ mysql -ugs -p
mysql> USE someDatabase;
mysql> ...
- 1,075
10
votes
1
answer
17k
views
Starting PostgreSQL server after a HDD crash results in FAILED STATE
I am using Fedora 15 with PostgreSQL 9.1.4. Fedora crashed recently after which:
An attempt to start the PostgreSQL server :
service postgresql-9.1 start
gives
Starting postgresql-9.1 (via systemctl):...
- 605
9
votes
3
answers
24k
views
issues with encoding and pg_dump/restore between windows and linux
I have a dmp file I have created using pg_dump encoded in WIN1252. What I would like to do is import it using pg_restore to a database on a Linux machine. The problem is that on the windows machine ...
- 289
8
votes
3
answers
2k
views
What is causing this error: None of the specified replicas for availability group ag1 maps to the instance of SQL Server to which you are connected
I am configuring Always-on for SQL Server 2017 RC1 (14.0.80.90, dated 2017-7-18) for Linux as per https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-availability-group-configure-ha. This ...
Erik Brandsberg
7
votes
2
answers
39k
views
MySQL slave stuck at 'System lock' most of the time, high CPU usage
Let me describe what we are facing now:
We have a MySQL Master-Slave, Row Based Replication setup and at the moment, the slave is stuck with a perpetual System Lock. The Master is an active server ...
- 171
6
votes
3
answers
93k
views
Oracle client throwing ORA-12541: TNS:no listener
when i was trying to connect my remote server as-
sqlplus SYSTEM/[email protected]:1521/kannel
it shows me this error-
SQL*Plus: Release 11.2.0.2.0 Production on Fri Nov 15 15:36:52 2013
...
Saagar
5
votes
1
answer
8k
views
Installing SQL Server, I get unmet dependencies libc++1 and libjemalloc1 but it is not installable
Here is the output,
$ sudo apt install -y mssql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may ...
- 62.2k
5
votes
2
answers
23k
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 ...
- 185
5
votes
2
answers
16k
views
grastate.dat with seqno -1 on a healthy cluster. Why?
We use those versions:
# rpm -qa | egrep '(galera|maria)'
mariadb-libs-5.5.41-2.el7_0.x86_64
mariadb-galera-common-5.5.40-6.el7ost.x86_64
mariadb-galera-server-5.5.40-6.el7ost.x86_64
mariadb-5.5.41-2....
- 2,458
5
votes
5
answers
20k
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, ...
- 249
5
votes
1
answer
420
views
On SQL Server 2017 (Linux), where is the Resource Database persisted (located on disk)?
In my default install of SQL Server 2017 on Linux, under /var/opt/mssql/data I see the following databases,
master.mdf - master Database - Records all the system-level information for an instance of ...
- 62.2k
4
votes
3
answers
6k
views
TNS-12541 Error
I have grid installed in my pc but the problem is LISTENER does not start automatically. I have to start listener manually and then only LISTENER get started. But before starting listener if you check ...
- 41
4
votes
1
answer
5k
views
InnoDB: Error: Table “mysql”.“mysql.transaction_registry” not found after upgrade to mariadb 10.3
I've upgraded the mariadb to 10.3 packages on my Debian 10, however something went wrong and I ended in the same issue which is mentioned several times
Cannot open table mysql/innodb_index_stats [...
- 153
3
votes
2
answers
2k
views
Replication feature in SQL Server 2017 on Linux
We have a running production using SQL-Server 2014 in production. It has replication running and partial subscribers in several data centers.
I had a request to evaluate SQL Server 2017 on Linux so it ...
- 344
3
votes
1
answer
5k
views
Listing the Microsoft SQL Server configuration with the values set by mssql-conf?
The utility mssql-conf in /opt/mssql/bin/mssql-conf has the setting list which tells you possible keys,
$ sudo ./mssql-conf list
control.alternatewritethrough Enable optimized write ...
- 62.2k
3
votes
3
answers
46k
views
sqlplus: ORA-01017 logon denied from one host but OK from another
I have a strange behavior for remote sqlplus login to Oracle 11.2 that I cannot explain:
1) I have an Oracle 11.2 server running on a virtual host, say host1
2) I set up another VM, say host2 (CentOS ...
- 141
2
votes
1
answer
2k
views
Mysqldump without slow query
Situation:
I currently monitor an instance of MySQL for slow queries. We have a mysql user dedicated to backups which performs a mysqldump, but the mysqldump gets logged as a slow query.
Question:
...
