…Since WordPress uses MySQL, almost every page load results in various MySQL queries for logins, post content, categories and so on. It… within the MySQL server. Basically, all you need to to is to activate it in the my.cnf (or my.ini) MySQL configuration file with setting… cache in MB, for example 20M. To change the MySQL configuration file, you’ll probably need root access which won’t be…
Comment: What to tune in MySQL Server after installation
July 1, 2009 By 118 Comments
These are mysql configuration and it is found in my.ini or my.cnf which is the base of mysql configuration. in linux you can view this file in this location /etc/my.cnf
Comment: MySQL Query Cache
January 17, 2010 By 70 Comments
As a non MYSQL guy, I am pretty lost after reading this, but because I am running my own server for Wordpress I need to optimize my speed settings. Is it possible for you to give me the ini file settings for wordpress for my situation? Thanks
Comment: Percona Server 5.1.47-rel11.0
June 25, 2010 By 13 Comments
…=-all-static –with-unix-socket-path=/opt/xtradb/tmp/mysql.sock –with-plugins=partition,archive,blackhole,csv,federated,heap…-dir=bundled –with-ssl my.ini add options default-storage-engine=InnoDB innodb_file_per_table=1 innodb_file_format=barracuda innodb_strict…
Comment: Percona Server 5.1.47-rel11.0
June 24, 2010 By 13 Comments
…=-all-static –with-unix-socket-path=/opt/xtradb/tmp/mysql.sock –with-plugins=partition,archive,blackhole,csv,federated,heap…-dir=bundled –with-ssl my.ini add options default-storage-engine=InnoDB innodb_file_per_table=1 innodb_file_format=barracuda innodb_strict…
Comment: Choosing innodb_buffer_pool_size
September 24, 2010 By 39 Comments
… and mysql with Innodb tables. 100mb of data is available. i have set normal configuration in ini with…unit slave_net_timeout innodb_data_file_path ibdata1:10M:autoextend innodb_file_io_threads 4 thread_…suggest me to adjust the configuration to keep my process time same as in paradox? Thanks…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 13, 2011 By 38 Comments
…options untouched (like the standard 1800-line php.ini) and have small files containing only your differences. Debian’s …packages they list are for MySQL 3.23!! The RHEL 6 marketing blurb mentions MySQL 5.1.47, but … package info; all par for the course in my experience. RH’s site threw a “redhat.com …
Comment: How much overhead is caused by on disk temporary tables
September 11, 2008 By 26 Comments
In my webpage, I want to get a output in a XSL file. The data are retrieved from Mysql db. Retrieving the bulk records in a single file. When I access that download file page… remote, I couldn’t get the file also my data are crashed. What is the problem? PHP.ini or DB? Plz tell me…
