Raised This Month: $51 Target: $400
 12% 

KnifeTop


Post New Thread Reply   
 
Thread Tools Display Modes
LordMarqus
Senior Member
Join Date: Sep 2009
Location: Poland
Old 12-12-2010 , 19:07   Re: KnifeTop
Reply With Quote #41

Sure, it's not limited, I didn't say that. I mean this:
Quote:
InnoDB stores data rows physically in primary key order while MyISAM typically stores them mostly in the order in which they are added. Storing the rows in primary key order corresponds to the MS SQL Server feature of Clustered index and the Oracle feature known as "index organized tables." When the primary key is selected to match the needs of common queries this can give a substantial performance benefit. For example, customer bank records might be grouped by customer in InnoDB but by transaction date with MyISAM, so InnoDB would likely require fewer disk seeks and less RAM to retrieve and cache a customer account history. On the other hand, inserting data in orders that differ substantially from primary key (PK) order presumably requires that InnoDB do a lot of reordering of data to get it into PK order. This places InnoDB at a slight disadvantage, in that it does not permit insertion order based table structuring.
We don't really need that and there are a lot of inserts. I think it decrease performance. Transactions are not used as well, all operations are made sequentially by the same user.
__________________
My public plugins: [CS:S/CS:GO] Last Man Standing
LordMarqus is offline
altex
Veteran Member
Join Date: May 2009
Location: Russia
Old 12-13-2010 , 03:14   Re: KnifeTop
Reply With Quote #42

I can not imagine css server that can show performance differences between sqlite, myisam and innodb I realy dont think it is a thing you should worry about. InnoDB is more powerfull engine, so i think it is better than myisam, that is why i choose it.
__________________
altex is offline
LordMarqus
Senior Member
Join Date: Sep 2009
Location: Poland
Old 12-13-2010 , 05:43   Re: KnifeTop
Reply With Quote #43

Okay, let it be like that .
__________________
My public plugins: [CS:S/CS:GO] Last Man Standing
LordMarqus is offline
LordMarqus
Senior Member
Join Date: Sep 2009
Location: Poland
Old 12-13-2010 , 10:28   Re: KnifeTop
Reply With Quote #44

I change to MyISAM. Even my hosting provider recommends that.
__________________
My public plugins: [CS:S/CS:GO] Last Man Standing
LordMarqus is offline
altex
Veteran Member
Join Date: May 2009
Location: Russia
Old 01-27-2011 , 04:51   Re: KnifeTop
Reply With Quote #45

Quote:
Originally Posted by LordMarqus View Post
Hey. Do you know what such error could mean?

Code:
L 12/12/2010 - 09:38:56: [knifetop.smx] Error saving player (The table 'knifetop' is full)
Table has about 28000 entries. This error was repeating very long. Is that MySQL server problem?

it's because of mysql server settings.
try to change engine type
__________________
altex is offline
kaskull
Member
Join Date: Nov 2010
Old 01-28-2011 , 03:29   Re: KnifeTop
Reply With Quote #46

How can I translate the menu?
kaskull is offline
Send a message via Skype™ to kaskull
pubhero
Veteran Member
Join Date: Aug 2012
Location: Central Europe
Old 01-17-2015 , 00:39   Re: KnifeTop
Reply With Quote #47

Hi.
I got many error messages / day from this plugin.
See:
Code:
L 01/17/2015 - 00:46:37: SourceMod error session started
L 01/17/2015 - 00:46:37: Info (map "de_dust2") (file "errors_20150117.log")
L 01/17/2015 - 00:46:37: [knifetop.smx] [KnifeTop] Error saving player (near "STEAM_0": syntax error)
How can i stopping this log spam?

Last edited by pubhero; 01-17-2015 at 00:40.
pubhero is offline
VJScope
Senior Member
Join Date: Jul 2012
Location: Finland
Old 02-11-2015 , 12:59   Re: KnifeTop
Reply With Quote #48

Quote:
Originally Posted by pubhero View Post
Hi.
I got many error messages / day from this plugin.
See:
Code:
L 01/17/2015 - 00:46:37: SourceMod error session started
L 01/17/2015 - 00:46:37: Info (map "de_dust2") (file "errors_20150117.log")
L 01/17/2015 - 00:46:37: [knifetop.smx] [KnifeTop] Error saving player (near "STEAM_0": syntax error)
How can i stopping this log spam?
I'm not sure, but it might be because in csgo the first number in your steam id must be 1. At least when adding admins to your server, you have to change their STEAM_0.... to STEAM_1....
__________________
Strange women lying in ponds distributing swords is no basis for a system of government. Supreme executive power derives from a mandate from the masses, not from some farcical aquatic ceremony.
VJScope is offline
pubhero
Veteran Member
Join Date: Aug 2012
Location: Central Europe
Old 02-17-2015 , 09:58   Re: KnifeTop
Reply With Quote #49

Thank you for your answer, but i running CS:S server. I got sometimes the first error message, but now i have a new player and got another one too. The second error message presented only with this player and only with this name.
Code:
L 02/17/2015 - 15:50:09: [knifetop.smx] [KnifeTop] SQL_CreatePlayerCallback failure: unrecognized token: "'''''''''''\\ terminator //'''''''', current_timestamp)"
Maybe the SQL database can't handle some of these characters?
The author or some other programmer can repair these errors? Thanks in advance.

Last edited by pubhero; 02-27-2015 at 23:28.
pubhero is offline
3axap
Member
Join Date: Dec 2012
Old 01-25-2018 , 08:19   Re: KnifeTop
Reply With Quote #50

Some one know this:
Quote:
Ÿаˆа Шƒс‚€ов
СУТУ›Я
This is russian letter in base. MySQL base in utf8_general_ci. Plugin write wrong charset. In game too.
Some one know how i fix it? Thank you.
Attached Images
File Type: jpg ????? ??????01.jpg (19.3 KB, 138 views)

Last edited by 3axap; 01-25-2018 at 08:19.
3axap is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 10:40.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode