Re: Remote Access to MySQL
Am 08.03.2015 um 01:49 schrieb Rafael Ribeiro: Hello List, I'm not an expertise on MySQL and we are facing a strange issue: We had a Virtual Machine, running CentOS + MySQL 5.0 with IP (1.1.1.1). After move this Virtual Machine to a new one (got a new IP - 2.2.2.2), we lost the ability to connect to mysql remotely, from external IPs. I read a lot of tutorials and tips without success. What I need to do, to come back to working configuration like oldest machine, allowing remote connections? did you check bind-address in your my.cnf? regards Florian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'
Hey Gleb, thanks for taking your time! php.ini: ; As of 4.0b4, PHP always outputs a character encoding by default in ; the Content-type: header. To disable sending of the charset, simply ; set it to be empty. ; ; PHP's built-in default is text/html default_mimetype = text/html default_charset = utf-8 mysql version: mysql Ver 14.7 Distrib 4.1.13, for pc-linux-gnu (i686) using readline 5.0 php version: PHP 4.4.0 (cli) (built: Aug 23 2005 14:55:11) Copyright (c) 1997-2004 The PHP Group Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies apache2: Server version: Apache/2.0.54 Server built: Aug 24 2005 13:41:09 Server's Module Magic Number: 20020903:9 Architecture: 32-bit Server compiled with -D APACHE_MPM_DIR=server/mpm/prefork -D APR_HAS_SENDFILE -D APR_HAS_MMAP -D APR_HAVE_IPV6 (IPv4-mapped addresses enabled) -D APR_USE_SYSVSEM_SERIALIZE -D APR_USE_PTHREAD_SERIALIZE -D SINGLE_LISTEN_UNSERIALIZED_ACCEPT -D APR_HAS_OTHER_CHILD -D AP_HAVE_RELIABLE_PIPED_LOGS -D HTTPD_ROOT=/usr -D SUEXEC_BIN=/usr/sbin/suexec2 -D DEFAULT_PIDLOG=/var/run/httpd.pid -D DEFAULT_SCOREBOARD=logs/apache_runtime_status -D DEFAULT_LOCKFILE=/var/run/accept.lock -D DEFAULT_ERRORLOG=logs/error_log -D AP_TYPES_CONFIG_FILE=/etc/apache2/mime.types -D SERVER_CONFIG_FILE=/etc/apache2/httpd.conf The text in the browser coming from PHP is as well as the plain HTML utf-8 encoded, it is only the mysql-queries in php which return iso - besides the original problem that the query sends strings as iso... :/ Thanks again, Florian On Thu, 25 Aug 2005 10:58:07 +0300 Gleb Paharenko [EMAIL PROTECTED] wrote: Hello. What is the value of the default_charset variable in your php.ini file? What version of MySQL do you use? Florian Burkart [EMAIL PROTECTED] wrote: What might help as well is another problem I have: Somehow, the data I am getting out of mysql and php and is being served by = apache is still in iso format, and not utf8. Which leads to bad displaying = (unless i switch back to iso in the browser, but then the html stuff in utf= 8 gets strange (which is served correctly in utf8).=20 Is that related? If not, still someone with hints on it? On Wed, 24 Aug 2005 20:55:21 +0300 Gleb Paharenko [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Zur Zeit befinde ich mich hinter einer Firewall welche das versenden von E-Mails über die Adresse [EMAIL PROTECTED] verhindert. Ihr erhaltet Antworten auf E-Mails an [EMAIL PROTECTED] daher ebenfalls von [EMAIL PROTECTED] Es macht keinen Unterschied welche der beiden Adressen ihr anschreibt. Meine alte Handynummer +49-151-11616247 ist gekündigt. Hier in Guadalajara, Mexico, erreicht ihr mich unter der +52-3310650934. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'
Hey everyone,
can't figure this one out, might be easy for one of you.
This is the query:
(SELECT 'Neue Gruppe' AS gruppenstring, '-1' AS gruppe_id)
UNION ALL
(SELECT CONCAT( gruppe, ' (', kommentar, ')' ) AS gruppenstring, gruppe_id
FROM tbl_gruppen
ORDER BY gruppe);
This error message is returned on the php website:
Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and
(utf8_general_ci,IMPLICIT) for operation 'UNION'
There is no error message (query executes successfully) in phpmyadmin or when
connecting by mysql.
Following query always executes successfully (no long term solution though):
(SELECT utf8_'Neue Gruppe' AS gruppenstring, utf8_'-1' AS gruppe_id)
UNION ALL
(SELECT CONCAT( gruppe, ' (', kommentar, ')' ) AS gruppenstring, gruppe_id
FROM tbl_gruppen
ORDER BY gruppe);
This is the output of
mysql show variables like %character%; show variables like %collation%;
+--++
| Variable_name| Value |
+--++
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_results| utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--++
7 rows in set (0.00 sec)
+--+-+
| Variable_name| Value |
+--+-+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+--+-+
3 rows in set (0.00 sec)
This is my.cnf
...
[mysql]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqladmin]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlcheck]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqldump]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlimport]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlshow]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[myisamchk]
character-sets-dir=/usr/share/mysql/charsets
[myisampack]
character-sets-dir=/usr/share/mysql/charsets
# use [safe_mysqld] with mysql-3
[mysqld_safe]
err-log = /var/log/mysql/mysql.err
# add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations.
[mysqld]
character-set-server= utf8
default-character-set = utf8
...
Probably easy, but help please :)
Florian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'
Hey everyone,
can't figure this one out, might be easy for one of you.
This is the query:
(SELECT 'Neue Gruppe' AS gruppenstring, '-1' AS gruppe_id)
UNION ALL
(SELECT CONCAT( gruppe, ' (', kommentar, ')' ) AS gruppenstring, gruppe_id
FROM tbl_gruppen
ORDER BY gruppe);
This error message is returned on the php website:
Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and
(utf8_general_ci,IMPLICIT) for operation 'UNION'
There is no error message (query executes successfully) in phpmyadmin or when
connecting by mysql.
Following query always executes successfully (no long term solution though):
(SELECT utf8_'Neue Gruppe' AS gruppenstring, utf8_'-1' AS gruppe_id)
UNION ALL
(SELECT CONCAT( gruppe, ' (', kommentar, ')' ) AS gruppenstring, gruppe_id
FROM tbl_gruppen
ORDER BY gruppe);
This is the output of
mysql show variables like %character%; show variables like %collation%;
+--++
| Variable_name| Value |
+--++
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_results| utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--++
7 rows in set (0.00 sec)
+--+-+
| Variable_name| Value |
+--+-+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+--+-+
3 rows in set (0.00 sec)
This is my.cnf
...
[mysql]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqladmin]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlcheck]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqldump]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlimport]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlshow]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[myisamchk]
character-sets-dir=/usr/share/mysql/charsets
[myisampack]
character-sets-dir=/usr/share/mysql/charsets
# use [safe_mysqld] with mysql-3
[mysqld_safe]
err-log = /var/log/mysql/mysql.err
# add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations.
[mysqld]
character-set-server= utf8
default-character-set = utf8
...
Probably easy, but help please :)
Florian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'
mysql show create table tbl_gruppen;
+-++
| Table | Create Table
|
+-++
| tbl_gruppen | CREATE TABLE `tbl_gruppen` (
`gruppe_id` smallint(4) unsigned NOT NULL auto_increment,
`gruppe` varchar(50) NOT NULL default '',
`kommentar` varchar(255) NOT NULL default '',
`geändert` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
PRIMARY KEY (`gruppe_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
+-++
1 row in set (0.00 sec)
On Wed, 24 Aug 2005 20:55:21 +0300
Gleb Paharenko [EMAIL PROTECTED] wrote:
Hello.
Your character_set_xxx variables is ok. The problem could be in
the table definition. Send the output of
SHOW CREATE TABLE tbl_gruppen;
Florian Burkart [EMAIL PROTECTED] wrote:
Hey everyone,
can't figure this one out, might be easy for one of you.
This is the query:
(SELECT 'Neue Gruppe' AS gruppenstring, '-1' AS gruppe_id)
UNION ALL
(SELECT CONCAT( gruppe, ' (', kommentar, ')' ) AS gruppenstring, gruppe_id
FROM tbl_gruppen
ORDER BY gruppe);
This error message is returned on the php website:
Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and
(utf8_general_ci,IMPLICIT) for operation 'UNION'
There is no error message (query executes successfully) in phpmyadmin or
when connecting by mysql.
Following query always executes successfully (no long term solution though):
(SELECT utf8_'Neue Gruppe' AS gruppenstring, utf8_'-1' AS gruppe_id)
UNION ALL
(SELECT CONCAT( gruppe, ' (', kommentar, ')' ) AS gruppenstring, gruppe_id
FROM tbl_gruppen
ORDER BY gruppe);
This is the output of
mysql show variables like %character%; show variables like %collation%;
+--++
| Variable_name| Value |
+--++
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_results| utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--++
7 rows in set (0.00 sec)
+--+-+
| Variable_name| Value |
+--+-+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+--+-+
3 rows in set (0.00 sec)
This is my.cnf
...
[mysql]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqladmin]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlcheck]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqldump]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlimport]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlshow]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[myisamchk]
character-sets-dir=/usr/share/mysql/charsets
[myisampack]
character-sets-dir=/usr/share/mysql/charsets
# use [safe_mysqld] with mysql-3
[mysqld_safe]
err-log = /var/log/mysql/mysql.err
# add a section [mysqld-4.1
Re: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'
What might help as well is another problem I have:
Somehow, the data I am getting out of mysql and php and is being served by
apache is still in iso format, and not utf8. Which leads to bad displaying
(unless i switch back to iso in the browser, but then the html stuff in utf8
gets strange (which is served correctly in utf8).
Is that related? If not, still someone with hints on it?
On Wed, 24 Aug 2005 20:55:21 +0300
Gleb Paharenko [EMAIL PROTECTED] wrote:
Hello.
Your character_set_xxx variables is ok. The problem could be in
the table definition. Send the output of
SHOW CREATE TABLE tbl_gruppen;
Florian Burkart [EMAIL PROTECTED] wrote:
Hey everyone,
can't figure this one out, might be easy for one of you.
This is the query:
(SELECT 'Neue Gruppe' AS gruppenstring, '-1' AS gruppe_id)
UNION ALL
(SELECT CONCAT( gruppe, ' (', kommentar, ')' ) AS gruppenstring, gruppe_id
FROM tbl_gruppen
ORDER BY gruppe);
This error message is returned on the php website:
Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and
(utf8_general_ci,IMPLICIT) for operation 'UNION'
There is no error message (query executes successfully) in phpmyadmin or
when connecting by mysql.
Following query always executes successfully (no long term solution though):
(SELECT utf8_'Neue Gruppe' AS gruppenstring, utf8_'-1' AS gruppe_id)
UNION ALL
(SELECT CONCAT( gruppe, ' (', kommentar, ')' ) AS gruppenstring, gruppe_id
FROM tbl_gruppen
ORDER BY gruppe);
This is the output of
mysql show variables like %character%; show variables like %collation%;
+--++
| Variable_name| Value |
+--++
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_results| utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--++
7 rows in set (0.00 sec)
+--+-+
| Variable_name| Value |
+--+-+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+--+-+
3 rows in set (0.00 sec)
This is my.cnf
...
[mysql]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqladmin]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlcheck]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqldump]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlimport]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlshow]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[myisamchk]
character-sets-dir=/usr/share/mysql/charsets
[myisampack]
character-sets-dir=/usr/share/mysql/charsets
# use [safe_mysqld] with mysql-3
[mysqld_safe]
err-log = /var/log/mysql/mysql.err
# add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations.
[mysqld]
character-set-server= utf8
default-character-set = utf8
...
Probably easy, but help please :)
Florian
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Zur Zeit befinde ich mich hinter einer Firewall welche das versenden von
E-Mails über die Adresse [EMAIL PROTECTED] verhindert. Ihr erhaltet Antworten
auf E-Mails an [EMAIL PROTECTED] daher ebenfalls von [EMAIL PROTECTED] Es macht
keinen Unterschied welche der beiden Adressen ihr anschreibt.
Meine alte Handynummer +49-151-11616247 ist gekündigt. Hier in Guadalajara,
Mexico, erreicht ihr mich unter der +52-3310650934.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
change collation on all existing databases, tables and columns
Hello there, I run MySQL 4.1.12 and have some databases with the default collation of latin1_swedish_ci. I have edited the my.cnf file to read default-collation = latin1_german1_ci Now I would like to change the collation on all existing databases, tables and columns to have the latin1_german1_ci collation, as the my.cnf entry only works for new entries. Is there an easy command or tool to achieve that? I don't want to send the appropriate command mentioning every single database, table and column, but rather look for a FOR loop or a wildcard. Thanks Florian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Does mySQL support Pascal/C++ like Unions
Hello! Does mySQL support a thing like Pascal/C++ unions for attribute types, i.e. an attribute can be of two types at the same time. Thanks in advance. Florian
Re: Faster reindexing
Dathan Vance Pattishall [EMAIL PROTECTED] writes: Maybe increasing #use for when mysql is doing a check or repair set-variable= myisam_sort_buffer_size=64M to a higher value will make the index happen faster on the fly. MySQL doesn't seem to honour this variable. I've set it to '1024M', but the process size stays below 512 MB (which are occupied by other buffers). The indexing rate drops to a less than 6 MB per *hour* once 10 million (or so) records have been processed. It appears as if the only solution is splitting the table into 20 or 30 smaller ones and using a MERGE table. But if this is required, I might also do this using the existing RDBMS. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Recomended RAM for production server. 3Gb overboard?
Brad Brad [EMAIL PROTECTED] writes: The OpenBSD server is 2.8Ghz and may have as many as 230 mysql sessions with 14 queries a second, the rest will be sleeping (ftp sessions maintain connection). The db directory is 80mb total, 80 MB? Is this a typo? The old server is seems quite happy with 512mb. Ah, no typo. 8-) Obviously, your workload fits into less than a gigabyte. So you certainly don't need three or even four gigabytes of RAM. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Faster reindexing
Dathan Vance Pattishall [EMAIL PROTECTED] writes: #use for when mysql is doing a check or repair set-variable= myisam_sort_buffer_size=64M to a higher value will make the index happen faster on the fly. Oops. I only adjusted the key_buffer value. Probably I should set myisam_sort_buffer_size to several hundred megabytes. If InnoDB indexing doesn't finish either, I'll give it a try (I still hope that MyISAM tables are more light-weight than InnoDB tables and result in higher throughput in a many reads/rare bulk updates scenario). However, the indexes must be maintenance-free once created (no creeping index syndrome). Can it occur that index pages get lost during deletion? But, for a 100 million row table doing a dump and adding that dump back to the db might be your fastest method. Building the index at insertion for a self balancing tree is a faster in some cases (I believe this is the case) then building one on the fly. I don't think this matters much, as reindexing seems to reload the database anyway. My 2 cents. 100 million rows WOW. I initially hoped to store even a bit more. 8-/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Creeping index syndrome
Does MySQL require periodic reindexing for indexes on columns whose value permanently increases (while the oldest entries are expired)? Another database suffers from the so-called creeping index syndrome, which results in ever-growing indexes in such cases (some pages in the index can never be reused because they correspond to expired values which will never again be present in the corresponding column). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Faster reindexing
I've got a table with 100 million rows and need some indexes on it (one row is 126 bytes). I'm currently using MyISAM and the indexing proceeds at an astonishingly low rate: about 200 MB per hour. This is rate is far too low; if we had to recover the database for some reason, we'd have to wait for days. The table looks like this: CREATE TABLE flows ( versionCHAR NOT NULL, router CHAR(15) NOT NULL, src_ip CHAR(15) NOT NULL, dst_ip CHAR(15) NOT NULL, protocol TINYINT UNSIGNED NOT NULL, src_port MEDIUMINT UNSIGNED NOT NULL, dst_port MEDIUMINT UNSIGNED NOT NULL, packetsINTEGER UNSIGNED NOT NULL, bytes INTEGER UNSIGNED NOT NULL, src_if MEDIUMINT UNSIGNED NOT NULL, dst_if MEDIUMINT UNSIGNED NOT NULL, src_as MEDIUMINT UNSIGNED NOT NULL, dst_as MEDIUMINT UNSIGNED NOT NULL, src_netCHAR(1) NOT NULL, dst_netCHAR(1) NOT NULL, direction CHAR(1) NOT NULL, class CHAR(1) NOT NULL, start_time CHAR(24), end_time CHAR(24) ); Indexes are created using this statement: mysql ALTER TABLE flows - ADD INDEX dst_ip (dst_ip, src_ip), - ADD INDEX dst_port (dst_port, start_time), - ADD INDEX src_ip (src_ip, start_time), - ADD INDEX time (start_time); In theory, we could represent the columns router, src_ip, dst_ip, start_time, end_time using integers of the appropriate size, but this would make ad-hoc queries harder to type (and porting our applications would be even more difficult). Should I switch to another table type? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql - Dual Xeon or Dual Opteron
Konstantin Yotov [EMAIL PROTECTED] writes: 2x1GHz Intel, 1GB RAM, 40GB WD 7200 8MB cache. We are going to uprade our server but I'am wondering between new Opteron (1.4GHz)and Xeon (2.4). Can't you get a machine for testing before you buy it? Xeon processors aren't necessarily a significant win over Pentium 3s, even with the noticeable difference in clock speed. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
disabling version number
Hi, is there any configuration directive of disabling the output of the MySQL servers version number? Thanks Florian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: disabling version number
No, why? Part of my security concept, I generally disable all version numbers. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: disabling version number
;-) - Original Message - From: Joseph Bueno [EMAIL PROTECTED] To: Florian Effenberger [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, March 24, 2003 5:39 PM Subject: Re: disabling version number You can patch mysql source and recompile ;) However, if someone has enough access rights on your system to run select version();, showing mysql version number should be the least important of your problems. Regards, Joseph Bueno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql Error
When I try to connect to the MySql server on localhost I get the following error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I am not quite sure what this means. I am running Mac OS X 10.2.3. Before I upgraded from 10.1, I had no problems, but now am unable to connect at all. Is it possible to remove MySql (and how do I go about it) so that I can reinstall it again? Sorry if these are stupid questions, but I can't seem to find how to uninstall MySql in the manual. Thanks -- Daniel Florian [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] (work) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
information
hi, Somebody saw comparaisons of productivity for mysql and others RDBMS? or somebody do comparaisons? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-Server doesn't connect to any port
Florian Boehl wrote: Hi, I've got a problem with my mysql-server. I'm using Debian GNU/Linux (Sid). If I start the server there are no error messages at all but the server doesn't connect to any port so communication with it can only be done by the socket file. Has anyone of you ever had a similar problem? Thanks to everybody who can help me. Greetings Flo Hi, Make sure that mysqld is not started with --skip-networking option. Oops. I think I had tomatoes on my eyes. :) Many thanks. Flo -- -BEGIN GEEK CODE BLOCK (3.12)- GCS d(--) s: a18 C++(+++) UL+++$ P E- W++ N w-(--) PS+ PE-- Y+ PGP++ t+(++) 5+ X(+) R+ !tv b+ D+ G+ e(*) h(!)--- r+ y -END GEEK CODE BLOCK-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
limitation mysql in request?
Hi, in the version 4.0 mysql accepte this request? select where ... IN (SELECT ) subqueries? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql 4.1?
when the version of mysql 4.1 is ready ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
myslq et mysqlmax?
Hi What is the difference between myslq and mysqlmax? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
pb connection
Hi, i use mysql v4.0 i have got a problem with the connection to database i can connect if i have localhost but if i want to connect to database i can't. There is a limitation with mysql v4.0 or not ? have you got an idea? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
pb connection
Hi, i use mysql v4.0 i have got a problem with the connection to database i can connect if i have localhost but if i want to connect to database i can't. There is a limitation with mysql v4.0 or not ? have you got an idea? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
probleme conection
Hi, i use mysql v4.0 i have got a problem with the connection to database i can connect if i have localhost but if i want to connect to database i can't. There is a limitation with mysql v4.0 or not ? have you got an idea? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Re: pb connection
I think it's good but how i can look because i begin to use mysql and i am not very good At 13:09 02/08/02, you wrote: Hello Florian, Friday, August 02, 2002, 1:41:51 PM, you wrote: Please, don't send me your answer, send it to the mailing list. FL i have got access denied Check permissions for your user. Seems, your user has permissions to connect only from localhost. FL At 12:05 02/08/02, you wrote: Florian, Friday, August 02, 2002, 12:29:08 PM, you wrote: FL i use mysql v4.0 i have got a problem with the connection to database i can FL connect if i have localhost but if i want to connect to database i can't. FL There is a limitation with mysql v4.0 or not ? have you got an idea? FL thanks Florian, what exactly problem do you have? You got Access denied error or can't connect or any other error or what? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Re: pb connection
I think it's good but how i can look because i begin to use mysql and i am not very good What i must put on 'Host'? thanks At 13:09 02/08/02, you wrote: Hello Florian, Friday, August 02, 2002, 1:41:51 PM, you wrote: FL i have got access denied Check permissions for your user. Seems, your user has permissions to connect only from localhost. FL At 12:05 02/08/02, you wrote: Florian, Friday, August 02, 2002, 12:29:08 PM, you wrote: FL i use mysql v4.0 i have got a problem with the connection to database i can FL connect if i have localhost but if i want to connect to database i can't. FL There is a limitation with mysql v4.0 or not ? have you got an idea? FL thanks Florian, what exactly problem do you have? You got Access denied error or can't connect or any other error or what? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: pb connection
can i test without my connection java? the user are in the table user in mysql ? and what do you put on host? sorry it's the first time i use mysql At 16:04 02/08/02, you wrote: Hi, I 've tested the stated version both on Linux and Windows and have not encountered any problem of this type. I think you should check up with the following: 1. Check the username / password that you are using to connect to the database. 2. Check the port value (default value is 3306) 3. Check the URL syntax. thanks -Original Message- From: Florian Litot [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 6:54 PM To: [EMAIL PROTECTED] Subject: pb connection Hi, i use mysql v4.0 i have got a problem with the connection to database i can connect if i have localhost but if i want to connect to database i can't. There is a limitation with mysql v4.0 or not ? have you got an idea? thanks - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem on open a table
HI, I do not manage to open a table it puts me Can' t open takes off: ' pkf_as_events_log. MYD '. (Errno: 145) is what anybody has already had this error on mysql? Cordially Florian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JOINS: MySQL Query Speed
Hello I have a question on how MySQL JOIN has effect on query (search) performance: Our database consists of about 250.000 datasets (rows). Right now, all of the 150 columns are in one big table. However, we do have certain columns that are empty for most rows (for example information of the status of pictures of customer). Out of the 250.000, only 20.000 have information on photo-status. The idea is to put the columns (amount: 5) about the photo-status in a seperate table to not blow up the database (to normalize the database ?). A search over, lets say, 15 columns, that includes one columns out of the photo-status-columns would then have to JOIN these two tables. Does that lead to performance drop ? Or is maybe even faster to search with a JOIN, because we only have 20.000 rows in that seperate photo-status-table ? What would probably happen if we did this with, lets say, 5 other data-sets (we would the have 7 tables connected through JOIN) ? I hope someone can help me with performance issues about JOIN. Thanks. Flo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JOINS: MySQL Query Speed
Hello I have a question on how MySQL JOIN has effect on query (search) performance: Our database consists of about 250.000 datasets (rows). Right now, all of the 150 columns are in one big table. However, we do have certain columns that are empty for most rows (for example information of the status of pictures of customer). Out of the 250.000, only 20.000 have information on photo-status. The idea is to put the columns (amount: 5) about the photo-status in a seperate table to not blow up the database (to normalize the database ?). A search over, lets say, 15 columns, that includes one columns out of the photo-status-columns would then have to JOIN these two tables. Does that lead to performance drop ? Or is maybe even faster to search with a JOIN, because we only have 20.000 rows in that seperate photo-status-table ? What would probably happen if we did this with, lets say, 5 other data-sets (we would the have 7 tables connected through JOIN) ? I hope someone can help me with performance issues about JOIN. Thanks. Flo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JOINS: MySQL Query Speed
Hello I have a question on how MySQL JOIN has effect on query (search) performance: Our database consists of about 250.000 datasets (rows). Right now, all of the 150 columns are in one big table. However, we do have certain columns that are empty for most rows (for example information of the status of pictures of customer). Out of the 250.000, only 20.000 have information on photo-status. The idea is to put the columns (amount: 5) about the photo-status in a seperate table to not blow up the database (to normalize the database ?). A search over, lets say, 15 columns, that includes one columns out of the photo-status-columns would then have to JOIN these two tables. Does that lead to performance drop ? Or is maybe even faster to search with a JOIN, because we only have 20.000 rows in that seperate photo-status-table ? What would probably happen if we did this with, lets say, 5 other data-sets (we would the have 7 tables connected through JOIN) ? I hope someone can help me with performance issues about JOIN. Thanks. Flo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JOINS: MySQL Query Speed
Hello I have a question on how MySQL JOIN has effect on query (search) performance: Our database consists of about 250.000 datasets (rows). Right now, all of the 150 columns are in one big table. However, we do have certain columns that are empty for most rows (for example information of the status of pictures of customer). Out of the 250.000, only 20.000 have information on photo-status. The idea is to put the columns (amount: 5) about the photo-status in a seperate table to not blow up the database (to normalize the database ?). A search over, lets say, 15 columns, that includes one columns out of the photo-status-columns would then have to JOIN these two tables. Does that lead to performance drop ? Or is maybe even faster to search with a JOIN, because we only have 20.000 rows in that seperate photo-status-table ? What would probably happen if we did this with, lets say, 5 other data-sets (we would the have 7 tables connected through JOIN) ? I hope someone can help me with performance issues about JOIN. Thanks. Flo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Query Speed
Hello our database consists of one table with approx. 150 columns. We have a query going over 11 columns (most tinyint, int and some varchar) Out of 217237 rows the query found 56 matches. Without Indexing, the query took 2,55 seconds. With Indexing, the query took 0,04 seconds. The database and query is currently being tested on the following computer: AMD Athlon(TM) XP1700+ (1500MHz), 768MB RAM MySQL 3.23.41 unter SuSE Linux 7.3 (Kernel 2.4.10-4GB) Is the speed of the query (2,55 sec, respectively 0,04 seconds) reasonable ? With the Index, should the query even be faster than 0,04 seconds ? Thanks for your Help. Flo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Database Questions
Dear Mr. Jeremy D. Zawodny, I am subscriber of the mysql.com MailingList and have received some of your mails. From the mails I get the idea that you have quite some experience with mysql. We are planning to migrate our database (currently oracle) to mysql. Our database consists of about 150 columns (which we are planning to put all into one table under mysql so that queries run faster and dont have to join different tabels) and about 500k rows. The main field type we are using is varchar, tinyint, int, smallint and date. (lots of varchars). Queries may run over as much as 15 to 20 columns (some of them varchar, some of them tinyint). Queryload my be heavy. (about 100 concurrent queries) Here are my questions: 1. Is it a good idea to have all the columns in one big table ? 2. Does mysql encounter problems with indexes (speed, performance) when having large amount of rows ? 3. What kind of server configuration (hardware) for the dedicated MySQL-Server would you suggest to get a decent performance ? 4. How many concurrent threads/queries can we expect to achieve ? 5. Shall we look into replicating (master/slave) to get better performance ? If yes, how would you suggest a possible setup. 6. Is char() a better choice than varchar() in terms of speed when queries are run (we are aware of the fact that char() requires more disc space) ? It would be very helpful for us if you could help us with the above questions.. Thank you very much. Best regards. Florian Wilken Waldenserstr. 35 10551 Berlin Tel.: 030-39037364 Fax.: 030-39037365 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
removing duplicates
hi! i have a table with alot duplicates in them. the tables has about 2 million rows and i expect that there are ca. 20.000 duplicates which have to be removed.. what i basicly wanna do is: delete rows from that table which have the same value on the column col1, col2 and col3 of that table. now the tricky part though: i only wanna keep the row with the highes fooId in that table.. all other duplicates should be deleted.. for example when i have those rows: fooId col1col2col3 1 bla yo orange 2 bla yo orange 3 bla yo orange 4 super yo orange 5 hey hey hey 6 hey hey hey it should delete the rows with the fooId: 1, 2 and 6... whats the easiest way to do that stuff with mysql? thanks alot in advance =) ciao! florian -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
string column types
hi! i have a question concerning string column types of a mysql database: char is better for small sized strings (because of the fixed row size, and for long strings it would blow the db up too much) but how about varchar vs text or blob.. which one is suited for which need the best? blob is case-sensitive.. but except for that text can store more than 255 chars is there any difference between varchar and text/blob? thanks alot in advance best, florian -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
width and height performance
hi! i have to store a dataset of 20 elements. the data is a int(1). i would have about 800 000 datasets. now the question is what performs better with mysql? one table like this: mytable -- someId element1 int(1) element2 int(1) element3 int(1) element4 int(1) ... element20 -- or mytable -- someId elementNum int(2) elementValue int(1) -- is it better to have 800 000 rows with 21 columns or 160 000 000 rows with 3 columns? thanks alot! =) best, florian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: performance of joins
well. for now it can only be one contact and one address per customer. the thing is though, that also other people can have addresses and contacts. so for example there will be a user table or something like that. and a user will also have address and contact information. would you still recommend then to make a extra contact and adress table or should the address and contact columns be just added in each of the tables which needs them (like in that case cusstomers and users) im especially interested in what performs better in mysql.. for example is it an performance advantage to have extra tables for addresses and contacts, since not all of the queries will ask for the normal information, the address information and the contact information at the same time? thanks alot in advance! florian Well, you usualy split your data in tables for a reason, because some data in mulitple numbers are associated to one, or multiple data. In your case, if you have one address and contact per customers, then make it one table. If you have an unknown numer of contacts and numbers per customer, then make multiple tables. The joins will be on the primary keys (they should be at least). so it should be fast, even with 2 million records. -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
performance of joins
hello! im storing pretty big amounts of customer data in a mysql databases. its about 2 million rows. what im wondering about now is, how does mysql perform joins on such amounts of data? i was planning to split the info in at least 3 tables: a general customer table, a address table, and a contact table. since also other needs than just customers, for storing addresses and contacts. would it perform better though to store all that in one single table or is is it okay to split it up in 3 and join them later then, depening on what information is needed? thanks alot. florian -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL-String mit group by will nicht....
question textHallo, kann mir jemand sagen, was daran falsch ist ?/text description try sql select mobile_number, count(correct) anzahl from answers where correct = '1' and anzahl = 5 and DATE_FORMAT(date, '%Y%m%d%H%i') = DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 9 DAY), '%Y%m%d0700') AND DATE_FORMAT(date, '%Y%m%d%H%i') DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 4 DAY), '%Y%m%d0700') group by mobile_number /sql errorunknown column anzahl in where clause/error /try !-- anders: -- try sql select mobile_number, count(correct) from answers where correct = '1' and count(correct) = 5 and DATE_FORMAT(date, '%Y%m%d%H%i') = DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 9 DAY), '%Y%m%d0700') AND DATE_FORMAT(date, '%Y%m%d%H%i') DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 4 DAY), '%Y%m%d0700') group by mobile_number /sql errorFehlermeldung: Invalid use of group function/error /try !-- selbst bei diesem hier kommt die gleiche fehlermeldung: -- try sql select mobile_number, count(correct) from answers where correct = '1' and count(correct) = 5 group by mobile_number /sql errorFehlermeldung: Invalid use of group function/error /try /description /question !-- Sorry wegen den tags, aber als ich versucht habe die nachricht etwas übersichtlicher zu gestalten, hat mein XML geplagters hirn die kontrolle übernommen.. Allerdings bin ich mir der kommentare nicht sicher :) auch fehlen noch ein paar header sowie die dtd DAS PROBELM ist aber ernst gemeint! -- -- Florian Schmidt mailto:[EMAIL PROTECTED] http://www.f-24.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: date_format doesn't work correct
At 17:51 19.07.2001 +0200, you wrote: okay, i see this output on my sco-machine: '2001071614' '2001-07-19 14:00:00' if i try the same with mysql-front on my win2k machine: '2001071914' '2001-07-19 14:00:00' Somehow your sample data doesn't look right: shouldn't it be '2001071614' '2001-07-16 14:00:00' ^ exactly this is the bug! the date at this time was: '2001-07-19 14:00:00' and now() correctly reports this, but a date_format(now(), '%Y%m%d%H') says '2001071614' with 16 as the month-day instead of 19 which would be right !? -- Florian Schmidt mailto:[EMAIL PROTECTED] http://www.f-24.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
date_format doesn't work correct
Hi! i've mysql-3.23.39-nt on winnt with a client running under SCO 3.2 i've a simple querry with date_format in it, but date_format isn't doing what i expect... sql_string: select date_format(c.hour, '%Y%m%d%H'), c.hour from count c c.hour is DATETIME okay, i see this output on my sco-machine: '2001071614' '2001-07-19 14:00:00' if i try the same with mysql-front on my win2k machine: '2001071914' '2001-07-19 14:00:00' ?!? i'm using the C-API (libmysqlclient.a) from mysql-3.23.38-pc-sco3.2v5.0.6-i386.tar.gz any ideas ? what should i do? a new libmysqlclient ? thx! -- Florian Schmidt mailto:[EMAIL PROTECTED] http://www.f-24.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: date_format doesn't work correct
At 09:25 19.07.2001 -0400, you wrote: Probably due to timezone setting differences between the two client machines. i also thought about that, but there are 2 DAYs difference... can this be a timezone issue ? okay, i see this output on my sco-machine: '2001071614' '2001-07-19 14:00:00' if i try the same with mysql-front on my win2k machine: '2001071914' '2001-07-19 14:00:00' ?!? i'm using the C-API (libmysqlclient.a) from mysql-3.23.38-pc-sco3.2v5.0.6-i386.tar.gz -- Florian Schmidt mailto:[EMAIL PROTECTED] http://www.f-24.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: date_format doesn't work correct
At 09:40 19.07.2001 -0400, you wrote: You're correct, likely not a timezone problem. Have you confirmed that the clocks on these machines are synchronized? That they aren't really three days off? yep, again and agein :) the clocks are in sync +/- 5 secs okay, i see this output on my sco-machine: '2001071614' '2001-07-19 14:00:00' if i try the same with mysql-front on my win2k machine: '2001071914' '2001-07-19 14:00:00' ?!? i'm using the C-API (libmysqlclient.a) from mysql-3.23.38-pc-sco3.2v5.0.6-i386.tar.gz Florian Schmidt mailto:[EMAIL PROTECTED] http://www.f-24.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
VB, SQL: ...WHERE Mitglieder.geb='1978-08-26' doesn't work
I'm using Visual Basic with DAO 3.6 and I try to execute this query dim rsPersonen as dao.recordset Set rsPersonen = db.OpenRecordset( _ SELECT Mitglieder.* FROM Mitglieder + _ WHERE Mitglieder.geb='1978-08-26') Here I get an Error-Message: Runtime-Error 3464, ... If I use any other SQL-Query-Tool (e.g. MySQLFront) this query works and returns (as estimated) 1 Record. Any other query which is not using any date works, e.g.: dim rsPersonen as dao.recordset Set rsPersonen = db.OpenRecordset( _ SELECT Mitglieder.* FROM Mitglieder + _ WHERE Mitglieder.VName='Florian') I hope you could help me solving this problem. By the way: Sorry for my bad english! Thanks Florian Lagg ([EMAIL PROTECTED]) __ Ferienklick.de - Jede Menge Urlaub auf einen Blick! Hier geht's zu Ihrem Traumstrand: http://ferienklick.de/?PP=2-0-100-105-1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
VB, SQL: ...WHERE Mitglieder.geb='1978-08-26' doesn't work
I'm using Visual Basic with DAO 3.6 and I try to execute this query dim rsPersonen as dao.recordset Set rsPersonen = db.OpenRecordset( _ SELECT Mitglieder.* FROM Mitglieder + _ WHERE Mitglieder.geb='1978-08-26') Here I get an Error-Message: Runtime-Error 3464, ... If I use any other SQL-Query-Tool (e.g. MySQLFront) this query works and returns (as estimated) 1 Record. Any other query which is not using any date works, e.g.: dim rsPersonen as dao.recordset Set rsPersonen = db.OpenRecordset( _ SELECT Mitglieder.* FROM Mitglieder + _ WHERE Mitglieder.VName='Florian') I hope you could help me solving this problem. By the way: Sorry for my bad english! Thanks Florian Lagg ([EMAIL PROTECTED]) __ Sie surfen im Internet statt im Meer? Selbst schuld! Auf zum Strand: http://lastminute.de/?PP=1-0-100-105-1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: XML support under mySQL
On Tue, Feb 27, 2001 at 01:21:52AM +, Peter Skipworth wrote: How is this superior to SQL? It includes the letters "XML", which, apparantly, can do everything from butter your toast to giving you an orgasm like no other you've had before. Don't you just *love* buzzwords! Sorry...I had to say it =) And no, I'm not at all the cynical type...not I! XML won't even switch on my computer (well... at least not for me ;-) ). It wont wash my car. It wont feed the cat. It wont give me an orgasm of any kind. But I find it usefull to _store_ structured data... Which, afterall, and DBMS is all about. It's not about specifying an query in XML - this _may_ be an side-effect, but there certainly should be alternatives (like some extended SQL). Greetings, Florian Pflug PS: I don't _know_ if you are the cynical type, but you certainly _sound_ like the cynical type... ;-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: XML support under mySQL
On Sun, Feb 25, 2001 at 10:37:10AM -0600, Cal Evans wrote: Glorious Sunday morning greetings to you Jan, No, XML is a format for 2 different applications, usually 2 totally separate applications, to be able to exchange data. It is not an appropriate choice for storing large amounts of data that will have to be queried. Nor is it an appropriate choice of language for talking to an RDBMS. Outside of the fact that it can be extremely verbose, we already have a perfectly good language for that, SQL. SQL is a language for committing data to a storage mechanism and retrieving the data back. It is superior to XML in those tasks. SQL ist tighty coupled with _relational_ database design. Which has its advantages, but also a lot of shortcomings. Every time I am dealing with a tree structure (Which is quite common - thing of document handling in folders, an access system using groups of groups, an webmailer usings folders, mails, attachments,) I either need to to a _LOT_ queries when parsing through the tree, or I need a very complex logic, and still quite a few queries. Most data people are dealing with is much more suited for XML than for an RDBMS. Again, if you have need to talk to your RDBMS via XML then a thin wrapper written in the language of your choice is the proper way to go. This allows you to do your job without bloating my application with unnecessary code. ironic Maybe my application does not need the power of SQL, but always does a full scan over the whole table, thus the only SQL-Statement used is "select * from table". I don't want my application to be bloadt with your bloody SQL, so lets just take the SQL-Parsed/Engine out of the DB, and make them a client-side library. Actually, I also do not need locking implemented in the db, since my application is just used by one person, so this should be handles by the client too. And all those datatypes in Mysql... Why do we need them... We just need BLOBs, we then can just create PHP-Objects with the necessary data, and store them in one big BLOB (of course after a call to serialize() ). /ironic And I also disagree with your statement that there is no difference between metadata and data. there most certainly is. But that's a discussion for another thread. Would you consider formating/layouting information in an document data or meta-data? I guess for an word processor (or even an text editor) ist meta-data. But for an DTP-Programm it sure is data. I want an DB which helps me storing structured data efficiently, and I think XML could be part of the solution. greetings, Florian Pflug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: XML support under mySQL
On Sat, Feb 24, 2001 at 12:50:13PM +0100, Juergen Fey wrote: Adding XML support to mySQL is no big deal if your`re talking about very structured data sets like Player FirstNameJoe/FirstName LastNameMontana/LastName Average Team="49ers"not bad at all/Average /Player If you got to handle a lot of these, than its easy to write an external XML I/O filter which even could handle the attributes. The result would be a simple flat Table. BUT if you`re talking unstructured XML data like typical articles, where the schema or DTD defines some sort of flexible substructures (that`s what i am dealing with a lot) then the relational database model won`t work too good, since you would need either to generate one TABLE per article plus using generated acess code (beans etc.) or you would have to link each elements content into specific tables ... costly if you got to retrieve stuff. I think XML support should not be just "sending the respone of an SQL-Queries written in a weird way as an XML Document as another weird XML Document to the client". It should make the DB-Server into a hugh archive of structured data. One need to rething the concept of tables, fields, record for this... Maybe one DB would just be one big XML-Document (of course stored not at a plain text file, but somehow more sophisticated - and indexed of course), and querieny would mean to look for a certain patters of tags... Maybe a queried could look like this. invoice total "18000" count min="15" item /item /count /invoice Meaning: look for invoices which a total price over 18000, and which have at least 15 items. Just my stupid ideas at 2:00 am in the morning.. but I think this would certainly make some peoples lives easier ;-)) greetings, Florian Pflug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: create table
On Sun, Feb 25, 2001 at 10:07:41PM -0800, Jeremy D. Zawodny wrote: On Mon, Feb 26, 2001 at 01:26:55PM +0800, WANG_KING£¨Íõ¸Ö£© wrote: Anyone can give me an example of create a transactional table in V3.22.23? Thanks. 3.22(!!!).23??? This has IMHO no BDB-Table support. You need 3.23.xx - the latest one is 3.23.33 greetings, Florian Pflug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.32 / SuSE Linux 7.1 / php and normal user
On Mon, Feb 26, 2001 at 04:45:50PM +0100, Thomas Spahni wrote: On Wed, 21 Feb 2001, Hagen Hoepfner wrote: I can normaly use mysql if I am root. But if i'm logged in as normal user or try to connect to mysql via php i got the following error message: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /usr/local/httpd/htdocs/gutefrage/secure/statistic.php on line 19 What can I do? Hagen, please read the very fine Manual chapter 4 about the "The MySQL Access Privilege System". This will solve your problem. I guess it won't This look more like mysql-client (or php) not finding the mysqld.sock socket, or the socket having the wrong unix permissions. Check for the permissions of the socket, and check if the client look for it at the same place as the server creates it. mfg, Florian Pflug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: XML support under mySQL
On Mon, Feb 26, 2001 at 06:50:27PM -0600, Cal Evans wrote: How is this superior to SQL? Why replace a great, stable and mature language for querying databases with a verbose one? Because it _might_ be the great, stable and matura language for storing and querying data of tomorrow.. By your logic, why even replace traditional files (i mean those consisting of _real_ paper) with this computer crap? And why use PHP/Perl/Phyton instead of great, stable and matura C? Why do OO-Programming? Procedural programming is much more matura? Also, a database IS a huge archive of structured data. :) The kind of structure that an table (essentially n-tuples of values) can represent is not nearly as powerfull as an XML-Tree. Greetings, Florian Pflug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Server Tuning
Hi I am running Mysql on a Machine with two PIII-600, and 1 GB of RAM. The disks are connected via U2W-SCSI. I tried tuning mysql for maximal performance the last days, but I'm not exactly sure which parameters I should increase, und to what value. Our web application is quite slow at the moment, and often the server is slower in doing the queries than they are created by the users, which steadily increases the number of running mysql-processes until they reach max_connection (which is 100 at the moment). Our Application searches through about 1.000.000 Records, and does heavy grouping, sometimes over 100.000 records. Is there any chance, that we can keep doing this queries on the fly, or will we have to cache them somehow? (which has a _lot_ of downsides, since the data changes quite frequently, about once every 1/2 hour). Which server parameters should we increase to make things faster? Since a lot of users "do the same thing" on this website, we often have the very _same_ query running 5 to 10 times, one started within 5 seconds or so after the other. Is there a way the prevent mysql from doing the query twice, and instead just wait for the first to be finished and then return the result to both clients? If not, I will code this feature in PHP, using shared memory unless anyone has already done this and is willing to share the code. Greetings, Florian Pflug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
