49
votes
MariaDB Can't init tc log
I ended up deleting the tc.log file in /var/lib/mysql. When I started mysql again, it created a new tc.log and started up.
sudo rm -f /var/lib/mysql/tc.log
- 591
23
votes
Setting root password in fresh mysql 5.7 installation
If you just run mysql command under root user you will be granted access without asked for password, because socket authentication enabled for root@localhost.
This guide is misleading.
The only way ...
- 331
18
votes
Accepted
MariaDB Can't init tc log
Woohoo, I found it! For now, at least. Digging through the source suggests that this might have something to do with mmap() calls, and lo and behold - VirtualBox has a bug in that area. Fortunately ...
- 724
14
votes
Accepted
Improving RAM and CPU utilization by PostgreSQL 9.6
The default settings in postgresql.conf are very conservative and normally pretty low.
I suggest the following changes:
raise shared_buffers to 1/8 of the complete memory, but not more than 4GB in ...
- 266
9
votes
MariaDB Can't init tc log
You can remove the tc.log in the data directory and remove old entries from mysql-bin.index (it is a text file, along with a list of binary logs). If this is a development box, you can remove the ...
- 1,449
8
votes
Improving RAM and CPU utilization by PostgreSQL 9.6
https://pgtune.leopard.in.ua/#/
Try this website. it helped me a lot.
Neat GUI environment
- 181
4
votes
Setting root password in fresh mysql 5.7 installation
All of the above did not work for me and note, I spent an hour or more trying all other suggestions from MYSql website to everything on SO, I finally got it working with:
Note: while it showed Enter ...
- 141
4
votes
mysql "can't create test file" error on Centos
If you tried fixing ownership and permissions.
chown -R mysql:mysql /new-path/mysql
chmod 0755 /new-path/mysql
And you do not have SELinux enabled but you still have a problem.
All you need to do is ...
- 191
4
votes
Changing data directory for postgres on CentOS
SELinux blocking access? Check your /var/log/audit/audit.log.
It might be necessary to fix the SELinux context for the new dir:
semanage fcontext --add --equal /var/lib/pgsql /home/mlu/postgres-data/...
- 141
4
votes
Accepted
Postgresql sql import Permission denied!
Try to move the file into /tmp folder, I hope this will work.
In PostgreSQL you run into error with having permission on the the file but not all the folders/directories before it.
- 90
4
votes
postgresql-setup --initdb with custom data directory
If you wish to place your data in a custom directory /pgdata/14/data, create the directory with the correct permissions:
mkdir -p /pgdata/14/data
sudo chown postgres:postgres /pgdata/14/data
Then get ...
- 161
3
votes
Accepted
Restoring encrypted DB to SQL vNext
You might be running into a bug in how SQL Server vNext CTP1.2 handles filepaths. To CREATE CERTIFICATE from a backup, you currently need to pre-pend a 'c:' and use backslashes ('\') instead of ...
- 146
3
votes
Accepted
PostgreSQL service start failed on CentOS 7
You have 3 steps before being abble to connect to a PostgreSQL Database:
Install PostgreSQL
Create the data cluster ($PGDATA)
Start the server
You already installed PostgreSQL, you need now to ...
- 1,580
3
votes
Create extension hstore
CentOS 7 was released on 2014-07-07.
PostgreSQL 9.3 was released on 2013-09-09. You would think it would have 9.3, but nope. CentOS 7 uses PostgreSQL 9.2 which was released on 2012-09-10 and hits End-...
- 64.1k
3
votes
Improving RAM and CPU utilization by PostgreSQL 9.6
One possibility is to upgrade to the upcoming PostgreSQL 10 series, which has "better parallelism" as the most popular new feature. See the link for more on the improvement in parallelism.
Another ...
- 3,662
3
votes
Accepted
MariaDB: Disable the GSSAPI plugin
File /etc/my.cnf.d/auth_gssapi.cnf contains the line
plugin-load-add=auth_gssapi.so
Comment it out and restart the service. The server should stop loading the plugin, it will make the errors go ...
- 224
3
votes
When the number of users increases, the site is slowed down
MyISAM. Say no more. The "table locks" are probably what causes the performance to decline as you get more 'users'.
Some tips on the conversion to InnoDB: http://mysql.rjweb.org/doc.php/...
- 78.8k
3
votes
SQL Server on CentOS using CAL licensing
Yes, the wrong SQL Server installation files (for the CAL-based setup) were used. The 20-core-limit version is designed for people upgrading from older versions of SQL Server, as explained by Aaron ...
- 43.1k
3
votes
Mysql 5.6 general log file output not showing unix timestamp
Ok i figure the problem now which is i enabled the mysql general query log through mysql console without restarting mysql , I had to restart mysql services in order to show mysql timestamp in query ...
- 163
3
votes
Accepted
Mysql 8 which linux / Unix Distro would have better performance (2021 topic)
The performance differences between those distros are so subtle that any of them could be the best choice for a given workload. The only way to get a definitive answer for your workload is for you to ...
- 15.4k
2
votes
mysql "can't create test file" error on Centos
When running on CentOS 7, check out the systemd unit files which may prevent writing to / protect non-MySQL directories like /home.
The unit files lives in /usr/lib/systemd/system/mariadb.service.
- 21
2
votes
ERROR 1091 (42000): Can't DROP 'PRIMARY'; on "mysql_upgrade"
I finally figured it out. The main reason for the crashes and the mysql_upgrade error was related to missing and/or corrupted primary keys of the mysql table.
There were also a couple missing records ...
- 131
2
votes
Issue with MongoDB Replication Set
I fixed the issue by adding below lines in /etc/mongod.conf
replication:
replSetName: yogi
- 121
2
votes
Accepted
How do I uninstall the old version of Postgres on CentOS 7?
The newer version of Postgres will be in /usr/pgsql-9.6 (or a similar location) so you can simply use the alternatives command to make this one the default.
- 11.2k
2
votes
Accepted
Postgres 10 replica service error on startup
Finally, I noticed where the problem was. The pg_basebackup copied a recovery.conf file that was originally from the source database, and this caused the break. Removing recovery.conf and creating it ...
- 785
2
votes
Unable to install Oracle XE 18c on Centos 8
The answer wasn't obvious. If you follow the documentation and various posts for installing Oracle XE 18c there appears to be some missing steps if you only use yum to do the installation.
Firstly ...
- 41
2
votes
MariaDB 5.5 InnoDB keeps opening files up to 200k until system hangs
Several possibilities:
Some queries are taking a long time (and hanging onto files (that is, tables) meanwhile). -- Look for slow queries; let's work on speeding them up. You have the slowlog ...
- 78.8k
Only top scored, non community-wiki answers of a minimum length are eligible