Ditto: Now everything is clear
Semonick: Dovid: you can, the link I provided shows how to set the tmpdir
Ammon: Blade: I didnt see. thanks
Brittman: Dovid: beware, if your ssd is mounted directly at /var/lib/mysql you might not want to set tmpdir to a subdir of the datadir so someone doesnt “drop database tmp”
Leske: When does it use the /tmp/ dir?
Brittman: Dovid: show engine innodb statusG and couple tiny files created during start up
Brittman: Dovid: but mostly during:
Yazzie: Dovid: See http://dev.mysql.com/doc/refman/5.6/en/internal-temporary-tables.html
Twogood: Brittman: and during the later of a table?
Brittman: Dovid: yes if using “online ddl”
Hudson: BlaDe: how much data at the moment not much which uses a db forum db is only 90MB, we want to use a cms soon . at leat 2k articles and +/- 100K img wordpress will create for each img a post
Rousselle: _Zodiac: then imo just set it to 1gb and forget about it for now
Peroni: _Zodiac: no point having a 4gb buffer pool for 90mb
Deyarmin: Are those write sequential or random read/writes?
Berndt: BlaDe: so following settings should not be an issue http://pastie.org/private/mgix0nlnfyljdgnmkq7gg
Button: Brittman: Strange. When I create new tables I see them in datadir with a # in front of the file name
Daven: BlaDe: reason is, dev db is showing this http://picpaste.com/latin1-to-utf8mb4-rldPOO1K.png with main settings.and thats crap imho
Brittman: Dovid: are you partitioning them?, or using create table as?
Griesinger: _Zodiac: i’d recommend running http://mysqltuner.com/ when you run the settings and iterate as needed
Brantley: During the alter the new file is #234234 something like that
Brittman: You said during create
Panela: BlaDe: wow thnx for that link
Brittman: Dovid: are you adding a non-unique secondary index in this alter, or something else?
Yasui: BlaDe: so I ´only´ need to put settings as show in the pasty to my.cnf .save it and service mysql restart ?
Jeanneret: Http://pastebin.com/UG8AwEfR — does anyone grok this?
Hoffmeyer: It looks like the InnoDB plugin failed and the whole server barfed.
Cowels: Possibly ran out of memory?
Sellards: OS error code 12: Cannot allocate memory
Lupton: Yes, not enough memory
Brittman: Volund: did you check dmesg for OOM
Brittman: Volund: a guess is some web service like mod_php used a bunch of memory, mysqld was killed by OOM and then unable to start because that other thing still had all of the memory
Brittman: Volund: the kernel kills mysqld because it is the single biggest consumer, if if something else is a ton of smaller memory users
Anderlik: I don’t know what dmesg is. hold on though I’m putting webmin on here so I can more easily see what’s going on
Laiche: This VPS has 500mb of RAM. is that enough to run a webserver and mysql?
Keiter: Volund: a HTTP server needs 50-60MB at most.
Griem: I wonder what happened to the RAM then that made it overload
Keiter: Volund: the problem is the dynamic language, like php.
Choe: Mediawiki + some badly coded crud
Keiter: Volund: you should use a small php-fpm pool, then.
Keiter: Volund: limit it to 2 or 3 processes, so that leaves 250MB or so for mysqld
Flaming: No idea what that means but I’ll look it up. :
Heinzen: This VPS is using all default settings for pretty much everything if that tells you anything.
Keiter: Volund: that’s terrible.
Keiter: Volund: don’t use default values!