PHP slow with remote MySql The 2019 Stack Overflow Developer Survey Results Are InWhat could...
Can a rogue use sneak attack with weapons that have the thrown property even if they are not thrown?
Why did Acorn's A3000 have red function keys?
What does Linus Torvalds mean when he says that Git "never ever" tracks a file?
"as much details as you can remember"
Why can Shazam fly?
Did 3000BC Egyptians use meteoric iron weapons?
Why is the maximum length of OpenWrt’s root password 8 characters?
Is there a symbol for a right arrow with a square in the middle?
How to notate time signature switching consistently every measure
What tool would a Roman-age civilization have for the breaking of silver and other metals into dust?
What does ひと匙 mean in this manga and has it been used colloquially?
Origin of "cooter" meaning "vagina"
Why isn't the circumferential light around the M87 black hole's event horizon symmetric?
Time travel alters history but people keep saying nothing's changed
Where to refill my bottle in India?
Loose spokes after only a few rides
What is the meaning of the verb "bear" in this context?
FPGA - DIY Programming
Does the shape of a die affect the probability of a number being rolled?
How to deal with fear of taking dependencies
Apparent duplicates between Haynes service instructions and MOT
What is the motivation for a law requiring 2 parties to consent for recording a conversation
Shouldn't "much" here be used instead of "more"?
Did Section 31 appear in Star Trek: The Next Generation?
PHP slow with remote MySql
The 2019 Stack Overflow Developer Survey Results Are InWhat could be causing strange query timeouts between PHP and MySQL?mysql remote connectMYSQL Master-Slave replication not working with PHPQuickly establishing if a remote MySQL connection is valid using PHPPhp, MySql - OptimisationWhy is there a MySQL character encoding issue after database transfer?Large table load slow mysql php high resources usagePHP MySQL peer to peerForm saving error PHP MYSQLMySQL Replication Slave Status OK but Data inconsistent
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I run ubuntu 18.10 ans Ive ran into issues with a remote database server. I connect using a private network (by ip). The query in the bash mysqlcommand takes about 9ms while in the PHP software (eg. PhpMyAdmin) it takes around 1+ second. Having no clue what can be on. I have also added skip-name-resolve.
The private network resolves second IP in about 50 ms so I dont see a point in long queries.
Worth noting that the local mysql ran perfectly before.
mysql php
asked 7 mins ago
DevKurkaDevKurka
1
New contributor
DevKurka is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I run ubuntu 18.10 ans Ive ran into issues with a remote database server. I connect using a private network (by ip). The query in the bash mysqlcommand takes about 9ms while in the PHP software (eg. PhpMyAdmin) it takes around 1+ second. Having no clue what can be on. I have also added skip-name-resolve.
The private network resolves second IP in about 50 ms so I dont see a point in long queries.
Worth noting that the local mysql ran perfectly before.
mysql php
asked 7 mins ago
DevKurkaDevKurka
1
New contributor
DevKurka is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I run ubuntu 18.10 ans Ive ran into issues with a remote database server. I connect using a private network (by ip). The query in the bash mysqlcommand takes about 9ms while in the PHP software (eg. PhpMyAdmin) it takes around 1+ second. Having no clue what can be on. I have also added skip-name-resolve.
The private network resolves second IP in about 50 ms so I dont see a point in long queries.
Worth noting that the local mysql ran perfectly before.
mysql php
asked 7 mins ago
DevKurkaDevKurka
1
New contributor
DevKurka is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I run ubuntu 18.10 ans Ive ran into issues with a remote database server. I connect using a private network (by ip). The query in the bash mysqlcommand takes about 9ms while in the PHP software (eg. PhpMyAdmin) it takes around 1+ second. Having no clue what can be on. I have also added skip-name-resolve.
The private network resolves second IP in about 50 ms so I dont see a point in long queries.
Worth noting that the local mysql ran perfectly before.
mysql php
mysql php
asked 7 mins ago
DevKurkaDevKurka
1
New contributor
DevKurka is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 7 mins ago
DevKurkaDevKurka
1
New contributor
DevKurka is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 7 mins ago
DevKurkaDevKurka
1
New contributor
DevKurka is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 7 mins ago
DevKurkaDevKurka
1
asked 7 mins ago
DevKurkaDevKurka
1
1
New contributor
DevKurka is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
DevKurka is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
DevKurka is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
0
active
oldest
votes
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
});
}
});
DevKurka is a new contributor. Be nice, and check out our Code of Conduct.
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%2f234506%2fphp-slow-with-remote-mysql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
DevKurka is a new contributor. Be nice, and check out our Code of Conduct.
DevKurka is a new contributor. Be nice, and check out our Code of Conduct.
DevKurka is a new contributor. Be nice, and check out our Code of Conduct.
DevKurka is a new contributor. Be nice, and check out our Code of Conduct.
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%2f234506%2fphp-slow-with-remote-mysql%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
