115 reputation
7
bio website
location
age
visits member for 4 years
seen Dec 24 '13 at 22:01

Nov
10
awarded  Popular Question
Dec
24
accepted Nginx not passing uri to php5-fpm, instead serving as text file
Dec
24
comment Nginx not passing uri to php5-fpm, instead serving as text file
I guess I was wrong, I thought that it'd do the rewrite as soon as it encountered the whole $uri.php. I guess I was wrong thanks for the help. Marking this one as correct then.
Dec
24
asked Nginx not passing uri to php5-fpm, instead serving as text file
Mar
5
awarded  Supporter
Feb
19
awarded  Tumbleweed
Feb
15
accepted mysql INNODB inserts very slow
Apr
23
awarded  Organizer
Mar
20
awarded  Scholar
Jan
1
comment mysql INNODB inserts very slow
even after doing that, apparently the one that had the biggest problem was the one where i update the number of assets. It finds the two rows via the index on it's category. Then does an amount=amount+1. It is taking ~0.3 seconds it seems. And it has zero foreign keys and only two indexes, one on the id and one on the category. The rest are uber-fast now. That's just the slowest one it seems.
Dec
26
awarded  Editor
Dec
26
revised mysql INNODB inserts very slow
added in more information.
Dec
26
comment mysql INNODB inserts very slow
the dump says the same thing, should i just well completely destroy MySQL and wipe the install, and then go get the latest mysql from the mysql site? Also i do have quite a few foreign keys in other tables. Should i remove all of their things with itself? Since i always saw foreign keys as the best way to do joins on tables. The items have something like 10 tables that use its id for the various 'little' types that go along with it. Should i change them to not do on update cascade, on delete cascade? Since i always saw that as the best way to do it. if it's the problem then i'll change it up.
Dec
25
comment mysql INNODB inserts very slow
during the inserts? or just when it's on its own thing? Plus, the 'server' that we're talking about is my desktop. Since this is just used for 'local testing'. As i work on it. And its performance when i do the inserts is when i'm doing nothing but working with it.
Dec
25
awarded  Student
Dec
25
asked mysql INNODB inserts very slow