Browsing articles tagged with "mysql - 3/186 - Admins Goodies"
Nov 20, 2012
tom

MySQL master-master replication between database running on 3 different server

I am trying to implement a master-master replication between 3 MySQL Databases running on 3 different servers. I implemented master-master replication for 2 servers, but can’t figure out how can I implement if for 3 different MySQL Servers. Does anyone know how to accomplish this? Asked by Mahendra You have to set it up as a ring — A is the master for B, B is the master for C, and C is the master […]

Continue Reading »
Nov 17, 2012
tom

MySQL – disk overhead needed?

I have an EXT3 partition that holds only MySQL dbs. Of 2Tb I’m down to about 90Gb remaining. This should be enough to last me until the new budget starts (and I can get some more storage) but I’m wondering whether the lack of space is causing any problems for MySQL. Asked by ethrbunny In some cases mysql can create on-disk temporary tables to perform huge complex joins. Sure you need enough free space on […]

Continue Reading »
Nov 14, 2012
tom

MySQL InnoDB Data/Memory Usage

I am running a fast growing NDB cluster and I have limited (8GB) of physical memory on each of the two data nodes. I am worried that I will be running out of Data Memory so I started removing old data. However, the deletion doesn’t show any significant reduction in the usage stats. Any ideas/explanation why? Here is the stats before: ndb_mgm> all report mem Node 11: Data usage is 44%(85073 32K pages of total […]

Continue Reading »
Nov 12, 2012
tom

MySQL lowering wait_timeout value to lower number of open connections

I run a rather busy site, and during peek hours I see over 10.000 open connections to my database server on my webserver when a run a netstat command. 99% of the connections are in the TIME_WAIT state. I learned about this mysql variable: wait_timeout http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_wait_timeout today. Mine is still set at the default 28.800 seconds. Is lowering this value safe? Non of my queries usually takes over a second. So it seems silly to […]

Continue Reading »
Nov 11, 2012
tom

Unable to edit/delete/move /etc/my.cnf – Permission denied

I am trying to edit /etc/my.cnf as root user via ssh and I get following error while trying to save it I ma making changes to my.cnf as I want to tweak some values in my.cnf to meet Magento requirement like changing key_buffer_size= to higher value (128M). I assigned the value 128M to key_buffer_size= and tried to save it and then got an error. “Error writing /etc/my.cnf: Permission denied” I cant even restart MySQL successfully. […]

Continue Reading »
Nov 9, 2012
tom

Django – Moving database from development to production servers

I am working on a Django project with a MySQL backend. I’m curious about the best way to update a production server’s database to reflect the changes made on the development server’s database? When I develop now, I make some changes to a models.py file, then to a schemamigration using South. Sometimes I do several migrations across several apps within the main project folder before it’s ready for the production database. This means that there […]

Continue Reading »
Nov 7, 2012
tom

MySQL: Load data infile and ignore tab in file

MySQL command I have so far: load data infile ‘data.txt’ into table foo (column_foobar); data.txt: bar1 bar2 bar3 Note the tab at beginning of each line. How can I ignore the tab with MySQL so that bar1, bar2, bar3 gets loaded in column_foobar? Asked by Stephan Kristyn You may be able to use the LINES STARTING BY clause load data infile ‘data.txt’ into table foo LINES STARTING BY ‘\t’ (foobar); which will do what you […]

Continue Reading »
Nov 6, 2012
tom

Confirm that mysqli extension is not installed

Recently I discovered that mysqli extension is not installed in my server Centos version 2.6. I confirm it because I change the driver of db connection from mysqli to mysql and now works fine. So, is there another way/log to determinate this problem? because the apache error_log does not say anything about it. This really is not a problem, but it could be more complex in future. Why? because using the mysqli driver, the website […]

Continue Reading »
Nov 6, 2012
tom

MySQL files on Lustre?

Our MySQL installation stores several Tb of data that doesn’t get accessed too often. Over the next six months we’re going to be moving to a Lustre based system for much of our data storage and Im wondering how MySQL would behave if it were storing it’s innodb folders there. I can imagine creating a Lustre client on a VM and NFS mounting the folders on the MySQL server but that seems like an extra […]

Continue Reading »
Nov 1, 2012
tom

MySQL Dump Viewer

I’m a linux user, however, I’m provided with a Windows laptop in the office. I could fire up a small web server with PHPmyadmin or even upload to a remote system and import into a database, however, for what I’m doing, I’d like to know if there is anything easier? What I have is a MySQL Dump file of a database. I need to know if there is anything out there that can read in […]

Continue Reading »
Pages:«1234567...186»