performance of joins

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

Re: performance of joins

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

width and height performance

-- 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

string column types

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

removing duplicates

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

change collation on all existing databases, tables and columns

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 Ma

Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'

ql-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 ple

Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'

ql-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 ple

Re: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'

+ 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 TAB

Re: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'

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: > > (SELE

Re: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'

ing 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]> wr

Re: Remote Access to MySQL

ty 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

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 r

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 fo

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 signific

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_sor

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

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 h

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

Mysql Error

ow 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] [EMAI

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

MySQL Database Questions

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

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

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 s

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 s

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 s

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 s

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 - Bef

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

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 ---

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 ---

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

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 > >Ch

Re: probleme conection (Please explain)

;Hi, > >Could you put more detail in the description of the >problem? > >Bye. >--- Florian Litot <[EMAIL PROTECTED]> >wrote: > > Hi, > > i use mysql v4.0 i have got a problem with the > > connection to database i can > > connect if i have loca

RE: pb connection

y 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---

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-ma

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 l

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

MySQL-Server doesn't connect to any port

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

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

date_format doesn't work correct

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

RE: date_format doesn't work correct

; '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-

RE: date_format doesn't work correct

t;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 usi

Re: date_format doesn't work correct

nd 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 ---

Update in 3.23.36-win without "order by"

n the Changelog for the 4.0.0 saying "Added ORDER BY syntax to UPDATE and DELETE. ". Is this feature only in version 4.0.0 avaliable ? p.s. shouldn't it be "SET col_name1=expr1 [, col_name2=expr2, ...]" instead of "SET col_name1=expr1, [col_name2=expr2, ...]" ?

SQL-String mit group by will nicht....

.. select mobile_number, count(correct) from answers where correct = '1' and count(correct) >= 5 group by mobile_number Fehlermeldung: In

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/

VB, SQL: ...WHERE Mitglieder.geb='1978-08-26' doesn't work

cordset( _ "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]) __

VB, SQL: ...WHERE Mitglieder.geb='1978-08-26' doesn't work

ime-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.*

Server Tuning

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 postin

Re: XML support under mySQL

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 ---

Re: XML support under mySQL

s. "18000"> 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 ---

Re: create table

le 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 reques

Re: MySQL 3.23.32 / SuSE Linux 7.1 / php and normal user

e 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.c

Re: XML support under mySQL

e 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://w

Re: XML support under mySQL

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 ar