← prev | next →
. 2019-12-08 07:45:29
piterden 2019-12-08 07:45:03
Where are you from?
India
piterden 2019-12-08 07:47:08
Why can’t you make a correct structure self? Have you read wiki about NFs?
. 2019-12-08 07:48:24
Yes I was going through NFs for about three days..
. 2019-12-08 07:48:51
I was not confident that’s why I seek help
2019-12-10 10:46:34
What is best strategy to alter a table column. Pt-online-schema-change and Github Ghost have certain limitations.
piterden 2019-12-10 10:48:53
2019-12-10 10:46:34
What is best strategy to alter a table column. Pt-online-schema-change and Github Ghost have certain limitations.
There isn’t any best strategy. It depends on exact situation
2019-12-10 10:50:11
Situation is mostly table is large and its on production. And we cant afford downtime.
piterden 2019-12-10 10:50:52
Do it at the most quiet time
2019-12-10 10:52:48
Yes that is fine. But whether tools are useful or we can do it manually by creating triggers and creating a secondary table with altered changes and migrate data from main table to secondary. Rename it later.
piterden 2019-12-10 11:00:11
@MasterZiv help please, I don’t know a correct answer
MasterZiv 2019-12-10 11:22:45
piterden 2019-12-10 10:48:53
There isn’t any best strategy. It depends on exact situation
this is a correct answer
piterden 2019-12-10 11:24:04
Oh thnx )
MasterZiv 2019-12-10 11:34:56
2019-12-10 10:50:11
Situation is mostly table is large and its on production. And we cant afford downtime.
Without downtime it is impossible to ALTER TABLE in common case, there are some exact cases when you can change the table online but this depends on the version of MySQL and its flavor (vanilla, maria, percona etc).
If you can’t alter the table online you can add another so called “parallel” table, with same PK as the original table, and with relationship 1:0..1 to the original table, and with attributes containing all fields to be added or changed in the original table, and in all queries you then must use these fields instead of the original ones.
After creation the new table can be supplied with the corresponding actual data.
2019-12-10 13:08:54
MasterZiv 2019-12-10 11:34:56
Without downtime it is impossible to ALTER TABLE in common case, there are some exact cases when you can change the table online but this depends on the version of MySQL and its flavor (vanilla, maria, percona etc).
If you can’t alter the table online you can add another so called “parallel” table, with same PK as the original table, and with relationship 1:0..1 to the original table, and with attributes containing all fields to be added or changed in the original table, and in all queries you then must use these fields instead of the original ones.
After creation the new table can be supplied with the corresponding actual data.
Thank you Ilia
iDoNotHaveAName 2019-12-10 18:47:25
Sorry for disturbing, do you guys know any channels about PHP programming?
Abhishek 2019-12-11 12:51:05
Hello
Can anyone help me?
Stuck with 1 sql query
MasterZiv 2019-12-11 12:51:49
Abhishek 2019-12-11 12:51:05
Hello
Can anyone help me?
Stuck with 1 sql query
ask and we will help
Abhishek 2019-12-11 12:52:57
Need help in 5 query
MasterZiv 2019-12-11 12:54:57
Abhishek 2019-12-11 12:52:57
Need help in 5 query
We do not do hometasks
Abhishek 2019-12-11 12:55:27
Its not homework
MasterZiv 2019-12-11 12:56:25
Abhishek 2019-12-11 12:52:57
Need help in 5 query
For this the key point is to use CASE expressions in aggregate functions
sivarishi 2019-12-11 14:01:35
Hi team… i set binlog_expire_logs_seconds=172800(2 days) but bin log not remove automatcially
sivarishi 2019-12-11 14:02:38
Everytime i need to restart service or flush-logs manullay then only log will remove
sivarishi 2019-12-11 14:02:52
Any solution…Pls guide me
MasterZiv 2019-12-11 14:40:48
sivarishi 2019-12-11 14:01:35
Hi team… i set binlog_expire_logs_seconds=172800(2 days) but bin log not remove automatcially
Is it “empty” at that moment?
sivarishi 2019-12-11 14:46:52
MasterZiv 2019-12-11 14:40:48
Is it “empty” at that moment?
No it was set 1 month but i changed to 2 days in my.cnf file
sivarishi 2019-12-11 14:47:12
It is 8.0.18 Innodb cluster setup
MasterZiv 2019-12-11 14:48:16
I mean did you check the log was really empty at the time it had to be deleted?
MasterZiv 2019-12-11 14:49:02
If not, check
sivarishi 2019-12-11 14:50:15
MasterZiv 2019-12-11 14:48:16
I mean did you check the log was really empty at the time it had to be deleted?
No that time 10days log there in log directory
sivarishi 2019-12-11 14:50:56
After i restarted service then it deleted old logs and keep only 2 days log
sivarishi 2019-12-11 14:51:21
But after two days i checked 4 days log there
sivarishi 2019-12-11 14:51:36
It wont remove automatically
2019-12-11 16:28:19
Hey can anyone help me how to change the value in csv file while taking dump from mysql(load outfile) command…
2019-12-11 16:28:50
Ii gives /n instead of null values
MasterZiv 2019-12-11 16:28:54
2019-12-11 16:28:19
Hey can anyone help me how to change the value in csv file while taking dump from mysql(load outfile) command…
Change it ARTER
2019-12-11 16:29:22
MasterZiv 2019-12-11 16:28:54
Change it ARTER
ARTER?
MasterZiv 2019-12-11 16:30:19
2019-12-11 16:29:22
ARTER?
After dumping
2019-12-11 16:31:57
Actually I write script for make csvfile in event scheduler
MasterZiv 2019-12-12 06:59:10
2019-12-11 16:31:57
Actually I write script for make csvfile in event scheduler
Afair you can dump from a view instead of a table.
Create a view on you table and you will be able to substitute any thing in the data
2019-12-12 15:13:43
Hey…I have a new requirement on my project
2019-12-12 15:14:03
Anyone knows how to setup vitess for mysql
2019-12-12 15:14:21
Please share your concerns
. 2019-12-13 08:54:13
I need to extract the number of logs on an engineer name with respective of the account they are tagged in..
Tables:
Accounts:
-ID PK
-AccountName
-LocationID
Engineer:
-ID
-Employee_Number
-Engineer_Name
Towers:
-ID
-Tower_Name
-Account_ID
-Engineer_Name
Backlogs:
-ID
-Account_ID
-Assigned_To
-Created
. 2019-12-13 08:58:47
The query I wrote is
Select backlogs.Assignedto
Sum ( Case when Datediff(Current_Timestamp, Created)<1 Then 1 Else 0 End ) as Count
From engineer
Inner join towers in engineer. ID=towers. Engineer_ID
Inner join backlogs on engineer. Engineer Name = backlogs. Assigned to
Inner join accounts on accounts. Id = backlogs. Account_ID where backlogs. Account_ID =’2′
Group by backlogs. Assigned to
. 2019-12-13 08:59:00
But I’m not getting the desired output
. 2019-12-13 08:59:08
Can any one help in this please
MasterZiv 2019-12-13 11:35:59
. 2019-12-13 08:58:47
The query I wrote is
Select backlogs.Assignedto
Sum ( Case when Datediff(Current_Timestamp, Created)<1 Then 1 Else 0 End ) as Count
From engineer
Inner join towers in engineer. ID=towers. Engineer_ID
Inner join backlogs on engineer. Engineer Name = backlogs. Assigned to
Inner join accounts on accounts. Id = backlogs. Account_ID where backlogs. Account_ID =’2′
Group by backlogs. Assigned to
How do you think will we guess your desired output?
MasterZiv 2019-12-13 11:37:58
. 2019-12-13 08:59:08
Can any one help in this please
your query is not even syntactically correct..
TheQuotidian 2019-12-16 20:59:00
Not able to connect to MySQL OBDC connector to excel
← prev | next →