Alex Reid
- Total activity 11
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 1
Activity overview
Latest activity by Alex Reid-
Alex Reid commented,
Sorry for the delay (holidays and all) I turned off the Query cache, and disabled cmon and my other monitoring. It seemed that temp table creation was at a minimum (single digits), but the import...
-
Alex Reid commented,
Out of curiosity, any idea why all these temp tables are being created in memory? And whether Galera has anything to do with creating them?
-
Alex Reid commented,
So, I set swappiness to 10 on these database servers. The CPU use was pretty steady -- about 30%, and no swap use. What I found was super interesting was this network spike, which was tied to an in...
-
Alex Reid commented,
So the import was being done to the #2 node, the #1 node is the primary. I have the full set of logs from the most recent crash (I nuked the cluster and started over again last night) here, as well...
-
Alex Reid commented,
Ok, so we got much further with more sensible innodb log sizes, but a deadlock happened, killing the import. When I attempted to clean one of the tables and start a fresh import, I think the same i...
-
Alex Reid commented,
Alright, with a re-bootstrap of the cluster, it's made it through the table it crashed on the import of previously and is continuing to import data smoothly. Thanks, Alex
-
Alex Reid commented,
On a last gasp attempt before I re-bootstrap, I attempted this once more. I'll post back if the gaffe in the innodb log file size fixes things. Is there an appropriate setting for the Galera cach...
-
Alex Reid commented,
Yeah, since I didn't really know what I was getting into with Galera, I did not apply my normal InnoDB configuration settings to the my.cnf that was generated by the SeveralNines configurator. I di...
-
Alex Reid commented,
Hm. Actually it looks like it only made it half-way through importing this table, not the one I posted above, at least according to the only node that I can still query (because it considers itself...
-
Alex Reid created a post,
Having trouble importing data into a Galera cluster
So, this has happened several times now. My cluster layout is like this: 1 control - m1.large 4 cluster db - m1.xlarge I started with the Galera Cluster Configurator and the stock Ubuntu 11.04 N...