62,888 reputation
1062146
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 6 months
seen 13 mins 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


1d
comment How to retrieve stored procedures from raw data
If you copied them, did you run chown mysql:mysql /var/lib/mysql/mysql/proc.* afterwards ?
1d
comment Why is MySQL ignoring my indexes?
That's why I suggested making two more indexes: comp_name_last_ndx and comp_name_first_ndx . You are searching peter at the beginning of the last_name, first_name, and remote_id. I can presume you are not looking a person named 'peter peter' or 'peter, peter'. No need to pair last_name,first_name with company_id unless you specify company_id, last_name, first_name or company_id, last_name. using = instead of LIKE. Even with my answer, Bill's answer (the one you accepted) may still apply if the cardinality of company_id,last_name or company_id,first_name is too low.
1d
comment Finding reason behind high write IOPS on MySQL (RDS) server
I wrote about this some time ago : dba.stackexchange.com/questions/56742/…
Aug
15
comment How does database connection actually works?
I have an old post that addresses it from your perspective : dba.stackexchange.com/questions/16969/…
Aug
15
comment MySQL Replication - Master Master - Single Master write
I fixed my statement !!! Sorry again.
Aug
15
comment MySQL Replication - Master Master - Single Master write
Hey Mike. I owe you an apology for a typo. My answer to point #2 should have said: I would recommend not it since you are doing Master-Master. Yous should not have to do that. If you set up Distribution Masters, then yes you should for DBs you want passed on to other slaves. See my post dba.stackexchange.com/questions/3106/… about Replication using Distribution Masters. I am going to fix my statement.
Aug
15
comment Why is MySQL ignoring my indexes?
Please run SELECT COUNT(1) FROM patient; and tell us the row count.
Aug
14
comment What is real job of a MySQL DBA?
I would recommend the following posts : 1) dba.stackexchange.com/a/19758/877, 2) dba.stackexchange.com/a/2913/877, 3) dba.stackexchange.com/a/9070/877, 4) dba.stackexchange.com/a/6260/877. Please read all the posts, not just my posts. There are other great answers that can gear you for having the right attitude to be a DBA. In reality, it's not all about a specific database. People skills and communications skills also play a major part in the life of a DBA.
Aug
14
comment What is real job of a MySQL DBA?
Over the years, I have seen job postings for MySQL DBA with many other RDBMSs. One example: One job was advertised as MySQL DBA. When I interviewed, the job included Oracle, SQL Server, Vertica, MongoDB. (Some of you out there might be saying "Is that all ?" If so, more power to you !!!) MySQL has always been dreadfully underrated for years. This is why there is a major shortage of MySQL DBAs worldwide. No two companies view a MySQL DBA the same way.
Aug
14
comment MySQL 5.6.17 running out of memory when opening table with many partitions
Ever considered installing 1TB of RAM ??? HA HA
Aug
14
comment MySQL 5.6.17 running out of memory when opening table with many partitions
+1 for finding this out yourself. CAVEAT: You should experiment with MyISAM for table partitioning and see if you have the same issues. For my former employer, I have a daily MyISAM table with 4179 partitions, holding past data and empty partitions for future days. Never had an issue. Of course, I raised the machine's ULIMIT to 102400. I have a separate post on raising innodb_open_files, open_files_limit, and the OS file limit (dba.stackexchange.com/a/60194/877) BTW Welcome to the DBA StackExchange !!!
Aug
13
comment Restoring Mysql Table From ibdata1, ib_logfile0, ib_logfile1 (without frm)
Do you have backups of the .frm files ?
Aug
12
comment MySQL: Find ID with only 2 attached IDs in subtable
Is this MySQL or SQL Server ?
Aug
12
comment Is it safe to delete mysql-bin files?
@changokun That's not a typo. my.cnf will accept dashes. Running SET GLOBAL expire_logs_days = 3; from the mysql client will not accept them. Example in the MySQL Docs : dev.mysql.com/doc/refman/5.5/en/mysqld-option-tables.html
Aug
12
comment Cannot open table mysql/innodb_index_stats
Welcome to the DBA StackExchange. I already mentioned these CREATE TABLE statements in December 2013 (dba.stackexchange.com/a/54624/877). However, I will give a +1 for revealing that a bug report existed and had recommended this (I never knew this). It's a shame mysql_upgrade for 5.6 does not handle this.
Aug
12
comment Show single value of one column for multiple rows of other columns
@MaxVernon Either Jack found the StarGate or is an excellent multitasker.
Aug
12
comment How to sort words in a column in mysql?
@Mihai since you have the right concept please write your comment as a full answer so we can upvote it.
Aug
12
comment Wordpress blog where pages are almost-always served from cache: SSD or more RAM?
How many CPUs/Cores on the Server ?
Aug
12
comment Wordpress blog where pages are almost-always served from cache: SSD or more RAM?
Windows, SIGH !!! :-(
Aug
12
comment Wordpress blog where pages are almost-always served from cache: SSD or more RAM?
@MaxVernon LAMP on 4GB ?? Argh !!! Nonetheless, that was a good question.