counting by countrycode
- | customercode | customer name | customerphonenumber | callednumber | calldate | callstart | callend | callduration | callcost | - | 1116 | Company Name | Customer NUmber | 0061X | 2008-07-16 | 15:25:19 | 15:26:00 |1 | 0.229375 | | 1116 | Company Name | Customer NUmber | 0063X | 2008-07-16 | 15:25:21 | 15:26:44 |2 | 0.07759 | | 1116 | Company Name | Customer NUmber | 001XX | 2008-07-16 | 15:25:24 | 15:25:34 |1 | 0.229375 | | 1116 | Company Name | Customer NUmber | 0060X | 2008-07-16 | 15:25:25 | 15:29:33 |5 | 1.14688 | | 1116 | Company Name | Customer NUmber | 0061X | 2008-07-16 | 15:25:29 | 15:25:58 |1 | 0.038795 | | 1116 | Company Name | Customer NUmber | 0061X | 2008-07-16 | 15:25:29 | 15:25:48 |1 | 0.038795 | | 1116 | Company Name | Customer NUmber | 0061X | 2008-07-16 | 15:25:32 | 15:25:54 |1 | 0.038795 | | 1116 | Company Name | Customer NUmber | 0063X | 2008-07-16 | 15:25:33 | 15:25:45 |1 | 0.038795 | | 1116 | Company Name | Customer NUmber | 0061X | 2008-07-16 | 15:25:35 | 15:26:29 |1 | 0.229375 | | 1116 | Company Name | Customer NUmber | 0061X | 2008-07-16 | 15:25:38 | 15:25:53 |1 | 0.038795 | -- Hi, How can i count by countrycode with that table? I kind of need a summary to count how many calls went to certain country. Thank You. I hope my question is clear. Regards Ron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Accessing remote machine (Ubuntu) from Window
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 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" Sent: Thursday, July 17, 2008 5:41 PM Subject: RE: Accessing remote machine (Ubuntu) from Window 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Sent via BlackBerry from T-Mobile
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 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" Sent: Thursday, July 17, 2008 5:41 PM Subject: RE: Accessing remote machine (Ubuntu) from Window 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need help figuring out mk-table-checksum
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 192.168.1.128) I log into the Ubuntu box, and execute the following command: perl mk-table-checksum -replicate=test.checksum --user root --password mypassword -replcheck 192.168.1.10 localhost After a little while of churning away, I check the test.checksum table, and there is nothing in there. I'm hoping that means that it worked, and that there are no record differences, am I correct? Is there a better way to be sure? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Accessing remote machine (Ubuntu) from Window
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 PROTECTED]> Cc: "MySQL List" Sent: 7/17/2008 4:46 PM Subject: Re: Accessing remote machine (Ubuntu) from Window 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 password:YES)' This has been happening for a day or so, and I don't know if it's related to my problem or not. After changing the grant to use an IP address, I still cannot log in. Jesse [truncated by sender] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Accessing remote machine (Ubuntu) from Window
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 password:YES)' This has been happening for a day or so, and I don't know if it's related to my problem or not. After changing the grant to use an IP address, I still cannot log in. Jesse - Original Message - From: "Curtis Maurand" <[EMAIL PROTECTED]> To: "Jesse" <[EMAIL PROTECTED]> Cc: "MySQL List" Sent: Thursday, July 17, 2008 4:31 PM Subject: Re: Accessing remote machine (Ubuntu) from Window 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 of a named host, I've found that you have to code your grant statement to have an ip address instead of a hostname. Curtis Jesse wrote: 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 address of "*.*" When I re-issue the command with "-n", I can seee that it is, indeed, listening on port 3306. Can you think of any other reasons why the connection would fail? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Accessing remote machine (Ubuntu) from Window
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 of a named host, I've found that you have to code your grant statement to have an ip address instead of a hostname. Curtis Jesse wrote: 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 address of "*.*" When I re-issue the command with "-n", I can seee that it is, indeed, listening on port 3306. Can you think of any other reasons why the connection would fail? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Accessing remote machine (Ubuntu) from Window
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 address of "*.*" When I re-issue the command with "-n", I can seee that it is, indeed, listening on port 3306. Can you think of any other reasons why the connection would fail? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how to display numbers with exponent
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 http://dev.mysql.com/doc/refman/5.0/en/precision-math-numbers.html thanks. _-¯-_-¯-_-¯-_-¯-_ Gilles Missonnier IAP - [EMAIL PROTECTED] 01 44 32 81 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Calendar creation
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 Subject: Re: Calendar creation 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 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 > > This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system. > > > No virus found in this incoming message. > Checked by AVG - http://www.avg.com > Version: 8.0.138 / Virus Database: 270.5.0/1558 - Release Date: 7/17/2008 9:56 AM > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Calendar creation
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 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 This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system. No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.0/1558 - Release Date: 7/17/2008 9:56 AM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Calendar creation
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 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? > > This should give you some ideas. > > http://lists.mysql.com/mysql/212453 > > -- > Rob Wultsch > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL certification lag
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 letter to you with details on how to access the Certification Candidate part of the MySQL Web site. Please allow 4 to 6 weeks delivery time for this letter. If you passed the exam, the letter will also contain your certification diploma and instructions on how to obtain logos for use on your business cards, stationary, personal home page, blog, personal e-mail signature, and so on. With these proofs of knowledge at your disposal, you're well equipped to enhance your career path. " http://www.mysql.com/certification/certfaq.html The ZCE (which I plan to take next...) seems to claim a much *faster turn around: "Once you have passed the exam, it takes 24-48 hours for your name and credentials to be published in the Zend Yellow Pages for PHP Professionals." http://www.zend.com/en/services/certification/faq?search=&page=2 And they charge (125 vs 400) a heck of a lot less. *Snail mail is slow for them also: "We will mail your diploma once you have passed the exam. Please allow 8-10 weeks for delivery. " -- Rob Wultsch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Calendar creation
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 in my data > set. Any ideas? This should give you some ideas. http://lists.mysql.com/mysql/212453 -- Rob Wultsch -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Accessing remote machine (Ubuntu) from Window
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 that wrap in the text mysql command prompt is nearly impossible. So, what I'd like to do is connect to the Ubuntu server from one of my other windows machines where I do have a GUI, and can get much better output. So, that being the case, I've made a couple changes to try to get this working. First, I've changed the bind-address setting to refer to the ip address of the machine, not 127.0.0.1. Second, I've done a "GRANT ALL ON * TO [EMAIL PROTECTED] identified by 'mypassword'; When I try to connect via the mysql command utility in windows, I'm told "ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.128' (10061)" The firewall should be an issue in this case, because I'm connecting directly to the machine, and not going through a firewall. To my knowledge, there is not a firewall installed on the Ubuntu server, because I have it connecting to my server for replication, and that appears to be working fine. Are there some additional steps I need to take to make this work? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Calendar creation
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 This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.
tee command eating filesystem (4.0.18 64-bit)
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@:~> df -k /tmp Filesystem 1K-blocks Used Available Use% Mounted on /dev/sda5 521748 42624452620 9% /tmp mysql@:~> mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 157997 to server version: 4.0.18-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> tee /tmp/wtf.tee; Logging to file '/tmp/wtf.tee' mysql> select now(); +-+ | now() | +-+ | 2008-07-17 11:27:11 | +-+ 1 row in set (0.00 sec) mysql> notee; Outfile disabled. mysql> exit Bye [EMAIL PROTECTED]:~> df -k /tmp Filesystem 1K-blocks Used Available Use% Mounted on /dev/sda5 521748496240 0 100% /tmp [EMAIL PROTECTED]:~> ls -l /tmp/wtf.tee -rw-r--r-- 1 mysql mysql 464044032 2008-07-17 11:27 /tmp/wtf.tee I don't have to use tee but it's handy and more importantly this makes me wonder if I got a bad build and whether there's bigger mines out there I've yet to step on...
Re: mysql on 32 bit pae linux with 16 GB of memory
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 amount of memory? From what I read, even PAE kernels still limit threads to only use a maximum of 4 GB of memory. In an innodb only setup - do I need 64bit OS to use all RAM? Yes. 64Bit OS + 64bit mysql Regards Dominik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql on 32 bit pae linux with 16 GB of memory
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? From what I read, even PAE kernels still limit threads to only use a maximum of 4 GB of memory. In an innodb only setup - do I need 64bit OS to use all RAM? Regards Dominik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help requested to provide bug reports for 5.1
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 doesn't say otherwise I want to add here 6.0 and MySQL Cluster. Often bugs are reported only for this versions but also already in 5.1. When you find such a bug, please let us know. Best Regards, Susanne -- Sun Microsystems GmbH Dipl.-Inf. Susanne Ebrecht, Support Engineer 52066 Aachen, Germany http://www.sun.de Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Amtsgericht München: HRB 161028 Geschäftsführer: Thomas Schröder, Wolfgang Engels, Dr. Roland Bömer Vorsitzender des Aufsichtsrates: Martin Häring -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: cluster
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. > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cluster
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