66,763 reputation
1070156
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 8 months
seen 10 mins ago

One of JEHOVAH's Witnesses (TV)

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

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


12m
comment Moving a large MySql database(Over 15 GB) from server to server mysqldump
Can you find out if server_id is explicitly set in my.cnf ? If you have mysql root access, please run SHOW GRANTS;. Does the output of SHOW GRANTS; say GRANT ALL PRIVILEGES ON *.* ... ?
17m
comment Moving a large MySql database(Over 15 GB) from server to server mysqldump
Big Questions : 1) What version of MySQL are you running (SELECT VERSION();) ? 2) Is all the data InnoDB ? 3) Can you stop all writes to the database during maintenance window ? 4) Do you have Linux root access, mysql root access, or neither ?
1d
answered MySQL wait_timeout setting ignored
1d
comment MySQL wait_timeout setting ignored
Run the following: SELECT * FROM information_schema.global_variables WHERE variable_name='wait_timeout' UNION SELECT * FROM information_schema.session_variables WHERE variable_name='wait_timeout'; What comes back, one row or two ?
1d
reviewed Close SQL Server stuck in single_user with auto_update_statistics_async on
1d
reviewed Close How to use SQLite3 in VB.Net 2013
1d
reviewed Close One to many size and performance
1d
reviewed Close Are there any minimal sqlite extensions for running a server with role based access control?
1d
reviewed Close Is there a standard mechanism for moving data to a remote database?
1d
reviewed Close T-SQL Parsing XML escaped in format %3E (less than)
1d
reviewed Close Getting error creating database in SQL Server 2005
1d
reviewed Leave Open Seeing multiple CXPACKET blocks when trying to load data from a INSERT SELECT
1d
reviewed Leave Open One field with multiple values?
1d
comment MySQL wait_timeout setting ignored
Please post your my.cnf into the question.
1d
revised MySQL wait_timeout setting ignored
edited tags
1d
revised MySQL slave stuck at 'System lock' most of the time, high CPU usage
added 720 characters in body
1d
answered 500 databases or 1 database with 500 tables or just 1 table with all the records?
1d
answered MySQL slave stuck at 'System lock' most of the time, high CPU usage
2d
comment MySQL slave stuck at 'System lock' most of the time, high CPU usage
Questions: 1) Did you run LOAD DATA INFILE or LOAD DATA LOCAL INFILE on the Master ? 2) Is Relay_Log_Space increasing ?
Oct
22
comment Query where there are only two rows with specific data
This is not just a query, but a work of art. +1 for a single pass aggregation. Very slick !!!