Linked Questions

1 vote
1 answer
2k views

What are some good methods of structuring a MySQL audit trail to be both immutable, and perform well for usage?

In one application, we have an audit table that uses the ArchiveEngine in conjunction with a few triggers to capture 100% of the changes that occur. The upside to this is that 20+ million rows ...
Bryan Agee's user avatar
1 vote
1 answer
566 views

For 768M RAM server is 617M allocation in my.cnf good or bad?

I have a write-intensive web app, and I bought a VDS with 768M RAM Is this my.cnf good for my purposes? I specified bulk_insert_buffer_size to 126M and some other parameters as below: [mysqld] ...
Alireza's user avatar
  • 3,646
1 vote
2 answers
2k views

Changed MyISAM to InnoDB, huge performance loss [closed]

So I'm testing on our dev server to change MyISAM to InnoDB and am having a huge performance loss. Here is my.cnf: innodb_file_per_table=1 innodb_flush_method=O_DIRECT innodb_buffer_pool_instance=2 ...
Marc Alexander's user avatar
1 vote
1 answer
990 views

MySQL: To use MYISAM or INNODB engine? (plot twist enclosed)

We use INNODB for all of our tables, but I have one special table, a 100+ GB reference table (only read-queries against it). We are loading changes to this table in a nightly batch job using LOAD ...
David Parks's user avatar
1 vote
1 answer
719 views

Does MySQL's MyISAM use cache before insert?

I want to test two different disks, one of them is HDD and another is SSD. I use exactly the same information and app for both servers. They are exactly the same, just one of them is SSD and another ...
Ata's user avatar
  • 141
2 votes
1 answer
1k views

Doubts about Converting MyISAM to InnoDB (master/slave and more)

I want to convert my MySQL DB (46 Tables, 2.1 GB) from MyISAM to InnoDB. I have a couple of questions about this process. Since I have a Master/Slave structure, do I need to manage this and change ...
jjadams's user avatar
  • 21
3 votes
1 answer
1k views

InnoDB has a transaction running, but "SHOW PROCESSLIST;" shows nothing

I have a replicated database setup, mostly Innodb databases/tables. The query that I believe caused the issue ran in about 20 minutes on the master database. This is where it gets weird. Show ...
Paul's user avatar
  • 31
0 votes
1 answer
1k views

WordPress MySQL writes during "Flush Tables With Read Lock" are rejected instead of being queued

I'm running into an odd issue when setting MySQL into a brief read-only mode for backup. Reads continue fine during that "read only" minute, but writes are just rejected instead of being ...
Dan's user avatar
  • 1
5 votes
2 answers
155 views

Optimizing a four-year-old MySQL database

I developed an application with MySQL 5.1 back-end four years ago. After that, I only gave remote support a couple of times, but that too for application crashes, and not for database. The database is ...
RPK's user avatar
  • 1,425
1 vote
2 answers
794 views

Why does MySQL + Windows Server = crashed tables periodically?

Windows Server 2008 R2 x64 MySQL Server 5.6.14 x64 Is anyone else having an issue in where some tables are marked as crashed on a Microsoft Windows server? We have a couple of Windows servers (not by ...
Van's user avatar
  • 328
0 votes
1 answer
719 views

Complex query performance in MySQL InnoDB versus MyISAM

I am running on MariaDB 10.0.15 on a 4GB RAM cloud server with Local SSD disk for database. My model: users <n---n> right_holders <n---n> tracks ---n> raw_detections I have this ...
Daniel Cukier's user avatar
1 vote
1 answer
849 views

How do i increase the total MyISAM indexes?

I have just made a check for my server with mysqltuner. -------- Storage Engine Statistics ------------------------------------------- [--] Status: +Archive -BDB +Federated +InnoDB -ISAM -NDBCluster ...
Toi Lee's user avatar
  • 35
4 votes
1 answer
239 views

Strictly only RAM matters?

I have to work on a project which would have a extra large table with billions of records but only two fields one is id and another is text. And id would be set to BIGINT and PK then if 8+2 (extra 2 ...
Gary Lindahl 's user avatar
2 votes
2 answers
370 views

Innodb using key cache?

As Innodb is my default engine, all my tables are innodb. But while monitoring with the help of a tool, I found a constant spike in key_write_requests and key_read_requests. These two variables are ...
Aravind's user avatar
  • 45
1 vote
1 answer
594 views

Is it normal that I have to FLUSH QUERY CACHE once every 6 hours to maintain fast queries?

I am running MySQL 5.5.37. I have a cronjob set to run every 6 hours to flush the query cache. I realized that if I don't do that, then the cache becomes fragmented and average query response time ...
brant's user avatar
  • 113

15 30 50 per page