Meta tags:
description=Posts about Database written by txcom2003;

Headings (most frequently used words):

mysql, sasuke, kun, wordpress, query, metrics, codeigniter, tokumx, plastic, scm, database, config, archive, recent, posts, archives, categories,

Text of the page (most frequently used words):
this (15), the (12), cimongo (12), mysql (11), 2011 (10), 2012 (9), for (9), mongo (8), #wordpress (7), database (7), december (7), php (6), 2014 (6), 2015 (6), operation (6), here (6), library (6), october (5), january (5), march (5), september (5), can (5), from (5), codeigniter (5), tokumx (5), com (4), sasuke (4), kun (4), and (4), categories (4), november (4), 2008 (4), april (4), how (4), query (4), plastic (4), scm (4), public (4), function (4), load (4), testdata (4), array (4), result (4), install (4), you (4), linux (3), february (3), may (3), june (3), august (3), 2025 (3), metrics (3), restart (3), service (3), set (3), should (3), innodb_buffer_pool_size (3), server (3), that (3), etc (3), leave (3), comment (3), txcom2003 (3), select (3), row (3), echo (3), web (3), rows (3), get (2), design (2), site (2), log (2), sign (2), subscribed (2), subscribe (2), windows (2), version (2), control (2), support (2), programming (2), language (2), framework (2), code (2), 2007 (2), 2010 (2), july (2), 2013 (2), 2017 (2), are (2), max_allowed_packet (2), innodb_log_buffer_size (2), around (2), buffer (2), pool (2), size (2), innodb_log_file_size (2), innodb_additional_mem_pool_size (2), value (2), more (2), edit (2), file (2), ini (2), add (2), step (2), welcome (2), insert (2), mongo_data (2), update (2), where (2), delete (2), download (2), extension (2), application (2), time (2), archive (2), started, like, with, collapse, bar, manage, subscriptions, view, reader, report, content, privacy, already, have, account, now, create, free, website, blog, top, visual, story, telling, unity, uncategorized, stock, market, ruby, research, regular, expression, python, objective, nintendo, 3ds, music, mac, networking, life, japanese, iphone, game, facebook, developer, education, django, pattern, cooking, college, igniter, banking, 2020, 2024, 2026, archives, indikator, ekonomi, learning, learn, models, selection, coding, assistant, art, spending, money, recent, posts, search, inezha, bloglines, newsgator, yahoo, zhua, xia, xian, guo, youdao, google, feed, rss, original, source, http, www, plasticscm, infocenter, technical, articles, fine, tune, performance, aspx, once, these, settings, place, also, don, forget, 10mb, mandatory, correct, 10m, minimum, 8mb, 40m, 500m, 100m, half, memory, your, machine, most, important, note, due, limitation, maximum, 4gb, details, cnf, normally, located, program, files, lines, below, change, configuration, before, migrating, sql, config, defined, basepath, exit, direct, script, access, allowed, class, extends, ci_controller, mongo_insert_test, mongo_select_test, foreach, result_array, sprintf, mongo_update_test, mongo_delete_test, simple, example, use, perform, crud, httpd, pecl, make, connect, instance, need, centos, redhat, environment, run, command, information, about, read, documentation, github, lightweight, help, develop, drop, replacement, mongodb, transaction, count, created, tmp, disk, tables, full, join, scan, affected, sent, examined, lock, those, category, home, dream, high,

Text of the page (random words):
database sasuke kun wordpress sasuke kun wordpress dream high home welcome archive archive for the database category mysql s 9 query metrics september 28 2025 txcom2003 leave a comment those metrics are query time lock time rows examined rows sent rows affected select scan select full join created tmp disk tables query count categories mysql codeigniter tokumx february 4 2015 txcom2003 leave a comment codeigniter is a lightweight php framework that can help you to develop web application tokumx is a drop in replacement for mongodb that support transaction you can download codeigniter from here and tokumx from here for more information about how to install tokumx you can read tokumx documentation from github here to make web application can connect to mongo instance you need to install php extension for mongo to install in centos or redhat environment run command pecl install mongo and add to etc php ini extension mongo so restart web service service httpd restart download codeigniter mongo library from here here s simple code example how to use codeigniter mongo library to perform crud operation php if defined basepath exit no direct script access allowed class welcome extends ci_controller insert operation public function mongo_insert_test this load library cimongo cimongo for i 0 i 25 i this cimongo insert testdata array x i y 25 i select operation public function mongo_select_test this load library cimongo cimongo mongo_data this cimongo get testdata foreach mongo_data result_array as row echo sprintf x d y d br row x row y update operation public function mongo_update_test this load library cimongo cimongo result this cimongo where array x 24 set array x 25 update testdata echo result delete operation public function mongo_delete_test this load library cimongo cimongo result this cimongo where array x 25 delete testdata echo result categories database mongo php programming plastic scm mysql database config october 30 2014 txcom2003 leave a comment this is step by step to change mysql server configuration before migrating plastic scm database from ms sql server ce edit the my cnf file normally located in etc or etc mysql in linux or the c program files mysql my ini file in windows add or edit the lines below the innodb_buffer_pool_size should be around half of the memory of your server machine this is the most important value note that due to a limitation in mysql this value should be maximum 4gb more details here innodb_buffer_pool_size 2g innodb_additional_mem_pool_size should be a 5 of the innodb_buffer_pool_size innodb_additional_mem_pool_size 100m set innodb_log_file_size to 25 of buffer pool size innodb_log_file_size 500m innodb_log_buffer_size can be around 2 of the buffer pool size or at a minimum 8mb innodb_log_buffer_size 40m also don t forget to set the max_allowed_packet to 10mb this is mandatory for correct plastic scm operation max_allowed_packet 10m once these settings are in place restart the mysql service original source http www plasticscm com infocenter technical articles kb how to fine tune mysql performance for plastic scm aspx categories database version control rss feed google youdao xian guo zhua xia my yahoo newsgator bloglines inezha search for recent posts the art of spending money ai models selection for coding assistant mysql s 9 query metrics learning how to learn indikator ekonomi archives june 2026 september 2025 january 2025 august 2024 march 2020 september 2017 april 2017 december 2015 november 2015 march 2015 february 2015 january 2015 december 2014 october 2014 june 2014 may 2014 april 2014 december 2013 january 2013 december 2012 november 2012 october 2012 september 2012 august 2012 july 2012 may 2012 april 2012 march 2012 december 2011 november 2011 october 2011 september 2011 august 2011 july 2011 june 2011 may 2011 april 2011 march 2011 december 2010 january 2010 december 2008 march 2008 february 2008 january 2008 november 2007 october 2007 categories ai banking c c c code igniter college cooking database design pattern django education facebook developer framework game and cg iphone japanese language language life linux linux and networking mac os mongo music mysql nintendo 3ds objective c php programming python regular expression research ruby stock market support uncategorized unity version control visual story telling windows top create a free website or blog at wordpress com subscribe subscribed sasuke kun wordpress sign me up already have a wordpress com account log in now privacy sasuke kun wordpress subscribe subscribed sign up log in report this content view site in reader manage subscriptions collapse this bar design a site like this with wordpress com get started