Tagged Questions
0
votes
0answers
49 views
InnoDB errors after having deleted “ibdata1”
By accident, I have deleted the ibdata1 file in the MySQL directory because MySQL wasn't functioning correctly.
After reading so many forums, I found a post that recommended deleting the 3 files ...
0
votes
0answers
7 views
ibdata deleted and innodb error [duplicate]
By accident I have deleted ibdata1 file in MySQL directory because the MySQL wasn't functioning correctly so after reading so many forums I found a post asking to delete the 3 files in MySQL directory ...
1
vote
1answer
84 views
For a InnoDB only DB, which of these elements can be removed?
So, I'm trying to set up a Drupal 7 my.conf file that's combining best practices from various performance blogs. I'm realizing though that some of them are older than others, and many aren't assuming ...
2
votes
1answer
77 views
Drupal 7 Uses InnoDB, so do I need other configs?
If I'm optimizing a database that will be delivering multiple Drupal 7 websites, all using InnoDB, do I need to worry about [myisamchk] & [isamchk] sections, or can I just worry about the stuff ...
3
votes
1answer
206 views
MySQL: Can't find .ibd files after turning on innodb_file_per_table
Question:
This a question about MySQL. Let me give the specifics of my setup:
Mac OSX 10.6.8
MySQL 5.5.28
Workbench 5.2.44 for all administration
InnoDB engine exclusively
In order to manage ...
3
votes
2answers
644 views
Is my.cnf for mysql 5.5 is suitable and well tuned for below hardware spec?
My Hardware Spec
Technology: Ivy Bridge
CPU: Intel Xeon E3 1245v2
Intel Smart Cache: 8MB
Cores / Threads: 4 / 8
Frequency: 3.4GHz+ / 3.8GHz Turbo Boost
RAM: 32 GB DDR3
Hard disk: 2x 2TB SATA3
Raid 1 ...
0
votes
0answers
30 views
MySQL: optimal configs / methods for ALTER of large MyISAM table to InnoDB (17gb+) [duplicate]
I have a large MySQL (5.1) MyISAM table (13gb table, 4GB indexes - 40mm+ records)
I'm going to be converting this table to InnoDB in a production environment.
The DB is on a cloud server with ...
1
vote
1answer
152 views
some InnoDB settings in My.cnf are messing up everything, why?
When I edit my.cnf in MySQL 5.0 in filemanager and add the following settings, I get logged out automatically from Kloxo and when I remove these line and restart server everything is ok then:
...
2
votes
3answers
1k views
innodb_buffer_pool_size not changed
I use MySQL 5.5.23-1~dotdeb.0 (Debian) and here is the relevant part of my.cnf
default-storage-engine = innodb
innodb_buffer_pool_size = 3G
innodb_log_file_size = 256M
innodb_thread_concurrency = 8
...
1
vote
1answer
783 views
How to update mysql my.cnf without getting error?
I updated the MySQL my.conf file and and restarted my server without a problem.
As soon as I tried to access a table I received the error
mysql #1033 - Incorrect information in file:
I reverted ...
5
votes
2answers
1k views
Insert-heavy InnoDB table won't use all my CPU
I have a packet log database, which is almost never queried. It just needs to be fast on inserts. I'm using InnoDB because I'd like to maintain ACID compliance, since even losing a single packet could ...
2
votes
2answers
2k views
How to optimize the my.cnf of a MySQL server that mixes InnoDB and MyISAM tablespaces?
I have a database that, because of some issues, I needed to convert some tables from MyISAM to InnoDB.
I basically did this:
set sql_log_bin = 0;
set sql_mode = 'STRICT_ALL_TABLES';
ALTER TABLE ...
1
vote
1answer
1k views
16 Cores 12 GB RAM server MySql Configuration - my.cnf
The server takes 20+ seconds (wait time/slow IO response time) to response to a HTTP request even with memcached and APC installed. I believe this has something to do with MYSQL since the site as lots ...
6
votes
2answers
7k views
MySQL 5.1 InnoDB Configuration / 24GB RAM - bi-xeon high load
i'm running a facebook app which currently has 300 - 600 concurrent users (and growing). To get the hardware ready for growing i changed my i7 / 12gb ram / 2x 80gb intel x25 ssd's (debian 5.0 / mysql ...
