785 reputation
311
bio website None
location United Kingdom
age 42
visits member for 3 years, 6 months
seen Jun 6 at 12:39

Coding, Golf, Burnout Paradise, Motorbiking... in that order!


Apr
4
awarded  Popular Question
Feb
20
awarded  Yearling
Aug
22
comment MySQL Partitioning
True, but for my particular case we were only interested in single months of data at a time. You could however expand your range to an "IN ()" clause, listing all the relevant months would help there too.
May
26
awarded  Popular Question
Feb
20
awarded  Yearling
Oct
19
answered MySQL ignoring some params from my.cnf
Aug
14
comment Can I have an InnoDB master and MyISAM slaves with Full-Text for searching?
It works great, I have a syslog system, where the master collects data into the BLACKHOLE storage engine, which then off-loads all the heavy lifting to the slave running combinations of MyISAM and InnoDB. This way I can pause the slave in order to analyse the data, leaving the master collecting and only using log storage :)
Jul
9
comment MySQL console: Ctrl+C driving me nuts
I concur with @atxdba - I'm also running the Percona build of 5.5, and ctrl+c drops out of the currently executing command. If there is no command executing, it drops out of the CLI. It may be that ctrl+d drops out of a shell that is running, but if you have a script running within the shell, that will stop if you hit ctrl+c... different commands for different apps / shells / scripts! Can be confusing... :~s
Jul
3
comment Running SQL Query on all databases
Not sure how Wordpress handles passwords though...
Jul
3
comment Running SQL Query on all databases
Can you change from MD5 based passwords, as they aren't really very secure... Read this post by Mr Atwood... codinghorror.com/blog/2007/09/…
Jul
3
comment Running SQL Query on all databases
I agree with the first part of this, build an SQL query containing the schema_name, and just run that. You could even build it in Excel if you needed to - presuming you have all 50 db names that you could put into a column...
Jul
3
comment Error reading MySQL 5.5 binary log using mysqlbinlog
Fortunately, this data is only syslog and nothing more important!!!
Jul
3
accepted Error reading MySQL 5.5 binary log using mysqlbinlog
Jul
3
comment Error reading MySQL 5.5 binary log using mysqlbinlog
Makes me think that having smaller binary logs would be beneficial as I wouldn't loose so much if it happened again. Hasn't happened to me before though :(
Jul
3
comment Error reading MySQL 5.5 binary log using mysqlbinlog
This is what I think I'm going to have to do :(
Jul
3
comment Error reading MySQL 5.5 binary log using mysqlbinlog
Thanks @Dietmar, but I've already tried skipping forward but with no luck, mysqlbinlog will not even read past the offending data. If you set the start-pos to any number, it will start with the first 'correct' location after that and read on. But in this case it won't... :(
Jul
2
asked Error reading MySQL 5.5 binary log using mysqlbinlog
Jun
8
awarded  Caucus
May
8
comment Transaction Lock Timeouts When Updating a Row
I assume that you have an index on the field user_project.id? As without the index, it could be that the queries when combined are just taking too long to read through the data and make the update, ending with both of them timing out. How long does the query take when you run it by hand? And does it complete successfully?
May
3
comment Which mysql storage engine to choose?
I agree with Rolando, especially the last two points regarding performance, if you are able to cache a large portion (preferably all) within RAM, the innodb option wins hands down. MyISAM data is cacheable, but only by the OS, not by MySQL, so you never know when the OS disk cache will get flushed out!