142 reputation
9
bio website ladadadada.net
location London, United Kingdom
age 34
visits member for 3 years, 2 months
seen Mar 19 at 19:11

I'm an Australian by birth but currently live in London. I'm a traveller at heart and I love seeing how different the rest of the world is. I'm always up for something new and interesting.

I've been playing with computers pretty much my whole life, working with them since 2000 in tech support and programming and as a full-time Sysadmin since 2006. I've been fascinated by security since about 2003 and I tend to become the default "security guy" at most places I have worked.

I enjoy all forms of sport and outdoors activities but particularly cycling, hockey, sailboarding, snowboarding, camping and Frisbee. I'm also passionate about the environment, growing my own food, cooking it and eating it.


Dec
11
awarded  Popular Question
Sep
24
awarded  Citizen Patrol
Apr
17
awarded  Critic
Apr
12
awarded  Commentator
Apr
11
comment MySQL tuning (my.cnf) for very large tables and ad hoc queries
I read that as "70 million rows" and edited the question to reflect my reading but if I'm wrong and he actually meant 70 million tables, that would certainly be causing problems.
Apr
11
comment MySQL tuning (my.cnf) for very large tables and ad hoc queries
This question is probably a bit too broad to answer here. You will probably get more useful answers by choosing a single query to optimise and including both that and the table definition(s) in your question.
Apr
8
comment MySQL loses connection
If you have a backup, restoring from that will be the easiest method. A quick read of this should give you an idea of what's required to recover from InnoDB table corruption. Fixing this is beyond my knowledge but I've recommended a migration to DBA.SE where the question is more likely to find an answer.
Apr
8
comment MySQL loses connection
Is there anything in that error log? (/var/log/mysqld.log according to your config.) It sounds like the MySQL server is crashing when trying to open the tables.
Mar
6
comment How to properly kill MySQL?
Is this related to your previous question?
Feb
19
comment Phpmy admin not showing my table but mysqldump
Are any of the crashed tables in the mysql schema?
Nov
13
comment measure the traffic throughput on mysql table
In the same space (and somewhat more updated) are mtop and innotop. None of them do what the OP is asking for, however.
Jul
19
comment Optimizing DELETE Query on MySQL MEMORY Table
What are your settings for query_cache_size and query_cache_type? (I can't remember whether query cache invalidation is included within the query time in the slow query log but setting the query cache too large has bitten me before.)
Jul
4
awarded  Autobiographer
Jun
18
awarded  Scholar
Jun
18
accepted log_warnings doesn't seem to work for aborted connections in MySQL 5.1
Jun
14
awarded  Student
Jun
14
asked log_warnings doesn't seem to work for aborted connections in MySQL 5.1
Feb
21
answered GRANT command not working in MySQL Server
Jan
23
comment MySql: Delete all rows greater than n entries ordered by datetime
I don't think I can figure out a way to do that in a single SQL query (although it probably is possible.) I would just do a GROUP BY uid query to find which users have more than 200 notifications and then do a loop in whatever language you are using to delete all but the most recent 200 for those users.
Jan
22
awarded  Teacher