Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [myisam]

69 questions
1
vote
1 answer

How to use most of memory available on MySQL

I've got a MySQL server which has both InnoDB and MyISAM tables. InnoDB tablespace is quite small under 4 GB. MyISAM is big ~250 GB in total of which 50 GB is for indexes. Our server has 32 GB of RAM but it usually uses only ~8GB. Our…
Zilvinas
  • 383
  • 1
  • 4
  • 8
1
vote
2 answers

Will deleting old MySQL data improve performance?

Would deleting old data from my tables improve MySQL query performance? When my queries use indexes? When my queries don't use indexes? When I use InnoDB? When I use MyISAM?
swxxii
  • 111
  • 3
0
votes
1 answer

MariaDB (MySQL) 'table marked as crashed' recurring

I have a production environment where about once a week I'm finding the database needs to be repaired and restarted. The MariaDB database contains some InnoDB and some MyISAM tables (the mixture being mainly for legacy reasons, rather than something…
Ade
  • 699
  • 3
  • 10
  • 21
0
votes
0 answers

Website down with 3,000 concurrent user 4Gb Memory Dedicated Server (myIsam - MySQL)

Our site has 3,000+ concurrent users when we open our registration on our website. The site was too slow and get the server down sometime, even sub accounts websites are down. Free memory was 400MB. We upgraded our server to 8Gb for us to have a…
c.k
  • 101
  • 1
0
votes
0 answers

Occasional slow database queries caused by InnoDB

Update 2017-11-26 The problem seems to be related to InnoDB. The CI as well as the Wordpress installations are using InnoDB Engines while the rest is working with MyISAM. After I converted all MODx Databases to InnoDB they are having the same…
travisbotello
  • 23
  • 1
  • 7
0
votes
2 answers

mysqldump, myisam, and read local

When mysqldump is run with --lock-tables against a database using MyISAM tables, the documentation states that each table is locked with READ LOCAL. As I understand it, READ LOCAL allows for concurrent inserts from other sessions. I have a few…
jr0d
  • 153
  • 1
  • 6
0
votes
1 answer

MySQL behaviour and disk space handling after deletions and insertions with MyISAM

I have a question about the way MySQL with MyISAM engine handles the free/empty space after deletions and how it behaves when new records are inserted. For example, think about a new and empty DB (let's assume is 10 kb, just for example). After…
Riccardo M.
  • 150
  • 1
  • 9
0
votes
0 answers

Mysql table keeps crashing. How to debug the cause and prevent it?

My wordpress wp_users table keeps crashing and when I get up on the morning is : wp_users' is marked as crashed and last (automatic?) repair failed So all my users can't access the site. If I do a manuall repair it works but then after some time it…
chifliiiii
  • 121
  • 4
0
votes
1 answer

MySQL INSERTs on a database table block SELECTS in another database and in another table

I am using MySQL 5.1 on a Windows Server 2008 R2 Machine with 8GB RAM. I am updating 2 databases weekly. Both databases consist of MyISAM tables, and I run a script which performs the necessary INSERTs (No UPDATEs/DELETEs) into some tables (The…
user3480610
  • 11
  • 3
0
votes
1 answer

What do "key buffer size" and "total MyISAM indexes" unit sizes mean?

I ran MySQLTuner on my database to check if things are working correctly and optimally, but I was confused as to the units used for these two values. Here is what the output looks like for performance metrics -------- Performance Metrics…
Joe Lloyd
  • 103
  • 1
  • 5
0
votes
2 answers

MyISAM Throughput spike at 12000 record insert

I am testing database performance with bulk record inserts. Both systems are identical apart from storage engine **Database 1000 4000 12000** MySQL_InnoDB 60.95330976 218.2572161 262.1174723 MySQL_MyISAM 88.55827134…
johnnydrama
  • 3
  • 2
0
votes
1 answer

MySQL MyISAM corrupt table, how to restore?

I have a MySQL MyISAM table that's corrupt. It first showed up in my mysql log as: [ERROR] /usr/sbin/mysqld: Table './mydb/mytable' is marked as crashed and last (automatic?) repair failed I then ran CHECK TABLE on it, and after churning away for…
curtisdf
  • 251
  • 1
  • 3
  • 13
0
votes
1 answer

Large InnoDB data size even though entire database is MyISAM?

I'm running mysqltuner to tune up my database and I'm running into a very strange occurrence. Even though the entire database is MyISAM (all tables) it says the following: [!!] InnoDB data size / buffer pool: 403.1M/128.0M The default storage…
robert
  • 103
  • 1
0
votes
2 answers

mysql 5.5 myisam db tunning

I'm using mysql 5.5 with myisam db. Currently, sometimes the cpu usage of mysql will reach 200% CPU resource. And there are lots of queries 'waiting for table locking' in mysql. And at this time, the cpu usage of php-fpm will getting higher and…
Meteor
  • 151
  • 1
  • 6
0
votes
1 answer

cpanel account transfers failing: ERROR: Failed to dump one or more databases

Getting this error when transferring multiple accounts via whm transfer utility: ERROR: Failed to dump one or more databases I was told this by a cpanel tech Here is the specific error I'm seeing on some of the accounts: warn [pkgacct] eli_test:…
user148117
1 2 3
4
5