| Neo4 | here may have to be solution https://www.digitalocean.com/community/questions/mysql-server-keeps-stopping-unexpectedly | 00:04 |
|---|---|---|
| Neo4 | this row innodb_buffer_pool_size = 20M | 00:05 |
| Neo4 | How I could be have to find this row in my file /etc/mysq/my.cnf didn't exided that row, I've putted it myself in the bottom. Couldn't be it right? where I could find my real that variable? | 00:08 |
| Neo4 | any suggestions? | 00:08 |
| Neo4 | that couldn't have helped again the same error 'couldn't connect to mysql server' https://kselax.ru/ | 00:20 |
| Neo4 | I don't know how to fix it | 00:20 |
| Neo4 | it is error what I have had http://pix.toile-libre.org/?img=1517098891.png | 00:22 |
| Neo4 | see it http://pix.toile-libre.org/?img=1517099113.png | 00:25 |
| Neo4 | why I have so little memory? | 00:25 |
| Neo4 | I have on this server many subdomains where I put sites for test, Could be this the reason so low memory? | 00:26 |
| Neo4 | I think apache always has equal memory or it depend on number of set up sites/ | 00:27 |
| Neo4 | the more sites the less memory? | 00:27 |
| Neo4 | it is crystal clear my problem is memory? What shall I do, I have got there a few sites. Does it mean I might have to remove a few sites? | 00:30 |
| teward | Neo4: I'd suggest reviewing what's running and identify what's using the most memory. Then address those processes accordingly | 00:33 |
| teward | because some processes use a lot of memory while others don't. | 00:33 |
| Neo4 | teward: who to do it? | 00:33 |
| teward | MySQL, PHP, and Apache2 are all resource hogs until you tune them | 00:33 |
| Neo4 | do you know command? | 00:33 |
| Neo4 | teward: do you see in pic there swap is zero? | 00:33 |
| teward | it's more than just one 'command'. | 00:33 |
| teward | Neo4: swap size isn't in our control | 00:34 |
| teward | that's a control of your system provdier/admin | 00:34 |
| Neo4 | teward: http://pix.toile-libre.org/?img=1517099113.png | 00:34 |
| teward | swap being 0 means nobody set a swapfile or a swap partition | 00:34 |
| teward | stop sending me links I already reviewed | 00:34 |
| teward | or i'll stop trying to be helpful and just walk away | 00:34 |
| Neo4 | ok | 00:34 |
| Neo4 | see if there many sites, do you think site can feed memory? | 00:35 |
| teward | MY suggestion is install `htop`, and look at that, ordering by memory usage. | 00:35 |
| teward | if the primary users are MySQL, APache2 and/or PHP, then you should start fine-tuning the configurations of those services to *not* use as much in terms of resources. | 00:35 |
| teward | but that can be difficult the more sites oyu run. | 00:35 |
| Neo4 | teward: I've installed there 7 wp sites, can this have taken all merry? | 00:36 |
| Neo4 | ok, I badly understand it | 00:37 |
| teward | yes, it could have. Assuming there's no caching in play, it could take up memory. Also assuming that your sites haven't been hijacked; if they ahve been and have malicious stuff running they could be consuming more memory. | 00:37 |
| Neo4 | oh I even didn't think about it and am going to create many many sites else :) | 00:37 |
| Neo4 | I've must removed 4 sites | 00:38 |
| Neo4 | teward: is this app https://hisham.hm/htop/ | 00:39 |
| teward | Neo4: sudo apt-get install htop | 00:39 |
| Neo4 | I'll try right now | 00:39 |
| teward | don't bother googling things | 00:39 |
| teward | just install stuff from the repos | 00:39 |
| Neo4 | see my computer is lubuntu? http://pix.toile-libre.org/?img=1517100055.png | 00:41 |
| Neo4 | and there error | 00:41 |
| Neo4 | teward: no all right now | 00:42 |
| teward | Neo4: is this a VPS or something hosted by someone else, or your physical system | 00:42 |
| teward | it LOOKS like it's a VPS because of the low amount of RAM | 00:42 |
| Neo4 | teward: my real vps | 00:43 |
| Neo4 | http://kselax.ru | 00:43 |
| Neo4 | http://pix.toile-libre.org/?img=1517100153.png | 00:43 |
| Neo4 | teward: see I've run http://pix.toile-libre.org/?img=1517100261.png | 00:44 |
| teward | your VPS is overtaxed. Swap not existing you need to take up with yoru VPS provider. | 00:45 |
| teward | and you should probably NOT be running Lubuntu on it, you should run the pure command line Ubuntu Server instead | 00:46 |
| teward | and learn how to SSH | 00:46 |
| Neo4 | teward: might be that 1ubuntu1 not lubuntu ) see this http://pix.toile-libre.org/?img=1517100372.png | 00:46 |
| Neo4 | apache has eaten all memory | 00:47 |
| Neo4 | how to create swap? | 00:47 |
| Neo4 | I might be have to create swap myself? | 00:47 |
| teward | Neo4: https://support.rackspace.com/how-to/create-a-linux-swap-file/ may be relevant, but not all VPSes let you enable swap, even with swap files. | 00:47 |
| teward | Neo4: if you're running lots of sites though you *need* to have a bigger server, and not consume all the memory. Or retune the system to properly use less memory, and if you're using Apache you have to really tune PHP, not Apache, for the lower-RAM server. | 00:49 |
| teward | otherwise it will eat your memory. | 00:49 |
| Neo4 | teward: ok, I didn't know it, I thought it must have done automatically | 00:51 |
| Neo4 | teward: see not swap has appeared http://pix.toile-libre.org/?img=1517101287.png | 01:01 |
| Neo4 | what shell I do next? | 01:02 |
| Neo4 | why there so many mysql row? | 01:02 |
| teward | Neo4: that's the number of 'threads' that mysql has. But I can't help you out much from here, as I said before, you have to tune MySQL and PHP, and that's tricky to do from here. | 01:02 |
| teward | since it requires a lot of work to properly tune it | 01:02 |
| teward | https://www.narga.net/optimizing-apachephpmysql-low-memory-server/ may help with that. | 01:03 |
| teward | but it is nontrivial and requires a lot of long-term work. | 01:03 |
| Neo4 | teward: ok, understood, thanks, I know php, use it in windows | 01:03 |
| Neo4 | there exists variable that change memory | 01:03 |
| Neo4 | I'd better removed a few sites | 01:04 |
| Neo4 | teward: thanks | 01:04 |
| LeMike_ | Hello. When I do "ps aux | grep ssh-agent | wc -l" I get 230 running agents. This does not seem right. Why so many and can I just kill them? (hint: there is continous integration running on the server and each may have opened one) | 01:05 |
| rypervenche | LeMike_: You just answered your own question. What you wrote in your "hint" is true. | 03:52 |
| === nchambers is now known as dtscode | ||
| === dtscode is now known as nchambers | ||
| tanuki | In 17.10, after installing I get a "^@" on the console every second or so. It doesn't happen in the installer or in recovery mode. | 05:48 |
| tanuki | It's acting like it's being typed so it's pretty much impossible to log in on the console. | 05:48 |
| tanuki | Correction: it does happen in recovery mode | 05:52 |
| tanuki | But it's ignored at the command line for some reason | 05:52 |
| tanuki | Doesnt happen in the installer shell though | 05:55 |
| tanuki | Installing 16.04 now to see if it does the same thing. | 06:25 |
| tanuki | 16.04 doesnt seem to do the same. | 06:31 |
| === tanuki_ is now known as tanuki | ||
| === Guest81887 is now known as devilz | ||
| saban | hey. i modified lines in rsyslog.conf to add some custom logs. what do i need to add that this logs will be relayed to my remote rsyslog server? https://pastebin.ubuntu.com/26479158/ | 19:12 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!
