All Questions
3,782 questions
-1
votes
1
answer
923
views
Update table with value from another table
I have two tables:
AudiTable
Id Audi_cod status marke1
1 011 mid Null
2 022 mid Null
3 033 mid Null
RenoTable
Id ...
- 7
-1
votes
2
answers
2k
views
MySQL query optimization not using index
I'm running into an issue with my MySQL database and I would like to know if any of you could please shed some light.
Background:
I currently have entire schema configured with InnoDB. This database ...
-1
votes
1
answer
518
views
Move data chunk from table with 200+million rows to a new table MySQL
Our DB is hosted in AWS MySQL RDS. The data is such that each company that signs up gets its own set of tables which then receive enormous amount of data in them.
Currently we want to move a chunk of ...
- 1
-1
votes
1
answer
186
views
MariaDB: Error 121 trying to add a foreign key but no foreign key is present
as part of a migration process, I've got a SQL script that adds several foreign key constraints to the database schema. When I run it in our development environment, I get an error 121 and the InnoDB ...
- 53
-1
votes
1
answer
1k
views
HELP - impdp from expdp - do i need to get the .dmp file to the RDS DATA_PUMP_DIR
I've been beating my head against a stubborn wall trying to get a expdp of an oracle schema (on premises db) loaded to my new Oracle RDS instance.
I saw this comment from you and it sounds exactly ...
- 1
-1
votes
1
answer
200
views
How can I randomize primary key values?
I need to avoid having my primary keys sequential. Basically looking for this in MySQL: https://wiki.postgresql.org/wiki/Pseudo_encrypt
- 107
-1
votes
2
answers
1k
views
Optimize query or split in two queries and process result separately?
I have this DB schema:
As you may notice already there is no relationship between tables and won't be on the future. If I run the following queries I will get a lot of rows per table:
SELECT COUNT(*)...
- 1,888
-1
votes
1
answer
72
views
Query error int/varchar LEFTJOIN [closed]
Can someone tell me what´s wrong with this query?
$sql = "select
bans.id as banid,
bans.type,
bans.data,
bans.reason,
bans.expire,
bans.added_by,
bans.added_date,
players.id as playerid,
players....
- 103
-1
votes
1
answer
180
views
Problem on MYSQL WORKBENCH Connection
Your connection attempt failed for user 'dudu' to the MySQL server at 127.0.0.1:3306:
Acess denied for user 'dudu@'localhost
in linux debian booworm, installed mariadb and mysql
-1
votes
1
answer
176
views
Connecting to RDS MySQL from command line sometimes fails -- why?
I have used RDS for many years, and MySQL for even longer, so I am very familiar with both -- yet, I am running into an odd thing that I cannot figure out. Wondering if someone can help.
I have 2 ...
-1
votes
1
answer
1k
views
XAMPP Control Panel mysql shutdown unexpectedly
When I try to start on mysql from xampp control panel it says:
20:52:08 [mysql] Status change detected: stopped
20:52:08 [mysql] Error: MySQL shutdown unexpectedly.
20:52:08 [mysql] This may ...
-2
votes
4
answers
1k
views
Should I spread many connections over a period of time, or hammer the database at same time?
I currently have a fairly small (micro, but can upgrade if necessary) Postgres db instance on Amazon RDS. I think I have a max connections of about 85 (checked through max_connections value in console)...
- 109
-2
votes
1
answer
63
views
Why is it selecting date from another month that requested one? [closed]
I have a table that store time begin and time end of some events. I want to search in this table all even that were occuring during specific day.
Here is example data:
Id
Date begin
Date End
Name
1
...
- 181
-2
votes
2
answers
39
views
Filtering Condition in n-Table Joins
We seem to have a need for a multi-table JOIN operation and I am referring to some notes from an RDBMS class that I took several years ago. In this class the instructor graphically depicted the ...
- 265
-2
votes
1
answer
109
views
With MariaDB, got error when converting int to varchar
With MariaDB version 10.1, We are trying to convert an integer to a string, e.g., varchar(300). Please see the sample SQL below for minimized example.
The convert() function can convert the integer to ...
- 23
-2
votes
1
answer
852
views
MariaDb performance issue
Using mysqltuner, we are facing performance issue with application using this db. We have physical memory of 128 GB. But this db is set to 16 GB. How can increase the memory and performance of this db....
- 1
-2
votes
2
answers
155
views
Get count of unmapped records when using a mapping table
I have 3 tables as such
Product
Product ID
Product Details
1
...
2
...
3
...
Vendor
Vendor ID
Vendor Details
1
...
2
...
3
...
Product Vendors
Product ID
Vendor ID
1
1
2
1
1
2
2
2
3
2
...
- 107
-2
votes
1
answer
56
views
Lots of tables in a mariadb [closed]
Thinking about creating a (mariadb 10.4) "scratch db" where we put summary tables , tables used for cache , etc. The number of tables could get pretty big (potentially 100K) and all of the tables will ...
- 159
-2
votes
1
answer
203
views
MariaDB InnoDb & Columnstore
I have a DB mariadb with innodb tables with one, two million records.
I checked online and saw that Columnstore is faster.
I created a Columnstore table in my DB and put all the contents of the Innodb ...
- 7
-2
votes
1
answer
51
views
Database Select statment not tatking input from html input field
Traceback (most recent call last):
File "/home/will/.local/lib/python3.6/site-packages/flask/app.py", line 2073, in wsgi_app
response = self.full_dispatch_request()
File "/home/will/....
-2
votes
1
answer
3k
views
Reduce your overall MySQL memory footprint for system stability, Dedicate this server to your database for highest performance
Any suggestion on how can I solve this General recommendations by MySQL tuner?
Am using this plugin eningtron
Server info
**OS: CentOS Linux release 7.9.2009 (Core)
Processors: 4 CPU(s)**
**RAM: 7.64 ...
- 1
-2
votes
1
answer
6k
views
error 1292, Truncated incorrect DOUBLE value: ''
im try to insert data to table order but allows im getting error
[22007][1292] Truncated incorrect DOUBLE value: ''
INSERT INTO `order`
SET `order`.customerId = '9e1c8915-c60c-407e-8d34-9fefdffd5ebd',...
-2
votes
1
answer
106
views
AWS TO OCI GOLDENGATE REPLICATION
I want to use oracle Goldengate to my Multi cloud setup database, I'm just wondering if Im required to down my primary database to avoid data discrepancy? or goldengate can sync the data even if my ...
-2
votes
2
answers
43
views
Dynamic table DB design opinions
i need some advice or opinions of "best practices" to clean up the mess i did (quick and dirty) a year ago (to show my idea) wich grew quite quick.
We have around 10 tools (growing by 5 ...
-2
votes
1
answer
44
views
How would you do this simple query in the most optimized way MYSQL and also MARIADB
pkid clientname location
1 Jones NY
2 Jones NJ
3 Jones TX
4 Jones FL
5 Jones IA
6 Jones NC
7 Jones SC
8 Jones VA
9 Smith FL
10 Smith CO
...
-2
votes
1
answer
59
views
Subquery and subselection for Count/Number doesnt work
for example, for company (3) and his partners, I need the number of events with payouts. But i get only the number for one partner, im my example i have
i have 3 tables (t_company, t_partner, t_event,...
- 1
-3
votes
1
answer
2k
views
What is the optimal configuration for MariaDB ? (CentOS 8, MariaDB 10.5)
Hello i have MariaDB 10.5 on a Centos 8
Server configuration
18cores 32 threads and 32gb ram
I have plenty of free ram but I am trying to optimize for CPU
less CPU work and more ram usage
How I do ...
- 13
-3
votes
1
answer
73
views
From a backup strategy perspective, would it be efficient to use a relational DB (as MySql) and a document oriented DB (as MongoDB) in the same app?
I am developing an app where I need to store an undetermined number of properties for any given entity, for example:
Entity || # of properties**
Apples || 14
Oranges || 4
Pears |...
- 1
-3
votes
1
answer
817
views
Recovering root access on MySQL DB [duplicate]
Alright, root@localhost was not connectable with PHP, so I deleted it and created a new root account.
All was fine until I was about to grant privileges when I realized, that none of the other ...
-3
votes
1
answer
47
views
How can I retrieve all hierarchical user data from MySQL tables?
This is a simplified version of my MySql tables.
User table
user_id
user_name
manager_user_id
1
John
Null
2
Maria
1
3
Rob
2
4
Alex
3
User Data table
id
user_id
some_user_data
1
2
abc
2
3
def
...
-3
votes
2
answers
2k
views
LEFT JOIN returns NULL in middle of query [closed]
Started working recently with joins again and I am trying to get the server name from a different table with matching ID's (Foreign Key).
SELECT Website.`services`.`port`,
Website.`services`.`...
- 1
-4
votes
1
answer
1k
views
Update a table based on another table [closed]
I have Cars and Numbers tables, both of them have car_id column. I need to update Cars table like that:
update Cars set Status='old' where serial_num=44;
my tables are like that:
cars
car_id ...
- 7