• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
lots of traffic mysql side

#1
Hello
I am not a programmer by any means but right now I am involved in the stress load of a website and I see thousands of the following two statements coming in
Query SET NAMES utf8
Init DB testDB
by that I mean, 40k /minute.

I suspect this might be causing issues on mysql but the programming team tells me this is normal and set in the core files of codeigniter so there is nothing they can do
I see it as a waste of cpu cycles to send 40k /minute the same thing (its always going to be the same stuff)
any ideas ? (and thank you all for reading )
Reply

#2
Hi, SET NAMES utf8 are always initialized on runtime to make sure your application have the correct encoding. Or you won't be able to save and retrieve your information correctly, your symbols may end up as ANSI otherwise.

Technically this can be "fixed" if you change your MySQL server settings to default into utf8 and your PHP client to be utf8 as well. Then you could hack it away from CodeIgniter, you can't turn it off.

I guess you are running a minimum of 40k visits a minute in your AB test? As you will get a minimum one SET NAMES for every visit on your website. I hope you are using a cache engine (memory and html) in case you want to handle that amount of traffic. Also, please remove the debug mode when going offline. Logging slow queries etc in MySQL will have an negative impact on your server.
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.