…!!! version: MySQL Server 5.0 INI setting : [client] port=3306 [mysql] default-character-set=latin1 [mysqld] port=3306 log-bin=mysql-bin server-id=2… basedir=”C:/Program Files/MySQL/MySQL Server 5.0/” datadir=”D:/work/MySQL Datafiles/” default-character-set=latin1 default-storage-engine=INNODB sql…
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
… query takes most of the total response time of the server: that’s typical of a hot spot and this query… will take 6 to 8 bytes for a single-byte character set (5 to 7 bytes for the value plus 1 byte… value (again as long as you use a 1-byte character set for CHAR). Here CHARs will be more flexible and can…
Comment: 7 Reasons why MySQL Quality will never be the same
December 11, 2008 By 15 Comments
… features in MySQL 4.1 were Subselects, Prepared Statements and Character Sets. All they were not done by Monty and these were… bugs with repeated execution etc. Finally character sets required changes across all parts of the server and also are generally quite tricky in the cases when you mix collations and use different character sets in the…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…] default-character-set=latin1 [mysqld] port=3306 basedir=”C:/Program Files/MySQL/MySQL Server 5.0/” datadir=”C:/Program Files/MySQL/MySQL Server 5.0/Data/” default-character-set=latin1 default-storage-engine…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/mysql/data) or # ~/.my.cnf to set user-specific…_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…=/tmp/mysqld_mdmp.sock character-sets-dir=/home/mysqld/sys/5.5.8/share/mysql/charsets [mysqld] port=3323 server-id=1 socket…=/tmp/mysqld_mdmp.sock character-sets-dir=/home/mysqld/sys/5.5.8/share/mysql/charsets [mysqld] port=3323 server-id=2 socket…
Comment: What to tune in MySQL Server after installation
October 8, 2012 By 118 Comments
…-5 HW In this server is installing MySql 5.5.21 and the sorftware has the following settings: [mysqld] log-error=/var/log/mysqld.log init_connect=SET CHARACTER SET utf8 datadir=/data/mysql socket…_size = 12M read_buffer_size = 4M [Server] server-id = 1 log-bin=/data/mysql/drbd [Server] server-id = 1 log-bin=/data/mysql/drbd…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… do we typically use xtrbackup restores: Setting up new slaves When we lose an entire server due to hardware failure, corruption, etc… schemas: loop through each DB write out ALTER DATABASE DEFAULT CHARACTER SET
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… when I activate some others functionality of my application the server start to respond slowly and the first task which was… max_allowed_packet=64M default-collation=utf8_unicode_ci default-character-set=utf8 default-storage-engine=InnoDB bulk_insert_buffer_size=8M…/mysqld.log pid-file=/var/run/mysqld/mysqld.pid The server (on amazon) has 7Go memory: [root@dom*************** log]# free -m…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…. Note dates may not be in date_id order’; /*!40101 SET character_set_client = @saved_cs_client */; CREATE TABLE `dim_flight` ( `UniqueCarrier` char… a text file on shard1 called “/tmp/servers.txt” and run the following commands: $ cat servers.txt | grep “10.”| grep -v internal |tee hosts.internal [host list omitted] Now you need to set up the…
