I've been having a lot of trouble recently with my webserver. The loading speed of my webpage is extremely slow and when I check htop I notice the mysql process to use around 800-1000% of CPU.
Hi,
I have cPanel server with MySQL 5.5.27, with lot of users and databases.
I want to convert all tables in all databases from MyISAM type to InnoDB storage engine, how can I achive this using mysql client from shell with root privileges ?
Also, I have added to my /etc/my.cnf for future tables:
default-storage-engine=InnoDB
Thank you,
Kind regards
Can any configuration mistake lead to creating too many temp tables by mysql..mysql tuner shows
Current max_heap_table_size = 200 M
Current tmp_table_size = 200 M
Of 17158 temp tables, 30% were created on disk
table_open_cache = 125 tables
table_definition_cache = 256 tables
You have a total of 97 tables
You have 125 open tables.
Current table_cache hit rate is 3%
Earlier temp table was of
I have a table packages which holds a couple of thousands of rows, there's a mysterious problem with it, it's that I can see it exists from 'show tables' but I when I do 'select ... from packages', mysql says the table doesn't exist. What's wrong?
error msg：
Cannot find or open table market/ma_package from
the internal data dictionary of InnoDB though the .frm file for the
table exists.
Hi,
we need to use Fulltext Search in our application but we dont have the luxury of being able to do a code rewrite due to various constraints (time / licensing / etc).
MyISAM tables have FTS but we have over 100k+ and 1M+ rows in the main few tables - and they will soon be 500k+ and 5M+ respectively.
256GB RAM, 64 Core , AMD running Ubuntu 12.04 with Percona MySQL 5.5.28.
Below is the assertion failure.
We just had a second assertion failure (different "in file", position, etc) while running a large set of inserts.
After the first failure, MySQL restarted after a reboot only - after continuously looping on the same error after trying to recover.
I decided to do a mysqlcheck with -o for opt
256GB RAM, 64 Core , AMD running Ubuntu 12.04 with Percona MySQL 5.5.28.
Below is the assertion failure.
We just had a second assertion failure (different "in file", position, etc) while running a large set of inserts.
After the first failure, MySQL restarted after a reboot only - after continuously looping on the same error after trying to recover.
I decided to do a mysqlcheck with -o for opt
We are an email marketing company and recently switched our setup to MySQL.
CentOS 5.8
I ran a yum update and MySQL updated but now it won't start.
Email this page
