| --- | Log | opened Thu Aug 22 00:00:04 2019 |
| 00:05 | -!- | kharlan [~abi@0002967b.user.oftc.net] has quit [Quit: WeeChat 1.0.1] |
| 00:06 | -!- | kharlan [~abi@0002967b.user.oftc.net] has joined #linode |
| 00:06 | -!- | kharlan is "abi" on #linode |
| 00:17 | <randallman> | @rgerke, I failed :) |
| 00:17 | <randallman> | @rgerke, busy day... sigh |
| 00:18 | <randallman> | writing manifests to containerize all of the things |
| 00:18 | <randallman> | setup a libreswan vpn to the linode for no reason :p |
| 00:18 | <randallman> | installing ipa-client |
| 00:18 | <randallman> | @ heya guys, there used to be a spot to change the reverse DNS of a linode? |
| 00:18 | <randallman> | Nevermind found |
| 00:19 | <randallman> | wow, my domain is "invalid" if I include the trailing dot for the PTR record in the UI ? :P |
| 00:29 | -!- | MathBlade [~oftc-webi@c-24-7-152-243.hsd1.ca.comcast.net] has joined #linode |
| 00:29 | -!- | MathBlade is "OFTC WebIRC Client" on #linode |
| 00:29 | -!- | MathBlade [~oftc-webi@c-24-7-152-243.hsd1.ca.comcast.net] has quit [Remote host closed the connection] |
| 00:30 | -!- | randallman [~console@li1929-235.members.linode.com] has quit [Quit: Lost terminal] |
| 00:30 | <synapt> | randallman: because the interface for the reverse DNS is no... nevermind |
| 00:35 | -!- | AnMaster [~AnMaster@c80-216-244-252.bredband.comhem.se] has quit [Ping timeout: 480 seconds] |
| 00:41 | -!- | gparent_ [~g@qubcpq0336w-lp130-05-74-15-19-63.dsl.bell.ca] has joined #linode |
| 00:41 | -!- | gparent_ is "g" on #linode |
| 00:42 | -!- | gparent [~g@0001b079.user.oftc.net] has quit [Ping timeout: 480 seconds] |
| 00:43 | -!- | gparent_ is now known as gparent |
| 00:44 | -!- | rrmirs [~oftc-webi@103.21.67.15] has joined #linode |
| 00:44 | -!- | rrmirs is "OFTC WebIRC Client" on #linode |
| 00:46 | -!- | rrmirs [~oftc-webi@103.21.67.15] has quit [] |
| 00:49 | -!- | AnMaster [~AnMaster@c80-216-244-252.bredband.comhem.se] has joined #linode |
| 00:49 | -!- | AnMaster is "AnMaster" on #linode |
| 00:54 | -!- | dsapikas [~dsapikas@ip-109-41-129-199.web.vodafone.de] has joined #linode |
| 00:54 | -!- | dsapikas is "purple" on #linode |
| 01:04 | -!- | john [~oftc-webi@140.206.46.74] has joined #linode |
| 01:04 | -!- | john is "OFTC WebIRC Client" on #linode |
| 01:05 | <john> | could pay the linode via WECHAT or AliPay? |
| 01:06 | <john> | I don't have a credit card |
| 01:06 | <kharlan> | john: I don't think that's possible. |
| 01:06 | <kharlan> | https://www.linode.com/docs/platform/billing-and-support/billing-and-payments/ |
| 01:08 | <john> | it's a tough way to buy vps from linode |
| 01:08 | <john> | :( |
| 01:13 | <dwfreed> | get a prepaid card |
| 01:19 | -!- | fergtm [~fergtm@dyn-2001-0470-1f0f-006e-f419-c90a-9cac-461a.hq-ptr.nil.com.mx] has quit [Ping timeout: 480 seconds] |
| 01:20 | -!- | |GIG-1 [~MYOB@158.115.253.31] has quit [Remote host closed the connection] |
| 01:23 | -!- | john [~oftc-webi@140.206.46.74] has quit [Remote host closed the connection] |
| 01:24 | -!- | |GIG [~MYOB@158.115.253.31] has joined #linode |
| 01:24 | -!- | |GIG is "J" on #moocows #linode |
| 01:28 | -!- | fergtm [~fergtm@dyn-2001-0470-1f0f-006e-180b-8056-6f51-dec7.hq-ptr.nil.com.mx] has joined #linode |
| 01:28 | -!- | fergtm is "Fernando" on #linode |
| 01:38 | -!- | Ikaros [ikaros@IkarosBD.dlls.tx.Eris.bdikaros-network.net] has quit [Quit: ...bah] |
| 01:58 | <chesty> | do you need ID to get a prepaid card? |
| 01:59 | <@rgerke> | chesty: I don't think so. I've seen them on the racks at places like 7-11 |
| 02:00 | <@rgerke> | I think it's like buying yuourself a gift card. |
| 02:01 | <chesty> | nice. I should get some. Not that I do anything illegal but I hate my data being collected and sold |
| 02:19 | -!- | king_john_eel [~yose@58.173.164.235] has quit [Ping timeout: 480 seconds] |
| 02:54 | -!- | qwaszx23 [~oftc-webi@78.31.204.24] has joined #linode |
| 02:54 | -!- | qwaszx23 is "OFTC WebIRC Client" on #linode |
| 02:54 | -!- | skule [~svs@cpe.ge-3-1-5-100.sbynqe10.dk.customer.tdc.net] has joined #linode |
| 02:54 | -!- | skule is "steffen" on #linode #linux.dk #virt #qemu #openjdk |
| 03:14 | -!- | qwaszx23 [~oftc-webi@78.31.204.24] has quit [Quit: Page closed] |
| 03:32 | -!- | talha [~oftc-webi@39.40.69.172] has joined #linode |
| 03:32 | -!- | talha is "OFTC WebIRC Client" on #linode |
| 03:33 | -!- | talha [~oftc-webi@39.40.69.172] has quit [] |
| 04:27 | -!- | dsapikas [~dsapikas@ip-109-41-129-199.web.vodafone.de] has quit [Read error: Connection reset by peer] |
| 04:34 | -!- | lts [~lts@117.89.169.230] has joined #linode |
| 04:34 | -!- | lts is "lts" on #linode |
| 04:38 | -!- | lts [~lts@117.89.169.230] has left #linode [] |
| 04:38 | -!- | darwin [d@melik.windwireless.net] has quit [Ping timeout: 480 seconds] |
| 04:58 | -!- | DrJ- [~B@li1303-21.members.linode.com] has joined #linode |
| 04:58 | -!- | DrJ is now known as Guest552 |
| 04:58 | -!- | DrJ- is "B@c0n" on #linode |
| 04:58 | -!- | DrJ- is now known as DrJ |
| 05:04 | -!- | synapt [NBishop@00013625.user.oftc.net] has quit [Ping timeout: 480 seconds] |
| 05:04 | -!- | Guest552 [~B@li1303-21.members.linode.com] has quit [Ping timeout: 480 seconds] |
| 05:07 | -!- | king_john_eel [~yose@58.173.164.235] has joined #linode |
| 05:07 | -!- | king_john_eel is "king_john_eel" on #qemu #linode |
| 05:36 | -!- | dsapikas [~dsapikas@5-203-196-9.mobile.nym.cosmote.net] has joined #linode |
| 05:36 | -!- | dsapikas is "purple" on #linode |
| 05:36 | -!- | John [~oftc-webi@123.242.242.16] has joined #linode |
| 05:36 | -!- | John is "OFTC WebIRC Client" on #linode |
| 05:36 | -!- | John [~oftc-webi@123.242.242.16] has quit [] |
| 05:54 | -!- | dsapikas1 [~dsapikas@internet1-5-144-211-197.pat.ren.cosmote.net] has joined #linode |
| 05:54 | -!- | dsapikas1 is "purple" on #linode |
| 05:59 | -!- | dsapikas [~dsapikas@5-203-196-9.mobile.nym.cosmote.net] has quit [Ping timeout: 480 seconds] |
| 06:04 | -!- | fstd_ [~fstd@xdsl-78-35-207-82.nc.de] has joined #linode |
| 06:04 | -!- | fstd_ is "fstd" on #oftc #linode #debian #kernelnewbies |
| 06:07 | -!- | dsapikas [~dsapikas@5-203-202-56.mobile.nym.cosmote.net] has joined #linode |
| 06:07 | -!- | dsapikas is "purple" on #linode |
| 06:08 | -!- | dsapikas1 [~dsapikas@internet1-5-144-211-197.pat.ren.cosmote.net] has quit [Ping timeout: 480 seconds] |
| 06:11 | -!- | fstd [~fstd@xdsl-87-79-148-62.nc.de] has quit [Ping timeout: 480 seconds] |
| 06:17 | -!- | dsapikas [~dsapikas@5-203-202-56.mobile.nym.cosmote.net] has quit [Read error: Connection reset by peer] |
| 06:17 | -!- | dsapikas [~dsapikas@5-203-239-100.mobile.nym.cosmote.net] has joined #linode |
| 06:17 | -!- | dsapikas is "purple" on #linode |
| 06:22 | -!- | dsapikas [~dsapikas@5-203-239-100.mobile.nym.cosmote.net] has quit [Read error: Connection reset by peer] |
| 06:24 | -!- | nate [NBishop@d-207-255-41-254.paw.cpe.atlanticbb.net] has joined #linode |
| 06:24 | -!- | nate is "Nathan" on #linode #php |
| 06:44 | -!- | thiras [~thiras@195.174.215.70] has joined #linode |
| 06:44 | -!- | thiras is "Ant" on #debian #linode #tami |
| 07:29 | -!- | dsapikas [~dsapikas@5-203-239-100.mobile.nym.cosmote.net] has joined #linode |
| 07:29 | -!- | dsapikas is "purple" on #linode |
| 07:35 | -!- | |GIG [~MYOB@158.115.253.31] has quit [Quit: irc.usairc.org ( USA IRC )] |
| 07:48 | -!- | ro0xt [~apple@58.16.228.128] has joined #linode |
| 07:48 | -!- | ro0xt is "apple" on #linode |
| 07:48 | -!- | ro0xt [~apple@58.16.228.128] has left #linode [] |
| 08:05 | -!- | dsapikas [~dsapikas@5-203-239-100.mobile.nym.cosmote.net] has quit [Read error: Connection reset by peer] |
| 08:49 | -!- | randall [~randall@aardvark.randallman.net] has joined #linode |
| 08:49 | -!- | randall is "Randall Shutt" on #linode |
| 09:07 | -!- | anomie [~anomie@00018802.user.oftc.net] has joined #linode |
| 09:07 | -!- | anomie is "Anomie" on #linode |
| 09:12 | -!- | Aswinth [~oftc-webi@119.82.109.174] has joined #linode |
| 09:12 | -!- | Aswinth is "OFTC WebIRC Client" on #linode |
| 09:13 | -!- | Aswinth [~oftc-webi@119.82.109.174] has left #linode [] |
| 09:40 | <linbot> | New news from community: Can I transfer files between two Linode's using a Block Storage Volume? <https://www.linode.com/community/questions/18663> |
| 09:40 | <grawity> | tbh I always thought that kind of defeats the point of linode's credit card requirement |
| 09:44 | <nate> | I'm not sure how pre-paids work with linode if at all, depends I guess if they actually enforce verification of the personal-information bit (which I believe will usually fail on pre-paids if things haven't changed) |
| 09:47 | <chesty> | people using pre-paid might get asked to send a photo of their ID through a secure channel |
| 09:47 | <cruxeternus> | I've seen people come in here and have problems with pre-paid cards |
| 09:48 | <cruxeternus> | So Linode does require extra in those cases |
| 09:50 | <cruxeternus> | problems = wouldn't automatically approve them |
| 09:52 | <cruxeternus> | On an unrelated note, I've just discovered the rabbit hole of awesome-* lists, and I may never get out... |
| 09:57 | <ang> | sometimes I'll have a gift card with $5-$20 left on it that is a few days from expiring and I'll just throw it at my linode balance. never had a problem. |
| 10:00 | <dzho> | cruxeternus: this is related to my saying "so much good free software, so little time" |
| 10:01 | <cruxeternus> | I had no idea how much though |
| 10:10 | <cruxeternus> | ang: Right. But you were previously authenticated in some other way. |
| 10:18 | <nate> | ^ |
| 10:20 | <linbot> | New news from community: Linode graphs show 100% CPU usage for my Minecraft v1.14 server, but top shows low CPU usage. Which one is right? <https://www.linode.com/community/questions/18660> |
| 10:26 | -!- | dsapikas [~dsapikas@2001:67c:20a1:1192:986e:baa1:6f59:2dfd] has joined #linode |
| 10:26 | -!- | dsapikas is "purple" on #linode |
| 10:38 | -!- | eyepulp [~eyepulp@107.152.1.51] has joined #linode |
| 10:38 | -!- | eyepulp is "eyepulp" on #linode |
| 10:43 | -!- | benson [~oftc-webi@2001-b011-800e-321a-1c82-f19f-fb9e-f5fc.dynamic-ip6.hinet.net] has joined #linode |
| 10:43 | -!- | benson is "OFTC WebIRC Client" on #linode |
| 10:43 | -!- | benson [~oftc-webi@2001-b011-800e-321a-1c82-f19f-fb9e-f5fc.dynamic-ip6.hinet.net] has quit [] |
| 10:44 | -!- | tux0r [~tux0r@host-64-47-44-1.masergy.com] has joined #linode |
| 10:44 | -!- | tux0r is "realname" on #linode #linux #debian |
| 10:46 | -!- | tux0r [~tux0r@host-64-47-44-1.masergy.com] has quit [] |
| 10:46 | -!- | _eyepulp [~eyepulp@2600:380:645d:d6ba:7457:60a2:2a41:b63d] has joined #linode |
| 10:46 | -!- | _eyepulp is "eyepulp" on #linode |
| 10:50 | -!- | V-Pariah [~viciouspa@c-24-62-136-178.hsd1.ma.comcast.net] has quit [Read error: Connection reset by peer] |
| 10:53 | -!- | eyepulp [~eyepulp@107.152.1.51] has quit [Ping timeout: 480 seconds] |
| 11:03 | <LouWestin> | Oh dear, 1.13 is way out of date. Supposedly 1.14.4 fixed that CPU issue. |
| 11:04 | <LouWestin> | But haven’t tested it to comfirm |
| 11:07 | <nobaudy> | LouWestin: it does not |
| 11:11 | -!- | V-Pariah [viciouspar@c-24-62-136-178.hsd1.ma.comcast.net] has joined #linode |
| 11:11 | -!- | V-Pariah is "Vicious Pariah" on #linode |
| 11:13 | -!- | thiras [~thiras@195.174.215.70] has quit [Ping timeout: 480 seconds] |
| 11:13 | <nobaudy> | at least it still is true to the community question in that top shows 10-20% cpu but linode graph shows 100% |
| 11:14 | <@bbigger> | yea I'm testing right now with the latest version and the issue is still present |
| 11:35 | -!- | V-Pariah [viciouspar@c-24-62-136-178.hsd1.ma.comcast.net] has quit [Ping timeout: 480 seconds] |
| 11:45 | -!- | _eyepulp [~eyepulp@2600:380:645d:d6ba:7457:60a2:2a41:b63d] has quit [Ping timeout: 480 seconds] |
| 11:47 | -!- | V-Pariah [viciouspar@c-24-62-136-178.hsd1.ma.comcast.net] has joined #linode |
| 11:47 | -!- | V-Pariah is "Vicious Pariah" on #linode |
| 12:03 | -!- | V-Pariah [viciouspar@c-24-62-136-178.hsd1.ma.comcast.net] has quit [Read error: Connection reset by peer] |
| 12:05 | -!- | primitiv [~oftc-webi@107-179-235-11.cpe.teksavvy.com] has joined #linode |
| 12:05 | -!- | primitiv is "OFTC WebIRC Client" on #linode |
| 12:08 | -!- | thiras [~thiras@195.174.215.70] has joined #linode |
| 12:08 | -!- | thiras is "Ant" on #debian #linode #tami |
| 12:08 | <primitiv> | Failed authorization procedure. www.ddlures.ca (http-01): urn:ietf:params:acme:error:connection :: The server could not connect to the client to verify the domain :: dns :: DNS problem: NXDOMAIN looking up A for www.ddlures.ca |
| 12:08 | <primitiv> | this is the only domain having issues renewing |
| 12:08 | <primitiv> | i am running certbot --http-01-port 8080 |
| 12:09 | <millisa> | it doesnt have a dns entry |
| 12:10 | -!- | dsapikas [~dsapikas@2001:67c:20a1:1192:986e:baa1:6f59:2dfd] has quit [Ping timeout: 480 seconds] |
| 12:13 | <millisa> | dns to the servers listed in the whois record comes back with something. looks like the domain is in 'clienthold' at the registrar |
| 12:13 | <millisa> | probably expired or they didn't reply to one of the info requests. looks like it changed on the first. |
| 12:20 | <primitiv> | meaning the dns changed? |
| 12:21 | <primitiv> | ahh the site doesnt work |
| 12:22 | <primitiv> | domain expired july 31st it never got renewed lol\ |
| 12:22 | <primitiv> | thank you! |
| 12:22 | <millisa> | sure thing |
| 12:27 | <cruxeternus> | !point millisa |
| 12:27 | <linbot> | cruxeternus: Point given to millisa. (91) (Biggest fan: relidy, total: 17) |
| 12:31 | -!- | primitiv [~oftc-webi@107-179-235-11.cpe.teksavvy.com] has quit [Quit: Page closed] |
| 12:48 | -!- | Me [~oftc-webi@5-14-9-82.residential.rdsnet.ro] has joined #linode |
| 12:48 | -!- | Me is "OFTC WebIRC Client" on #linode |
| 12:49 | -!- | Me [~oftc-webi@5-14-9-82.residential.rdsnet.ro] has quit [] |
| 13:00 | <linbot> | New news from community: How do I enable addresses from a IPv6 /116 permanently using Netplan? <https://www.linode.com/community/questions/18664> |
| 13:04 | -!- | V-Pariah [viciouspar@c-24-62-136-178.hsd1.ma.comcast.net] has joined #linode |
| 13:04 | -!- | V-Pariah is "Vicious Pariah" on #linode |
| 13:30 | -!- | FondationCSDM [~oftc-webi@132.219.146.174] has joined #linode |
| 13:30 | -!- | FondationCSDM is "OFTC WebIRC Client" on #linode |
| 13:32 | -!- | FondationCSDM [~oftc-webi@132.219.146.174] has quit [] |
| 13:45 | -!- | nick2 [~clevbm201@138.36.2.250] has quit [Ping timeout: 480 seconds] |
| 13:48 | -!- | CodeMouse92 [~JasonMc92@00025241.user.oftc.net] has joined #linode |
| 13:48 | -!- | CodeMouse92 is "Jason C. McDonald" on #packaging #linode #c++ |
| 13:57 | -!- | CodeMouse92 [~JasonMc92@00025241.user.oftc.net] has quit [Quit: Oh freddled gruntbuggly | Thy micturations are to me | As plurdled gabbleblotchits | On a lurgid bee] |
| 14:11 | <linbot> | New news from community: How do I reset my network interfaces to default settings? <https://www.linode.com/community/questions/18665> |
| 14:20 | -!- | dannyAAM [~dannyAAM@saru.saru.moe] has quit [Quit: znc.saru.moe : ZNC 1.6.2 - http://znc.in] |
| 14:20 | -!- | dannyAAM [~dannyAAM@saru.saru.moe] has joined #linode |
| 14:20 | -!- | dannyAAM is "Danny" on #linode |
| 14:21 | <linbot> | New news from community: I tried signing up and now I’m being asked to verify my identity. What gives? <https://www.linode.com/community/questions/18666> |
| 14:21 | -!- | king_john_eel [~yose@58.173.164.235] has quit [Ping timeout: 480 seconds] |
| 14:41 | <linbot> | New news from community: What is spamvertisement? <https://www.linode.com/community/questions/18668> || What is spamvertisement? <https://www.linode.com/community/questions/18667> |
| 14:45 | -!- | DrJ [~B@li1303-21.members.linode.com] has quit [Ping timeout: 480 seconds] |
| 15:42 | <LouWestin> | Nobaudy: crap... ok |
| 15:56 | -!- | redentor [~armando@2806:1000:8001:2b1b:cff2:bf45:422d:d729] has joined #linode |
| 15:56 | -!- | redentor is "realname" on #debian-next #debian-es #debian-mx #debian #linode |
| 15:58 | -!- | GJZwart [~oftc-webi@2001:4649:128::4c95:da7f:3df:5a7e] has joined #linode |
| 15:58 | -!- | GJZwart is "OFTC WebIRC Client" on #linode |
| 15:59 | <GJZwart> | Hi! |
| 15:59 | <millisa> | Greetings! |
| 16:01 | <GJZwart> | Im a mac os developer, and have a back end running on a nanode plan.. it suddenly started to max out the cpu today.. I cant think of a reason for it to do so, but maybe anyone here could help me out |
| 16:01 | <millisa> | Are you looking at it with top? htop? |
| 16:01 | <GJZwart> | I dont know where to start researching this, so a little help would be appreciated.. |
| 16:01 | <GJZwart> | ok, is that a command I have to run in the terminal? |
| 16:02 | <millisa> | They are commands you'd use in a shell, sure. |
| 16:02 | <millisa> | top is kind of like the Activity Monitor in osx |
| 16:02 | <GJZwart> | I have a dashboard app called goPanel2, and that one says Im using 16.1 % CPU usage |
| 16:02 | <GJZwart> | ok, Ill try to run that right now.. |
| 16:02 | <millisa> | they have a doc on this: https://www.linode.com/docs/uptime/monitoring/top-htop-iotop/ |
| 16:03 | <GJZwart> | great, Ill give it a go right away... |
| 16:03 | <millisa> | It should give you a hint of how much cpu/memory you are using and what is using it |
| 16:05 | <GJZwart> | htop shows 100% |
| 16:05 | <GJZwart> | its mysql thats running high |
| 16:06 | <millisa> | so that's where you'd start looking. find out what mysql is doing. at a mysql prompt, something like 'show processlist' is probably a good start |
| 16:07 | <GJZwart> | thanks :) |
| 16:10 | <GJZwart> | the process list does not show much stuff.. three instances are logged in, thats my mac here at work, my mac at home, and localhost |
| 16:12 | <millisa> | are there lots of small queries happening that you just aren't catching when you look at the process list? Something like: show global status where variable_name='Queries'; that has a number going up quickly would tell you |
| 16:13 | <GJZwart> | there are between 50 and 100 queries a second... |
| 16:13 | <millisa> | sounds like it's busy doing stuff. where are those queries coming from? |
| 16:13 | <GJZwart> | I dont know if that is much for the nanode plan... |
| 16:14 | <millisa> | depends on what the queries are really |
| 16:14 | <GJZwart> | I have an app thats tracking a fleet of taxi cabs, there are 18 devices polling every 30 second, |
| 16:16 | <GJZwart> | so there is a discrepancy between the devices polling and the number of queries |
| 16:16 | <millisa> | I dont know your app; does 50 to 100 queries a second sound like what 18 devices polling every 30 seconds should be doing? |
| 16:17 | <millisa> | The thing doing the polling could be malfunctioning? |
| 16:17 | <millisa> | if you want to be disruptive, you could try stopping mysql to be sure the cpu load goes to zero. |
| 16:18 | <GJZwart> | that would be evil,lol, but I guess I have to give the back end some dummy data to present to the devices while they are polling.. |
| 16:18 | <millisa> | you could also turn on the query log and see what shows up, but that'd likely drive the load up higher. |
| 16:19 | <GJZwart> | yeah.. |
| 16:19 | <GJZwart> | maybe I should upgrade the plan as well.. is there a difference in computing power between the nanode plan and the 2GB plan? |
| 16:20 | <GJZwart> | or do I need to choose the 4GB plan before I will see any change in computing capacity? |
| 16:21 | <millisa> | each has more cores. |
| 16:22 | <millisa> | er, sorry, the 4gb has another core3. |
| 16:22 | <Peng> | If the host is highly loaded, the 2 GB plan has a larger minimum "fair share" than the 1 GB plan. |
| 16:22 | <GJZwart> | ok.. |
| 16:22 | <Peng> | But if your host is lightly loaded and you're using more CPU than that anyway... |
| 16:25 | <GJZwart> | I did a 5 minute check now to see how many queries there are, and I got 9.2 queries a second.. thats a lot better than 50-100 |
| 16:26 | <GJZwart> | Ill check a couple of times again, if thats the number of queries, I guess there is something else wrong.. |
| 16:27 | <GJZwart> | the plan should be able to fetch about 500 queries a minute... |
| 16:27 | <millisa> | if you use 'top' instead of 'htop' on the third line, way off to the right is a number next to 'st' - what's that show? |
| 16:28 | <GJZwart> | %Cpu(s): 99.3 us, 0.3 sy, 0.0 ni, 0.0 id, 0.0 wa, 0.0 hi, 0.0 si, 0.3 st |
| 16:28 | <millisa> | and mysql is still the top of the list? |
| 16:29 | <GJZwart> | 26585 mysql 20 0 754740 101932 5936 S 99.0 10.1 523:27.29 mysqld |
| 16:29 | <GJZwart> | is oscillating between 99 and 89% |
| 16:31 | <GJZwart> | everything looks ok when checking with iotop |
| 16:33 | -!- | eyepulp [~eyepulp@c-73-51-33-13.hsd1.il.comcast.net] has joined #linode |
| 16:33 | -!- | eyepulp is "eyepulp" on #linode |
| 16:39 | <GJZwart> | Im trying to reboot the node, maybe that helps |
| 16:40 | <GJZwart> | there are just between 9 and 12 queries every second, and thats not that bad |
| 16:41 | <millisa> | logging those queries and finding out why they are taking so much cpu is probably your next step. using 'explain' might help you spot if there are indexes or something that would help |
| 16:41 | -!- | eyepulp [~eyepulp@c-73-51-33-13.hsd1.il.comcast.net] has quit [Remote host closed the connection] |
| 16:41 | -!- | eyepulp [~eyepulp@2603:300a:18a5:c000:fdb7:409f:9c01:574c] has joined #linode |
| 16:41 | -!- | eyepulp is "eyepulp" on #linode |
| 16:48 | -!- | anomie [~anomie@00018802.user.oftc.net] has quit [Quit: Leaving] |
| 16:49 | -!- | internat [biteme2@220-245-202-69.tpgi.com.au] has joined #linode |
| 16:49 | -!- | internat is "Nathan" on #tardigans @#binfenv #linode |
| 17:19 | <GJZwart> | millisa: I think I have to clean up some queries, looks like thats the problem... Anyway, Im really thankful for your help! |
| 17:19 | <millisa> | Good luck |
| 17:23 | <GJZwart> | tnx! :) |
| 17:46 | -!- | darwin [d@melik.windwireless.net] has joined #linode |
| 17:46 | -!- | darwin is "Darwin of The Elves" on #linode #bitlbee |
| 17:49 | <linbot> | New news from status: Scheduled Backups Maintenance - EU-West (London) <https://status.linode.com/incidents/7npnknbgvqhr> |
| 17:53 | <GJZwart> | is there someone here with a bit of mysql knowledge? Im trying to optimize a query, and Im a bit stuck.. thought of putting it up on StackOverflow, but if there is someone that could help with a JOIN and a GROUP BY query, I would really appreciate it :) |
| 17:59 | <linbot> | New news from status: Scheduled Backups Maintenance - US-Southeast (Atlanta) <https://status.linode.com/incidents/6v5qwbfmmsn5> |
| 18:08 | -!- | redentor [~armando@2806:1000:8001:2b1b:cff2:bf45:422d:d729] has quit [] |
| 18:09 | <linbot> | New news from status: Linode Backups Maintenance - US-East (Newark) <https://status.linode.com/incidents/j8mvzzkgywr6> || Linode Backups Maintenance - EU-Central (Frankfurt) <https://status.linode.com/incidents/bcc0l6sq2vxg> || Linode Backups Maintenance - US-Central (Dallas) <https://status.linode.com/incidents/v82nxczmgkg6> |
| 18:10 | -!- | frail_ [frail_@2600:3c01:e001:3930::3] has joined #linode |
| 18:10 | -!- | frail_ is "frail_" on #linode |
| 18:13 | <@rgerke> | GJZwart: I'm not an expert in MySQL (and if someone else in here is, please feel free to chime in) but I have some resources that might be helpful if you haven't already found them. |
| 18:13 | <@rgerke> | http://www.mysqltutorial.org/mysql-group-by.aspx |
| 18:19 | <linbot> | New news from status: Linode Backups Maintenance - US-West (Fremont) <https://status.linode.com/incidents/shnvzm4m4080> |
| 18:37 | -!- | andyzwieg103 [~Thunderbi@66-168-56-133.static.mdsn.wi.charter.com] has joined #linode |
| 18:37 | -!- | andyzwieg103 is "azwieg103" on #linode |
| 18:39 | -!- | GJZwart [~oftc-webi@2001:4649:128::4c95:da7f:3df:5a7e] has quit [Remote host closed the connection] |
| 18:47 | -!- | thiras [~thiras@195.174.215.70] has quit [Ping timeout: 480 seconds] |
| 19:07 | -!- | eyepulp [~eyepulp@2603:300a:18a5:c000:fdb7:409f:9c01:574c] has quit [Remote host closed the connection] |
| 19:11 | -!- | andyzwieg103 [~Thunderbi@66-168-56-133.static.mdsn.wi.charter.com] has quit [Quit: andyzwieg103] |
| --- | Log | closed Fri Aug 23 00:00:05 2019 |