Tagged Questions
-1
votes
1answer
28 views
InnoDB Failure of some kind [closed]
I have MySQL 5.5 installed. I tried to install Joolma but it failed. I went into their sql and replace EGNINE=InnoDB with MyISAM and the install worked.
InnoDB is listed under SHOW ENGINES;
Any idea ...
0
votes
1answer
51 views
Get mysql database from raw files
My root access linux server has crashed and I cannot SSH into it or interact with it. I can, however tell the online console to do a network boot to a "rescue system" which allows me to access the ...
0
votes
0answers
113 views
Mysql Innodb native AIO flag causes high apparent iowait on virtualised host
There is a mysql config setting for InnoDB
innodb_use_native_aio = 0
This is documented here:
http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_use_native_aio
It is ...
0
votes
0answers
35 views
Restoring .ibd file from a formatted ext3 partition
I'm trying to find an IBD file (InnoDB tablespace) signature for PhotoRec utility http://www.cgsecurity.org/wiki/Add_your_own_extension_to_PhotoRec ; ...
0
votes
1answer
774 views
MySQL server quit without updating PID file
I need help on how to start the mysql server.
The problem arise when the root directory was full.
To be able to login to directadmin and start mysql, I added a soft link of the /var/lib/mysql/ to ...
0
votes
0answers
73 views
Error connecting to DB [closed]
In regards to:
Remounting MySQL under a new mount point
Everything is running. MySQL started but for websites they can not connect to the mysql database at all.
Error log does not show much. Only:
...
3
votes
1answer
135 views
mysql 5.1 - innodb - query_cache_size - 9,418,108 queries have been removed from the query cache due to lack of memory
Currently running on a 16GB system - Ubuntu 64 bit.
INnodb Buffer Pool is set to 10GB.
tuning-primer shows the following:
QUERY CACHE
Query cache is enabled
Current query_cache_size = 512 M
Current ...
1
vote
3answers
77 views
Database select error
Database select error
its my problem and when I restart my mysql to fix this error this problem solve but after 30 minutes or after hours again this error happen again.
I put link here screenshot ...
2
votes
2answers
621 views
MySQL InnoDB ext3 block size
I'm looking for recommendations for ext3 filesystem block size for MySQL 5.6 using InnoDB.
Running a CentOS 5.4 VM in VMware ESXi 5, VMFS 5 datastore on NetApp FibreChannel LUNs (which have 4k chunk ...
1
vote
1answer
143 views
Monitoring MySQL Rollback Segments
I recently discovered the default open transaction ceiling of 1024 in MySQL. I have since increased the limit using innodb_extra_rsegments. However, I would like to keep my eye on this moving forward. ...
0
votes
2answers
1k views
Plesk: libmysqlclient_16 not defined in file libmysqlclient_r.so.16
I've found this error in my logs:
relocation error: /usr/lib64/libmyodbc5.so: symbol strmov, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference
...
2
votes
2answers
315 views
MySQL not using specified RAM anymore
A few days ago I got a new machine setup running CentOS 5.6 (64bit), with 12GB ddr3 ram, 4x SAS 15k rpm drives in RAID10. On this machine I'm running MySQL Server version: ...
1
vote
2answers
290 views
How to enable InnoDB storage engine for Mysql in Linux
When I run the query "Show Engines" on this particular Linux host, it shows that the InnoDB storage engine is Disabled. Other storage engines (like MyISAM) are showing enabled.
What steps would I ...
1
vote
4answers
1k views
Which operating systems are used by large social networking companies?
I often see that Apache is used as a web server and also ruby on rails, php and so on is used. So all in all the most large social network companies using unix operating systems.
Because I want to ...
