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

  • 0 posts edited
  • 0 helpful flags
  • 7 votes cast
Dec
16
accepted Theory of indexes for query with joins
Dec
14
comment Theory of indexes for query with joins
Thanks. Part of my problem is that Kasheff's talk specifically says that this sort of "for each row, look up something in the table" is slow, and you should rather have an index that covers the columns you need so that you can get the results in one go. It seems this can't be avoided for joined tables, though. So would it be reasonable to create the indexes for each table more or less independently based on the where clauses (and maybe the "ON" clauses and columns mentioned in the SELECT clause)? What about OUTER joins?
Dec
14
comment Theory of indexes for query with joins
Perhaps it was a slightly different version of the talk I watched, but he said up front that his rules/guidelines applied to B-Tree indexes as well as fractal tree indexes.
Dec
8
asked Theory of indexes for query with joins
Dec
8
comment How to optimize indexes on MySQL query with various sorts
Have a look at this. It might help: infoq.com/presentations/Index-SQL
Oct
8
asked Replication of MySQL databases, but only some of the data
Jul
27
awarded  Notable Question
Dec
1
accepted is it possible to get innobackupex to print the filenames it's busy with?
Nov
28
awarded  Curious
Nov
28
comment is it possible to get innobackupex to print the filenames it's busy with?
Thanks. I did try strace -f -o strace.out -eopen innobackupex --apply-log ... but the files it printed out did not lead me to the cause of the crash. As @eroomydna suspected, I was using a different version of Xtrabackup. In future I will make sure to prepare the backup immediately instead of before trying to restore it.
Nov
28
comment is it possible to get innobackupex to print the filenames it's busy with?
Thanks. Not sure what you mean by uncompressing all files, but it turns out the version difference was the problem. I successfully ran the apply log on the original server.
Nov
27
asked is it possible to get innobackupex to print the filenames it's busy with?
Nov
26
asked How do I recover from MySQL InnoDB table/index corruption?
Nov
17
awarded  Tumbleweed
Nov
11
comment Migrate from Percona Cluster to MariaDB Cluster
Thanks for the answer.
Nov
10
comment Migrate from Percona Cluster to MariaDB Cluster
I'm about to roll out a Percona XtraDB Cluster. Did you solve your problems?
Oct
27
awarded  Commentator
Oct
27
comment Upgrading hardware for MySQL. If we get SSDs, are CPUs likely to become a bottleneck
Thanks. I suppose that's a fair comment :)
Oct
22
accepted Upgrading hardware for MySQL. If we get SSDs, are CPUs likely to become a bottleneck
Oct
22
comment Upgrading hardware for MySQL. If we get SSDs, are CPUs likely to become a bottleneck
Thanks. I've skimmed the links you sent, but will go through them more thoroughly as soon as I am able.