Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 11651

All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.

3
votes
InnoDB: We intentionally generate a memory trap. It looks like InnoDB is deliberately crashing itself because it's encountering a problem with your on-disk data structures that it cannot safely reco …
answered Jan 30 '13 by Michael - sqlbot
1
vote
holdover from the early evolution of MySQL when fixed-width terminals were common. MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following …
answered Oct 26 '13 by Michael - sqlbot
2
votes
purposes, MySQL does not have any mechanisms for prioritization like this. Every query is executed with comparable priority, subject to the limits of disk I/O, CPU clock speed and number of cores … , or you need to scale out with a read replica, or migrate some of the databases to a different machine... or, of course, if the machine isn't dedicated exclusively to running MySQL, then that's potentially problematic as well. See also: Is there a way to achieve Workload Management in MySQL? …
answered Nov 1 '13 by Michael - sqlbot
1
vote
This has nothing to do with the MySQL server, so no troubleshooting on that side should be needed. It is also unrelated to usernames, machine names, and passwords. C:\>perror 10055 Win32 error … code 10055: An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full. The MySQL server is not returning this error. Windows, on …
answered Jun 16 '13 by Michael - sqlbot
3
votes
/refman/5.6/en/downgrading.html Or, better (I think) than just copying the new (old version) binaries over the old (new version), use the mechanism I use, where /usr/local/mysql is a symlink to the … near my MySQL. Nobody decides when we upgrade or what version we run, other than me, so upgrades occur when planned and after testing. With this setup, it's a quick operation to stop the service …
answered Jul 28 '15 by Michael - sqlbot
1
vote
SET lc_messages = ... doesn't work in MySQL Server 5.1. This variable was introduced in 5.5. Before MySQL 5.5, the lc_messages_dir and lc_messages system variables were unavailable. To …
answered Nov 16 '16 by Michael - sqlbot
2
votes
had succeeded in appending to /etc/password, you would have only modified your local password file, not the one on the server. The pager is always local to where the mysql client is running. It has … nothing to do with the MySQL server. If the user on the local machine (where the client is running) has write access to a local file, then they can write to the file via the pager option, just as …
answered Jul 8 '13 by Michael - sqlbot
1
vote
works as long as your @@SQL_MODE doesn't include NO_AUTO_CREATE_USER, which isn't there by default in 5.5. In MySQL Server 5.7, Oracle (motto: "if it ain't broke, it will be broken soon") has deprecated …
answered Jan 27 '16 by Michael - sqlbot
2
votes
These tables appear to be using the Entity-Attribute-Value model, which is often not the best model to use, the complexity of the queries being only one reason for this. The problem here is not so mu …
answered Sep 3 '13 by Michael - sqlbot
2
votes
? mysql> SELECT SOUNDEX_SPLITTED(REPEAT('a',255),','); -- nothing happens You have an infinite loop, because you never find the trailing space you're expecting, so this... WHILE spaceLast … wouldn't see it, since the function is still running in an endless loop. I'm not suggesting the following is the correct fix, but will easily demonstrate the problem (works with MySQL 5.5 and up …
answered Jan 8 '15 by Michael - sqlbot
6
votes
There are three "official" Oracle tools for managing MySQL in the sense you describe, two of which are currently supported. MySQL Workbench I assume is the administration tool that's most analogous … to SSMS. The mysql command line client is a console utility that allows you to issue queries and get results displayed in "ascii line drawing" tables. MySQL Query Browser is no longer officially …
answered Mar 11 '14 by Michael - sqlbot
7
votes
If you stop the MySQL Server process gracefully, the filesystem and databases won't be corrupted. Here are a couple of things I typically do: Verify that innodb_fast_shutdown is disabled. If it … isn't, disable it. mysql> show variables like 'innodb_fast_shutdown'; +----------------------+-------+ | Variable_name | Value | +----------------------+-------+ | innodb_fast_shutdown | 0 …
answered Jan 19 '13 by Michael - sqlbot
3
votes
It's probably good that you added that afterthought, because that's very likely what you're experiencing... the server is rolling back the work it had already done before you killed the large update. …
answered Jun 25 '14 by Michael - sqlbot
2
votes
Arguably, you would be better off with the NULL since that's the absence of a value, rather than arbitrary text indicating the absence of a valid value... but: -- 8< -- snip -- 8<-- ldap_ful …
answered Jan 17 '14 by Michael - sqlbot
2
votes
This sounds like a job for a correlated subquery. SELECT mp.id AS id, p.name AS productName, m.name AS marketName, mp.identifier, (SELECT the_price_column FROM price pr …
answered Oct 17 '13 by Michael - sqlbot

15 30 50 per page