92 reputation
39
bio website
location
age
visits member for 5 years, 6 months
seen Feb 20 '10 at 1:06

Jul
5
awarded  Popular Question
May
11
awarded  Notable Question
Mar
29
awarded  Notable Question
Feb
19
comment mysqldump --where with = operator doesn't get all rows
I have given up.. the more I tried the worse it got to access the info. I eventually had to drop it all, including the mysql install. I managed to get a dump of the other tables before all this though using an innodb forced recover 3 level. It is helpful to get data out of a db you otherwise couldn't even start. The mysterious 4 Petabyte table will now forever remain a mystery.
Feb
19
comment mysqldump --where with = operator doesn't get all rows
-f didn't help. Same deal as before. This is an Innodb db, so repair isn't supported.
Feb
19
comment mysqldump --where with = operator doesn't get all rows
This isn't an option as the db contains blob data, which is binary. Part of my problem is that I get so far and then I have an error like this come up: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table table at row: 52739 When I start a different domain_id points, I will get different rows.. always consistent. I know this isn't a timeout issue like most would think from this error, as the timeout settings are set very high.
Feb
19
asked mysqldump --where with = operator doesn't get all rows
Sep
29
awarded  Popular Question
Sep
14
awarded  Tumbleweed
Sep
11
awarded  Popular Question
Sep
7
accepted 5400 RPM vs. 7200 RPM 2.5" Drives in RAID - Any Real Difference?
Jul
11
awarded  Commentator
Jul
11
comment 5400 RPM vs. 7200 RPM 2.5" Drives in RAID - Any Real Difference?
Again I understand a disk to disk comparison gives no competition... but the nature of my question was to not limit the factors to just the disks.. but to take the RAID array, number of disks, and the NAS connection all together. All things considered, will I see a performance hit with 5400 RPM drives compared to 7200?
Jul
11
comment 5400 RPM vs. 7200 RPM 2.5" Drives in RAID - Any Real Difference?
I understand it spins faster than therefore accesses data faster. However, the reason for my question is that I think once you have a RAID array and you have several disks now working in the data read/writes then the 33% difference in a single disk spin. Your answer doesn't seem to take the RAID and multiple disks and its function into account currently. If this was just a disk to disk comparison I would agree.
Jul
10
asked 5400 RPM vs. 7200 RPM 2.5" Drives in RAID - Any Real Difference?
Jul
2
awarded  Teacher
Jun
26
awarded  Beta
May
27
accepted Onboard RAID and Ubuntu Install - Why Does it See Separate Disks?
May
27
answered Onboard RAID and Ubuntu Install - Why Does it See Separate Disks?
May
25
comment Onboard RAID and Ubuntu Install - Why Does it See Separate Disks?
Additional information - Ubuntu 9.04 cannot read ICH10R raid properly. I found reference to this in bug reports. I am going to try kramic and see if it has more support for newer chipsets vs. jaunty.