8,051 reputation
1822
bio website
location Cincinnati, OH
age 43
visits member for 1 year, 7 months
seen yesterday

If you question or otherwise fail to recognize the superiority of the relational model... you're doing it wrong.


Mar
9
reviewed Leave Open Beginner table design
Mar
9
reviewed Leave Open New field based on sum field
Mar
9
reviewed Leave Open MariaDB Galera Cluster
Mar
9
comment MariaDB Galera Cluster
Did you change wsrep_sst_auth on both machines, or just one? I don't think server X's setting being wrong will stop X from connecting to and synching from Y... I think X's setting being wrong will stop Y (or any other node) from synching from X... the donor node's setting is relevant with innobackupex, not the joining node.
Mar
9
reviewed Leave Open Drastic performance difference in View Dependencies between SQL Server 2005 and 2008 R2
Mar
9
reviewed Close SQL Server 2012 Database Engine Configuration Storage type Raid
Mar
9
comment mysterious load on server due to mysql
@JensW. makes a very good point. Verifying the RAID array would not only potentially make performance terrible, it could also give the illusion that MySQL was the cause when in fact it's only a symptom of the impaired I/O performance. Until the storage array is in a fully normal state, with everything it displays being correctly understood, tinkering with MySQL will be a waste of time.
Mar
8
reviewed Close Choosing between single table and multiple table database scheme
Mar
8
reviewed Close Converting a Ruby on Rails site from MySQL to PostgreSQL?
Mar
8
reviewed Leave Open Which one is better way to insert data?
Mar
7
reviewed Close How to create an efficient, scalable, multi-tenant data layer using MongoDB?
Mar
7
reviewed Leave Open SQL Server query used new index until this morning
Mar
7
reviewed Close Will creating an index improve performance on a full scan
Mar
7
reviewed Close Designing a fragmentation database?
Mar
7
reviewed Close PostgreSQL, storing encrypted data or encrypt database with pgcrypto - what is more secure?
Mar
7
reviewed Close Query causing Database lock problem (php/Mysql)
Mar
7
comment Multi-master + slaves replication in MySQL
@no6 if M1 sends an update to M2, M2 technically will send the update back to M1, because it has to -- binlogs are continuous streams of data, and the same stream is sent to all slaves of a given master -- but when M1 realizes that it was the originator of the event (as it can see from the server_id value of the binlog event) M1's slave IO_thread will discard the event and not write it to M1's relay log, thus the loop is broken when the event arrives back at the originating server. See sql/rpl_slave.cc in the source files if you are curious as to the implementation details.
Mar
5
comment Can someone explain why left joining two views in mysql is so slow?
@a_horse_with_no_name no, it doesn't. This answer is incorrect in that regard. If the MERGE algorithm can be used to process the view, the indexes on the underlying tables can and will be used. Only if the view definition explicitly uses the TEMPTABLE algorithm or the view contains functionality that implicitly requires a temporary table, then the view results will be materialized into a temp table. dev.mysql.com/doc/refman/5.6/en/view-algorithms.html
Mar
4
comment MySQL import low use of resources
Are you running the import process on the server, itself, or remotely? Are you using the mysql command line client, or something else?
Mar
2
answered MariaDB not caching any queries