…_project’,'news’,'page’,’percona_faq’,'presentation’,'press_release’,'project’,'random_phrase’,'service’,'team_member’,'webform’) NOT NULL Here is how this table… ALTER TABLE it provides very helpful information for performing schema audit.
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
… microslow patch immediately a question arises how much logging impacts on performance. When we do performance audit often we log every query… of write operations and obviously performance suffers. Let’s investigate how much. I took DBT2, an OSDL’s implementation of TPC… striped disks). Software It was used MySQL 5.0.75-percona-b11 on CentOS release 4.7 MySQL setting There were…
Post: Write contentions on the query cache
September 5, 2012 By 5 Comments
While doing a performance audit for a customer a few weeks ago, I tried to … (about 160ms). Of course, I wanted to know more about how MySQL executes this query. So I used commands you’re… in the output of SHOW PROFILE? This is specific to Percona Server 5.5 and used only for debugging purposes to…
