Reputation
621
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
2 8 9
Newest
 Yearling
Impact
~112k people reached

  • 0 posts edited
  • 0 helpful flags
  • 11 votes cast
Dec
30
awarded  Yearling
Dec
13
awarded  Commentator
Dec
13
comment MySQL user per database performance implications?
@RickJames, I'm trying to improve the security too. It was developed shitty before me, also the manager insists on "choose the shortest way the finish the job" as always, so I leave some points as it is, then some bad thing happens and I tell him why, only then I get permission to improve. Yes, because of this I'm going to leave as soon as possible.
Dec
11
comment MySQL user per database performance implications?
@Phil, they don't have database access.
Dec
11
asked MySQL user per database performance implications?
Oct
3
comment What happens if there is missing data in the slave MySQL server
It happened again. I had to start it from mysqld-bin.000139 now. I've counted (COUNT(ID)) rows in few critical tables and they matched exactly with the replication server. I know it is not very healthy method but at least there is daily backups and I think if there is missing data in the replication, it will throw error in near future.
Oct
2
asked What happens if there is missing data in the slave MySQL server
Aug
16
awarded  Popular Question
Jun
1
awarded  Famous Question
Dec
15
comment Can I lose data if I use InnoDB?
What I mean is that although you can see your inserted data in the tables InnoDB can roll few days back if the database is closed.
Dec
15
asked Can I lose data if I use InnoDB?
Dec
15
asked Slow queries while using views in MySQL
Nov
6
awarded  Notable Question
Oct
20
comment “root” execution of the PostgreSQL server is not permitted
@CraigRinger, it gives you several instructions (that most of them work) while installing but one has to be really fast to read, remember and understand what is going on.
Oct
20
asked “root” execution of the PostgreSQL server is not permitted
Sep
5
asked How can I move a MySQL database from 5.1 to 5.6?
Aug
25
awarded  Popular Question
Nov
30
awarded  Yearling
May
21
revised Merging two Access tables into one
deleted 6 characters in body; edited title
May
21
asked Merging two Access tables into one