61,708 reputation
1061144
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 5 months
seen 2 hours ago

One of JEHOVAH's Witnesses

Seasoned MySQL DBA (SCMDBA) since 2007-08-11

Profile for RolandoMySQLDBA on Stack Exchange, a network of free, community-driven Q&A sites


11h
comment Updating +150,000 rows using .sql file causes ERROR 2013 Lost connection to MySQL server during query
Can you post some of the code from query.sql ?
12h
comment MySQL root changed password went wrong
@RussellUhl That won't work. That's just the password hash.
18h
comment InnoDB import performance
I agree with @yoshi. Your answer is more comprehensive in terms of troubleshooting and performance improvements. +1
1d
comment MySQL replication issue when master gets restarted
Question: So you are running standard MySQL Replication from NodeB to NodeC ?
1d
comment Migrating MySQL database structure with foreign keys fails
What OS and version of MySQL did you dump from ? What OS and version of MySQL are you loading into ?
2d
comment InnoDB import performance
Please run SHOW CREATE TABLE yourtable\G to show us the table structure of this 10 million row table.
Jul
28
comment mysql server cannot launch in windows 7
Let us continue this discussion in chat.
Jul
28
comment mysql server cannot launch in windows 7
Please run cd "C:\Program Files\MySQL\MySQL Server 5.6\data". Then run dir and post that
Jul
28
comment mysql server cannot launch in windows 7
Please run cd C:\Program Files\MySQL\MySQL Server 5.6\data. Then run dir and post that.
Jul
28
comment mysql server cannot launch in windows 7
Don't repair anything yet. Look at the message again. It's recreating Log Files. Your log files are supposed to 100MB (from the my.ini) not the default 48MB.
Jul
28
comment mysql server cannot launch in windows 7
Goto Command Line and run C:\> echo %PATH% and post it please.
Jul
28
comment mysql server cannot launch in windows 7
The messages indicate you created new InnoDB log files. So, you are not running the mysqld.exe in the proper manner. Go to ControlPanel -> AdminstrativeTools -> Services. Scroll down to MySQL56_1 service. Right-click on it and Click Properties. What is the Path to executable ?
Jul
28
comment mysql server cannot launch in windows 7
Part of the Error Message says Can't create test file C:\Program Files\MySQL\MySQL Server 5.6\data\User-PC.lower-test. Is Drive C: full ? Is the Disk ReadOnly ? Do you have disk errors ?
Jul
27
comment MySQL CHAR(500)?
What is the table's storage engine ?
Jul
26
comment How to safely add column to replicated mysql database
Please run SHOW CREATE TABLE mytable\G and run SELECT COUNT(1) FROM mytable; and display it in the question please
Jul
25
comment InnoDB: “Only one log file found” after binary import
Nice Final Answer. +1 !!!
Jul
25
comment Is my MySQL instance irretrievably dead?
@BillKarwin I was thinking the same thing (stackoverflow.com/questions/23276198/…). You should write your comment as an answer.
Jul
25
comment How to stop ROLLBACK in progress?
It will not overwrite table1 because I used the -t option (which means --no-create-info). It prevents the dropping and recreating of the table. You should test this on DEV or STAGING servers to make sure of this action.
Jul
25
comment What could cause waiting for table metadata lock?
Do you ever run TRUNCATE TABLE during this period ?
Jul
24
comment amazon small instance mysql query too slow
Is this Amazon RDS or EC2 ???