pdo - Mysql often crashes -


my mysql server crashes, , need restart mysql using "service mysqld start" command. check mysql error log file.

130807 22:59:47 mysqld_safe number of processes running now: 0 130807 22:59:47 mysqld_safe mysqld restarted 130807 22:59:47 [note] plugin 'federated' disabled. 130807 22:59:47 innodb: innodb memory heap disabled 130807 22:59:47 innodb: mutexes , rw_locks use gcc atomic builtins 130807 22:59:47 innodb: compressed tables use zlib 1.2.5 130807 22:59:47 innodb: using linux native aio 130807 22:59:47 innodb: initializing buffer pool, size = 128.0m innodb: mmap(137363456 bytes) failed; errno 12 130807 22:59:47 innodb: completed initialization of buffer pool 130807 22:59:47 innodb: fatal error: cannot allocate memory buffer pool 130807 22:59:47 [error] plugin 'innodb' init function returned error. 130807 22:59:47 [error] plugin 'innodb' registration storage engine failed. 130807 22:59:47 [error] unknown/unsupported storage engine: innodb 130807 22:59:47 [error] aborting  130807 22:59:47 [note] /usr/libexec/mysqld: shutdown complete  130807 22:59:47 mysqld_safe mysqld pid file /var/run/mysqld/mysqld.pid ended

i have 10,000 users , have database have 10,000 tables. tables used recording user status. and, when create new user table, use following code pdo.

$statustable = "status_".$uid; $qstr = "create table if not exists `status`.`$statustable` (     `prim_id` int( 5 ) not null auto_increment primary key,     `message` varchar( 600 ) character set utf8 collate utf8_unicode_ci not null,     `created_time` timestamp not null default current_timestamp ) engine = innodb"; $db->query($qstr);

does code cause mysql crash? use ec2 instance 615mb ram. thanks!!

aside bad database design, question/problem seems have been posted , answered before.


Comments

Post a Comment

Popular posts from this blog

matlab - Deleting rows with specific rules -

i got 20*3 cell array , need delete rows contains "137", "2" , "n:t" origin data: 't' '' '' 'np(*)' '' '' [ 137] '' '' [ 2] '' '' 'are' 'and' 'np(fcc_a1#1)' '' '' '1:t' [ 1200] [0.7052] '' [1.2051e+03] [0.7076] '' 'are' 'and' 'np(fcc_a1#3)' '' '' '2:t' [ 1200] [0.0673] '' [1.2051e+03] [0.0671] '' 'are' 'and' 'np(m23c6)' '' '' '3:t' [ 1200] [0.227...
Read more

php - MySQLi multi_query results for later use -

i using mysqli multi_query work several select statemets @ time. know how handle results, able use them later in code. example: <?php //connection stuff $query = "select name, surname database1;"; $query.= "select car, year, type database2 carid='1';"; $query.= "select product, price database3;"; if ($mysqli->multi_query($query)) { if($result = $mysqli->store_result()) { while($row = $result->fetch_row()) { --> here? } } } ?> <html> <div id='persona'> <?php foreach() { --> print name + surname } ?> </div> <div id='cars'> <?php foreach() { --> print car + year + type } ?> </div> <div id='product'> <?php foreach() { --> print product + price } ?> </div> </html> one more thing, prepared statements not possible when using multiple_query, right? there no benefit in putting unrelated queries in 1 multi ...
Read more