Reputation
11,407
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 12 30
Newest
 innodb
Impact
~686k people reached

Feb
2
comment Cannot create MySQL database with name '5e370227_db'
+1 for solid sleuthing but it's not an entirely unknown issue (as was also noted in the bug report). The same exception applies to usernames, and any reserved word used as an identifier. The workaround, in any of these cases, is backticks. I would wager against this being fixed any time soon, and plan to use the backticks, or prefix the databases with a character, instead.
Feb
1
comment getting an error in trigger while invoking a procedure in it
What are the : symbols for? MySQL stored programs don't use this with column names.
Feb
1
answered mysqlbinlog recovery table wise
Jan
30
comment #2014 - Commands out of sync. you can't run this command now. Query was working before. But now it is not working
Yes, I understand your point... my point is that from a low-level computer programming perspective, unsigned subtraction never gives negative numbers. 4 - 5 = 65535 for 16 bit unsigned.
Jan
30
comment Is making joins between different table spaces slower?
@Mihai ibdata1 is a tablespace. Every ibd and MYD file is also a tablespace, but they aren't potentially shared like ibdata1.
Jan
30
comment Is making joins between different table spaces slower?
The question asks if different tablespaces makes it slower. "Yes, this can make a difference" means faster, not slower... since different disks implies more I/O bandwidth... right?
Jan
30
comment #2014 - Commands out of sync. you can't run this command now. Query was working before. But now it is not working
This behavior is really not so egregious. Unsigned integer operations produce unsigned integer results. Declaring a value as unsigned is, as you point out, best reserved for surrogate keys, but it's less because MySQL is Doin' it Wrong™ and more because unsigned values are inappropriate arguments if you expect to do signed arithmetic operations. stackoverflow.com/questions/7221409/…
Jan
30
comment How to change ibdata1 path in mysql?
The error log at /var/log/mysqld.log would be the place to look for an explanation of the various errors.
Jan
28
answered On not public server: Host name example.com could not be resolved: Name or service not known
Jan
28
comment On not public server: Host name example.com could not be resolved: Name or service not known
Regarding the processlist... check the IP addresses seen there and do "nslookup" on them from the MySQL server itself and see if one of them resolves back to that address (even though it doesn't make sense that it would).
Jan
28
comment Host Name Resolution in mysql.db and mysql.user tables
You probably don't want to update the mysql.user table like this, as a matter of practice, since it will invalidate the permissions on any stored programs where the affected user is the DEFINER.
Jan
28
comment On not public server: Host name example.com could not be resolved: Name or service not known
What about the other tables in the "mysql" database (like "db" or "procs_priv"?) What if you set "log-warnings = 2" in my.cnf? What if you "nslookup" all the connected clients that show an UP address from SHOW FULL PROCESSLIST; (perhaps there's a reverse entry but not a forward entry in DNS).
Jan
28
comment mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
I suspect that's exactly what it is. The answer I posted to the question in the comment above this one will give you several scenarios and workarounds, although it sounds like you already are familiar with shell behavior now that you're thinking about it.
Jan
28
comment Mysql daemon failed to start: unknown variable password=xxx
Something tells me --no-defaults needs to be the first option, though that may or may not be right. At any rate, mysqld --help --verbose | less should include a list of the various places it could be loading that file from.
Jan
28
answered Can a trasaction be rolled back if a table is edited outside a transaction?
Jan
28
comment mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
Are there any non-alphanumeric characters in the password?
Jan
27
comment Can an index be added to a PRIMARY with a null key?
You can't really "optimize" this query. You need to throw it away and completely rewrite it without the FROM ... JOIN (SELECT ... derived tables, whose purpose is not obvious here. You are materializing the innermost query into a temp table, and doing a full scan of it, repeatedly, almost completely defeating all of your indexes. Using ANSI joins, expressed with t1 JOIN t2 ON instead of joining in WHERE would go a long way toward readability, and consider that DISTINCT is often, through not always, a red flag that says "I got more rows than I expected and I don't understand why."
Jan
27
comment Manage orders based off product attributes and quantity
Food for thought, it's potentially a fundamental error to assume the price and weight of a "S" and an "XXL" are necessarily always the same or that a "red" item and a "blue" item might not be priced differently... or even that a "black" item purchased today is the same price as one purchased tomorrow.
Jan
26
awarded  Revival
Jan
25
answered Alter doesn't show in processlist