323 reputation
45
bio website
location
age
visits member for 1 year, 9 months
seen Nov 8 at 0:12

Feb
17
awarded  Yearling
Sep
20
awarded  Favorite Question
Jul
11
awarded  Scholar
Jul
11
comment Changing the mysql.proc table directly after upgrade
I will probably eventually do the mysql_upgrade after hours, but I want to know what the risks are to a production server first.
Jul
11
accepted Changing the mysql.proc table directly after upgrade
Jul
10
comment Changing the mysql.proc table directly after upgrade
how safe is this? Could I end up bringing down all my sites?
Jul
10
comment Changing the mysql.proc table directly after upgrade
I guess I'm asking, is one way safer or faster then the other? Just curious.
Jul
10
comment Changing the mysql.proc table directly after upgrade
Sure the result is the same, but what I'm proposing doesn't make the mysql.proc table disappear for a second between when the original is renamed for a backup and when the new version is created.
Jul
10
comment Changing the mysql.proc table directly after upgrade
Would it be better to just make a backup of the table and then change the original: CREATE TABLE mysql.proc_bak LIKE mysql.proc; INSERT INTO mysql.proc_bak SELECT * FROM mysql.proc; ALTER TABLE mysql.proc MODIFY comment TEXT;
Jul
10
comment Changing the mysql.proc table directly after upgrade
This seems as drastic as what I'm proposing. My concern is will I corrupt anything in the process or are mysql tables just like any other table?
Jul
10
asked Changing the mysql.proc table directly after upgrade
May
27
awarded  Notable Question
Feb
24
awarded  Good Question
Feb
23
awarded  Popular Question
Feb
22
awarded  Supporter
Feb
22
comment Why can't RDBM's cluster the way NoSQL does?
So i have read and understood (most of) concerned's reply below. The issue seems to have much more to do with ACID then it does with the relational model. Are there solutions that use the relational model, even if they are not fully acid compliant, in the same way NoSQL is? It seems like NoSQL should really be named NoACID as it has nothing to do with sql or relational model, and everything to do with consistency, atomicity, data access and storage locations, etc.
Feb
18
awarded  Nice Question
Feb
17
awarded  Student
Feb
17
asked Why can't RDBM's cluster the way NoSQL does?