cluster

2008-07-17 Thread Krishna Chandra Prajapati
Hi all, Is there any way to know that mysql cluster setup is required there is a lot of aborted clients on my production server. Every day it is increasing 150 per day. -- Krishna Chandra Prajapati

Re: cluster

2008-07-17 Thread MarisRuskulis
What kind of querys there is, how many writes and reads? How complex is querys. Krishna Chandra Prajapati wrote: Hi all, Is there any way to know that mysql cluster setup is required there is a lot of aborted clients on my production server. Every day it is increasing 150 per day.

Re: Help requested to provide bug reports for 5.1

2008-07-17 Thread Susanne Ebrecht
Hi, Michael Widenius schrieb: Note that you should also do this for bugs that you know of in MySQL 5.0 that are still open for MySQL 5.1 (or any bugs that are labelled to be fixed in a future release). Bugs that are in earlier version are also very likely to also be in 5.1 if the bugs database

mysql on 32 bit pae linux with 16 GB of memory

2008-07-17 Thread Dominik Klein
Hi I have a new machine to put mysql onto. It has 16 GB of RAM. I don't have exactly the best experience with 64bit operating system, so I'd personally like to stick to 32 bit. Does it make sense to install it with a 32 bit PAE kernel? Will mysql be able to use the full amount of memory?

Re: mysql on 32 bit pae linux with 16 GB of memory

2008-07-17 Thread Ranjeet Walunj
Dominik Klein wrote: I have a new machine to put mysql onto. It has 16 GB of RAM. I don't have exactly the best experience with 64bit operating system, so I'd personally like to stick to 32 bit. Does it make sense to install it with a 32 bit PAE kernel? Will mysql be able to use the full

tee command eating filesystem (4.0.18 64-bit)

2008-07-17 Thread Sid Lane
hey, I just noticed a bizzare behavior on a box we recently built to upgrade a legacy 32-bit 3.23 DB to 64-bit 4.0(.18) - explain this: mysql@hostname:~ df -k /tmp Filesystem 1K-blocks Used Available Use% Mounted on /dev/sda5 521748 42624452620 9% /tmp

Calendar creation

2008-07-17 Thread Weston, Craig (OFT)
Hi there, Is there any simple way to create a calendar table? For example I want to create a reference calendar containing all the dates of several years so I can accurately represent even days where I have no data in my data set. Any ideas? Thanks, Craig

Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread Jesse
I have a Ubuntu 8.04 Server VM set up that I'm using for replication for a WS2003 machine (which is the master).I have used a checksum utility that someone recommended to check if the tables are in sync, but I don't have a GUI installed on Ubuntu, so trying to interpret the selected columns

Re: Calendar creation

2008-07-17 Thread Rob Wultsch
On Thu, Jul 17, 2008 at 8:50 AM, Weston, Craig (OFT) [EMAIL PROTECTED] wrote: Hi there, Is there any simple way to create a calendar table? For example I want to create a reference calendar containing all the dates of several years so I can accurately represent even days where I have no data

MySQL certification lag

2008-07-17 Thread Rob Wultsch
Can anyone comment about how long it takes to a mysql cert letter? I was RIF'ed recently and have since passed the MySQL Developer exams, and would love to not have to wait at a minimum a month to be able to put the certification on my resume. After we receive notice of your results, we send a

Re: Calendar creation

2008-07-17 Thread Jim Ginn
Craig: Not sure but we use: http://www.cascade.org.uk/software/php/calendar/ (ie. php) at: http://downtownoceancity.com/events Jim On Thu, Jul 17, 2008 at 8:50 AM, Weston, Craig (OFT) [EMAIL PROTECTED] wrote: Hi there, Is there any simple way to create a calendar table? For example I

Re: Calendar creation

2008-07-17 Thread Peter Brawley
Craig, Is there any simple way to create a calendar table? See Make a calendar table at http://www.artfulsoftware.com/infotree/queries.php. PB Weston, Craig (OFT) wrote: Hi there, Is there any simple way to create a calendar table? For example I want to create a reference calendar

RE: Calendar creation

2008-07-17 Thread Weston, Craig (OFT)
Thanks, everybody! Craig Weston nfrastructure Contractor NYS CIO/OFT Enterprise Helpdesk Management 518-486-4569 [EMAIL PROTECTED] -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2008 2:26 PM To: Weston, Craig (OFT) Cc: mysql@lists.mysql.com

how to display numbers with exponent

2008-07-17 Thread Gilles MISSONNIER
Hello again, I inserted double values, like : mysql insert into t (n) values ('0.54316E+11'); then I display it as : 5431600 which is not easy to read. Is there a way to tell Mysql to display such numbers with exponent ? I could not find a trick through and around

Re: Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread Jesse
Obvious question: Did you restart MySQL? netstat -l should show you what's listening for connections. you'll want to see if its listening on port 3306. Yes. When that didn't work, I re-started the whole server. netstat -l tells me that 192.168.1.128:mysql is listening. It lists a foreign

Re: Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread Curtis Maurand
I cannot. Are you trying to connect via the localhost. It may still be trying to connect to localhost. You might try changing the bind-address statement to bind-address = 0.0.0.0 so that it also listens to localhost as well. Also if you're trying to connect to an ip address instead

Re: Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread Jesse
I was wondering how I get it to listed on all ports. When I try 0.0.0.0, and try to restart, the restart fails, and when it tries to start again, I get the error, /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using

RE: Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread Curtis Maurand
I just checked my ubuntu config and I have: Port = 3306 Bind-address = 0.0.0.0 Pid-file = /var/run/mysqld/mysqld.pid Socket = /var/run/mysqld/mysqld.sock Nothig is in upper case. My phone is doing that for me. -Original Message- From: Jesse [EMAIL PROTECTED] To: Curtis Maurand [EMAIL

Need help figuring out mk-table-checksum

2008-07-17 Thread Jesse
I want to make sure that my master and slave machines are in sync. From what I hear, mk-table-checksum is a good way to do that. So, I downloaded and installed it on my Linux box (the slave). So, here's what I've got: WS2003 Master (IP 192.168.1.10) Ubuntu 8.04 Linux Slave (IP

Re: Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread Jesse
My settings are the same, except I have the bind-address set to my local IP of 192.168.1.128. I tried 0.0.0.0, and I still cannot connect from other machines. Jesse - Original Message - From: Curtis Maurand [EMAIL PROTECTED] To: Jesse [EMAIL PROTECTED] Cc: MySQL List

Re: Accessing remote machine (Ubuntu) from Window

2008-07-17 Thread chaim . rieger
Do you have skip networkin in my.cnf ? --Original Message-- From: Jesse To: Curtis Maurand Cc: MySQL List Sent: Jul 17, 2008 16:54 Subject: Re: Accessing remote machine (Ubuntu) from Window My settings are the same, except I have the bind-address set to my local IP of 192.168.1.128. I