MySQL out of Memory, but Only Through MSSQL Linked Server
I am getting an error "MySQL client ran out of memory" when trying to do some simple MySQL selects or inserts from Microsoft SQL through a linked server. It was working fine for a week or so, and for some reason now throws the error every time.
If I use Toad to connect to MySQL, everything seems fine running inserts or big selects. But trying to insert just 1 row through the MSSQL Linked server gives an error !?!?
I can "SELECT ID FROM MyTable LIMIT 10", but if I add "ORDER BY ID" to it, I get the error, even though there's an index on ID.
Is there some kind of maintenence I need to do with MySQL ?
I'm pretty much a MySQL "noob" as relates to trouble shooting. It's on a Linux box at our hosting site, with 4 gig ram.
mysql linked-server
asked Jan 22 '15 at 2:46
user57112user57112
11
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I am getting an error "MySQL client ran out of memory" when trying to do some simple MySQL selects or inserts from Microsoft SQL through a linked server. It was working fine for a week or so, and for some reason now throws the error every time.
If I use Toad to connect to MySQL, everything seems fine running inserts or big selects. But trying to insert just 1 row through the MSSQL Linked server gives an error !?!?
I can "SELECT ID FROM MyTable LIMIT 10", but if I add "ORDER BY ID" to it, I get the error, even though there's an index on ID.
Is there some kind of maintenence I need to do with MySQL ?
I'm pretty much a MySQL "noob" as relates to trouble shooting. It's on a Linux box at our hosting site, with 4 gig ram.
mysql linked-server
asked Jan 22 '15 at 2:46
user57112user57112
11
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I am getting an error "MySQL client ran out of memory" when trying to do some simple MySQL selects or inserts from Microsoft SQL through a linked server. It was working fine for a week or so, and for some reason now throws the error every time.
If I use Toad to connect to MySQL, everything seems fine running inserts or big selects. But trying to insert just 1 row through the MSSQL Linked server gives an error !?!?
I can "SELECT ID FROM MyTable LIMIT 10", but if I add "ORDER BY ID" to it, I get the error, even though there's an index on ID.
Is there some kind of maintenence I need to do with MySQL ?
I'm pretty much a MySQL "noob" as relates to trouble shooting. It's on a Linux box at our hosting site, with 4 gig ram.
mysql linked-server
asked Jan 22 '15 at 2:46
user57112user57112
11
I am getting an error "MySQL client ran out of memory" when trying to do some simple MySQL selects or inserts from Microsoft SQL through a linked server. It was working fine for a week or so, and for some reason now throws the error every time.
If I use Toad to connect to MySQL, everything seems fine running inserts or big selects. But trying to insert just 1 row through the MSSQL Linked server gives an error !?!?
I can "SELECT ID FROM MyTable LIMIT 10", but if I add "ORDER BY ID" to it, I get the error, even though there's an index on ID.
Is there some kind of maintenence I need to do with MySQL ?
I'm pretty much a MySQL "noob" as relates to trouble shooting. It's on a Linux box at our hosting site, with 4 gig ram.
mysql linked-server
mysql linked-server
asked Jan 22 '15 at 2:46
user57112user57112
11
asked Jan 22 '15 at 2:46
user57112user57112
11
asked Jan 22 '15 at 2:46
user57112user57112
11
asked Jan 22 '15 at 2:46
user57112user57112
11
asked Jan 22 '15 at 2:46
user57112user57112
11
11
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 9 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Turns out the "fix" was to use OPENQUERY on the MSSQL server to push the processing to the client MySQL server.
-- User57112
answered Jan 30 '15 at 19:44
user57112user57112
1
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f89879%2fmysql-out-of-memory-but-only-through-mssql-linked-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Turns out the "fix" was to use OPENQUERY on the MSSQL server to push the processing to the client MySQL server.
-- User57112
answered Jan 30 '15 at 19:44
user57112user57112
1
add a comment |
Turns out the "fix" was to use OPENQUERY on the MSSQL server to push the processing to the client MySQL server.
-- User57112
answered Jan 30 '15 at 19:44
user57112user57112
1
add a comment |
Turns out the "fix" was to use OPENQUERY on the MSSQL server to push the processing to the client MySQL server.
-- User57112
answered Jan 30 '15 at 19:44
user57112user57112
1
Turns out the "fix" was to use OPENQUERY on the MSSQL server to push the processing to the client MySQL server.
-- User57112
answered Jan 30 '15 at 19:44
user57112user57112
1
answered Jan 30 '15 at 19:44
user57112user57112
1
answered Jan 30 '15 at 19:44
user57112user57112
1
answered Jan 30 '15 at 19:44
user57112user57112
1
1
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f89879%2fmysql-out-of-memory-but-only-through-mssql-linked-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
