# General query log performance

**URL:** <https://forums.percona.com/t/general-query-log-performance/64>\
**Category:** Other MySQL® Questions\
**Created:** [August 16, 2006, 8:16am UTC](https://forums.percona.com/t/general-query-log-performance/64 "2006-08-16T08:16:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![radek](https://avatars.discourse-cdn.com/v4/letter/r/e19adc/32.png) [@radek](https://forums.percona.com/u/radek)\
**Post date:** [August 16, 2006, 8:16am UTC](https://forums.percona.com/t/general-query-log-performance/64/1 "2006-08-16T08:16:13Z")

</div>

Hi

I’m wondering how big impact on performance would have turning on the general query log. I read in manual it should be turned off in production environment to increase the performance but I didn’t find any information about performance gain (how much cpu/disk usage it would take). Is it like 1% performance lost or could it be bigger? Basically I just want to turn it on for a week to analyze later that query log.

Thanks in advance  
Radek

---

<div class="post-metadata">

**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\
**Post date:** [August 16, 2006, 2:32pm UTC](https://forums.percona.com/t/general-query-log-performance/64/2 "2006-08-16T14:32:17Z")

</div>

Enabling general log may have different effect on server performance depending on your query complexity - if you run 10000 simple queries/sec log overhead will be much larger than if you run 5 complicated queries/sec

Generally I would not expect it to cause more than few percent overhead. I guess should be some 1% for queries of medium complexity up to 10% for very simple queries.

My main concern with full query logging is it is eating up space so quickly )

---

<div class="post-metadata">

**Author:** ![radek](https://avatars.discourse-cdn.com/v4/letter/r/e19adc/32.png) [@radek](https://forums.percona.com/u/radek)\
**Post date:** [August 17, 2006, 7:54am UTC](https://forums.percona.com/t/general-query-log-performance/64/3 "2006-08-17T07:54:22Z")

</div>

Cool, thanks again for your help! I hope that query log won’t eat my disk space in one week )

cheers  
Radek