66,683 reputation
1070156
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 8 months
seen 9 hours 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


23h
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 !!!
1d
comment Converting 'False'(string) to False(boolean) During LOAD DATA LOCAL INFILE
Thank you for accepting. This is has been a headache for years (forums.mysql.com/read.php?98,395223,395223)
1d
comment Converting 'False'(string) to False(boolean) During LOAD DATA LOCAL INFILE
I got it, please look again !!!
1d
comment Converting 'False'(string) to False(boolean) During LOAD DATA LOCAL INFILE
I had just removed an extra semicolon. Please try again.
Oct
17
comment Integrity constraint violation in Percona XtraDB Cluster
You could use two CNAMEs, 1 that points a specific node as a Master, and the other CNAME shoudl be assigned to a floating load-balanced VIP for SELECTs that can round-robin among the three servers. That may take some additional coding for using two DBVIPs.
Oct
17
comment Mysql Create table shows ERROR 1005 errno 150
Although you did not provide a solution, +1 for revealing root cause.
Oct
17
comment Integrity constraint violation in Percona XtraDB Cluster
If all writes were aimed at one node and auto_increment_increment and auto_increment_offset were left at 1, would this situation have been averted ?
Oct
16
comment Why MySQL init_connect variable gets updated after rebooting?
I guess the garbage showing up in init_connect was a protection against users who do not have SUPER privilege : dev.mysql.com/doc/refman/5.5/en/…
Oct
14
comment Merging tables, but ignoring duplicate columns
Please clarify the Merge. Do you want to load data from city1 into city2, or just run a join query ?
Oct
14
comment Merging tables, but ignoring duplicate columns
Please run SHOW CREATE TABLE city1\G and SHOW CREATE TABLE city2\G and post their output in your question.
Oct
13
comment how to give GLOBAL PRIVILEGES in MySQL?
dev.mysql.com/doc/refman/5.6/en/grant.html
Oct
10
comment MySQL service stops after trying to grant privileges to a user
Let us continue this discussion in chat.
Oct
10
comment MySQL service stops after trying to grant privileges to a user
Is your datadir /var/lib/mysql ?
Oct
10
comment MySQL service stops after trying to grant privileges to a user
Look at my answer, please. You said 39. That means the mysql.user was from MySQL 5.1. EEEEWWW !!!
Oct
10
comment MySQL service stops after trying to grant privileges to a user
This is a little messy. I'll explain in my answer ...
Oct
10
comment MySQL service stops after trying to grant privileges to a user
Please run this query : SELECT COUNT(1) column_count FROM information_schema.columns WHERE table_schema='mysql' AND table_name='user'; What is column_count ?
Oct
10
comment MySQL service stops after trying to grant privileges to a user
Did you recently upgrade from MySQL 5.5 ?
Oct
10
comment Should we enable innodb_file_per_table for single tenant SaaS app (thousands of databases)
That's great. Reminds me of how ORACLE's CREATE TABLE command can use either a default tablespace or a specific tablespace (docs.oracle.com/cd/B28359_01/server.111/b28310/…;. That means CREATE TABLE will soon have a TABLESPACE option. (Maybe Oracle slipped this one in ?)
Oct
9
comment SQL : get rows from two tables relatively
It has to be better in performance. I issue only one query. Your method in PHP is essentially issuing 6 queries (1 against products and 5 against category)
Oct
9
comment SQL : get rows from two tables relatively
Your code would order by cat_id. My proposed query would order it by prod_name as displayed in your question.