Page 2 of 84 FirstFirst 12341252 ... LastLast
Results 11 to 20 of 838
  1. #11

    Re: BfBC2 Chat GUID and Stats Logger[1.0]

    Is there a reason it created Chatlog using MyIsam and Player GUID using InnoDB? That one had me stumped for a bit as I usually don't even install InnoDB on my MySql servers.

  2. #12

    Re: BfBC2 Chat GUID and Stats Logger[1.0]

    The reason is simple:

    1. InnoDB is the default DB-engine on windows systems(not really a reason)

    2. InnoDB handles Updates on tables better than MyISAM but MyISAM is much faster on inserts. The table tbl_playerGUID has much more Updates than inserts. The table tbl_chatlogs has only inserts and no updates.
    Also the caching System of InnoDB works very well so the Querys are fast too and i dont need fulltext search. in the stats table.

    But at the moment you can switch the InnoDB to MyISAM because i dont use InnoDB functions yet. But may will in future(foreign key constaints, transactions)
    in MySQL 5.5, InnoDB is the default storage engine


  3. #13
    Administrator
    Join Date
    Mar 2010
    Location
    Tasmania, Australia
    Posts
    3,491

    Re: BfBC2 Chat GUID and Stats Logger[1.0]

    MyIsam is actually the default used by MySQL, and the recommended choice..

  4. #14

    Re: BfBC2 Chat GUID and Stats Logger[1.0]

    Quote Originally Posted by Zaeed
    MyIsam is actually the default used by MySQL, and the recommended choice..
    this isnt right anymore InnoDB is gone to be the new default
    http://dev.mysql.com/tech-resources/art ... ql-55.html


  5. #15
    Administrator
    Join Date
    Mar 2010
    Location
    Tasmania, Australia
    Posts
    3,491

    Re: BfBC2 Chat GUID and Stats Logger[1.0]

    Quote Originally Posted by XpKiller
    Quote Originally Posted by Zaeed
    MyIsam is actually the default used by MySQL, and the recommended choice..
    this isnt right anymore InnoDB is gone to be the new default
    http://dev.mysql.com/tech-resources/art ... ql-55.html
    hmm I stand corrected..

  6. #16

    Re: BfBC2 Chat GUID and Stats Logger[1.0]

    Got it running.
    http://113.212.97.72/stats1/

    without the skills to do much with the webscript we may go take a look at Wolfcon though.

  7. #17

    Re: BfBC2 Chat GUID and Stats Logger[1.1]

    *bump*

    new Version
    now using Proconplugininterface3


  8. #18

    Re: BfBC2 Chat GUID and Stats Logger[1.1]

    Hi I have created the data base and added a user with all privilages and
    i have installed the plugin on my procon server i have updated the plugin with my host and database information i have also set Enable outgoing ODBC Connections,

    Also the ODBC 5.1 Driver dose that need to beinstalled to my MYSQL 5.1 database or to my Procon server ?
    this is all a bit new to me so please bare with me many thanks in advance.

  9. #19

    Re: BfBC2 Chat GUID and Stats Logger[1.1]

    Hi

    You need to install the ODBC Driver on your PRoCon Server only.

    If you have more questions feel free to ask.
    Xp


  10. #20
    Senior Member
    Join Date
    Apr 2010
    Location
    Sackville, NB Canada
    Posts
    144

    Re: BfBC2 Chat GUID and Stats Logger[1.1]

    Does your simple script keep the top players at the top or is it just placing them in the table as for when they join your server?

 

 

Similar Threads

  1. Replies: 283
    Last Post: 10-10-2014, 10:01
  2. Replies: 142
    Last Post: 09-02-2012, 08:54
  3. Replies: 94
    Last Post: 25-06-2011, 23:48
  4. Replies: 3
    Last Post: 07-12-2010, 01:24

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •