Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 12
Impact
~5k people reached

Feb
28
awarded  Notable Question
Jan
13
asked How to execute a mysql prepared statement on different database?
Jan
9
comment Check for table lock in conditional statement
So why isn't show open table accessible programmatically ?
Jan
9
accepted Check for table lock in conditional statement
Jan
8
comment Check for table lock in conditional statement
Nice, it will probably be what I'll be going for, though I would have liked to do stuff based on something equivalent to In_use from the SHOW OPEN TABLES, as it doesn't require any tampering with any other procedures that use the table.
Jan
8
comment Check for table lock in conditional statement
@Michael-sqlbot Sql server is 5.5, but if that's a problem I can upgrade it. Added more info to the question.
Jan
8
revised Check for table lock in conditional statement
add context
Jan
7
comment Check for table lock in conditional statement
That would work, but I need to use it in a stored procedure, as I have clients connecting from all kind of platforms.
Jan
7
asked Check for table lock in conditional statement
Dec
23
awarded  Excavator
Dec
23
revised Does Sql Server 2008 support Database Sharding
in the article from Percona there is no mention of mysql cluster: "**MySQL replication** has: Availability and Partitioning tolerance.", read more here : http://messagepassing.blogspot.ro/2012/03/cap-theorem-and-mysql-cluster.html
Dec
23
suggested approved edit on Does Sql Server 2008 support Database Sharding
Dec
23
comment Does Sql Server 2008 support Database Sharding
so Mysql cluster doesn't have either C or A from CAP?
Dec
22
comment Does Sql Server 2008 support Database Sharding
I see that according to the official documentation, MySQL Cluster Evaluation guide: "In terms of CAP, MySQL Cluster will sacrifice availability to maintain consistency in the event of an unsurvivable network partition."
Dec
22
comment Does Sql Server 2008 support Database Sharding
@gbn probably :), but I thought it's worth to have it here for reference, so people know their official solution for "scaling out".
Dec
17
comment Does Sql Server 2008 support Database Sharding
Scaling Out SQL Server : msdn.microsoft.com/en-us/library/aa479364.aspx
Jun
25
awarded  Commentator
Jun
25
comment Unique insert performance: Primary Key vs Unique Index
Correct @Antonis, just that I didn't know how mysql aranges the data on the hdd, and if it would arrange by the primary key, what overhead the varchar would have over int.
Apr
21
awarded  Popular Question
Jan
28
awarded  Tumbleweed