Re: Mysql and Aix 5.3
Hello Sébastien, all! Sébastien Lardière wrote: Hello I'm looking for mysql 4.1 for Aix 5.3. I found mysql for aix 5.2 but no where 5.3 package. Is there anyway to provide this version ? Sorry, no - the build machine used by MySQL for AIX is running AIX 5.2. You can rely on IBM's upward compatibility and use binaries generated for AIX 5.2 on a 5.3 system. Should this lead to any problems, then please tell us about it. Other things : the final user use 4.1.10a with Linux and want the same version for Aix. Why this version of Mysql doesn't exists anymore ? We were running out of space on the disk system used for publishing packages, so we had to temporarily remove the oldest packages (assuming they would not be searched for) until we moved everything to a new, larger disk system and integrated that into all the links and mounts. I am sorry that our assumptions (it would not be searched during the restructure period) were wrong - we had hoped we could do it without anybody suffering! I cannot yet give an exact date when it will be all done (there are several teams involved, and they must do their steps in sequence), but I hope the archive will be back online sometime next week. Regards, Joerg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql and Aix 5.3
Joerg Bruehe a écrit : Hello Sébastien, all! Sébastien Lardière wrote: Hello I'm looking for mysql 4.1 for Aix 5.3. I found mysql for aix 5.2 but no where 5.3 package. Is there anyway to provide this version ? Sorry, no - the build machine used by MySQL for AIX is running AIX 5.2. You can rely on IBM's upward compatibility and use binaries generated for AIX 5.2 on a 5.3 system. Should this lead to any problems, then please tell us about it. Other things : the final user use 4.1.10a with Linux and want the same version for Aix. Why this version of Mysql doesn't exists anymore ? We were running out of space on the disk system used for publishing packages, so we had to temporarily remove the oldest packages (assuming they would not be searched for) until we moved everything to a new, larger disk system and integrated that into all the links and mounts. I am sorry that our assumptions (it would not be searched during the restructure period) were wrong - we had hoped we could do it without anybody suffering! I cannot yet give an exact date when it will be all done (there are several teams involved, and they must do their steps in sequence), but I hope the archive will be back online sometime next week. Ok, thanks for your answer, -- Sébastien -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: order field of a table
...just realize this might get you more confused than clearing it out for you, but what the hey. Thanks, your answers surely help. But I was also interested in the question how to optimize the whole process. Say: In a php script, I want to delete an employee-record passing his ID to the script. So I have to: Query 1 : Find out his importance-value from his ID Query 2 : Delete the record based on ID Query 3: Decrement the other's importance-value field I just wanted to make sure if this is the way to do it or if I'm missing something. Is this safe with multi user ? Would you use transactions? Thank you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The number of left join in one SQL statement.
Hello, my name is Takanobu Kawabe. I have some questions about left join SQL statement. I want to join some tables, and using left join statement . the system is the following. I use two machines. I created the same databases and tables on both machines. OS ： Debian Linux the newest stable 3.1 Server ： Apache 2.0 MySQL ： 5.0.20 PHP ： 5.1.4 OS ： WindowsXP Server ： Apache2.0 MySQL ： 5.0.19 PHP ： 5.1.2 And I considered the following SQL statement to select some columns from some tables using left join. SELECT `MST`.`no`, `MST`.`denhyono`, `GUS`.`TANI` AS `GUS`, `SUIDO`.`TANI` AS `SUIDO`, `DENKI`.`TANI` AS `DENKI`, `SYOKUIN1`.`SYOKUINNAME` AS `SYOKUIN1`, `SYOKUIN2`.`SYOKUINNAME` AS `SYOKUIN2`, `TANTOSYA`.`TANTOSYANAME` AS `TANTOSYA` FROM `MST` Left Join `TANIMST` AS `GUS` ON `MST`.`GUSno` = `GUS`.`no` Left Join `TANIMST` AS `SUIDO` ON `MST`.`SUIDOno` = `SUIDO`.`no` Left Join `TANIMST` AS `DENKI` ON `MST`.`DENKIno` = `DENKI`.`no` Left Join `SYOKUINMST` AS `SYOKUIN1` ON `MST`.`SYOKUINno1` = `SYOKUIN1`.`no` Left Join `SYOKUINMST` AS `SYOKUIN2` ON `MST`.`SYOKUINno2` = `SYOKUIN2`.`no` Left Join `SYOKUINMST` AS `TANTOSYA` ON `MST`.`TANTOSYAno` = `TANTOSYA`.`no`; - I tried this statement without error. But Ihave some questions. 1.How many left join keywords can I use in one SQL statement if there are 5000 datas in one table? 2. when some customers use this query, can they read this query exactly? 3. Will the above query speed become slowly if there are 5000 datas in one table? Will the processing efficiency improve if I use multiple SQL statement? 4.Is there any other effective SQL statement I can get better processing efficiency?
Re: The number of left join in one SQL statement.
Takanobu Kawabe schrieb: Hello, my name is Takanobu Kawabe. こんいちわ孝信さん：） I have some questions about left join SQL statement. I want to join some tables, and using left join statement . the system is the following. I use two machines. I created the same databases and tables on both machines. OS ： Debian Linux the newest stable 3.1 Server ： Apache 2.0 MySQL ： 5.0.20 PHP ： 5.1.4 OS ： WindowsXP Server ： Apache2.0 MySQL ： 5.0.19 PHP ： 5.1.2 And I considered the following SQL statement to select some columns from some tables using left join. SELECT `MST`.`no`, `MST`.`denhyono`, `GUS`.`TANI` AS `GUS`, `SUIDO`.`TANI` AS `SUIDO`, `DENKI`.`TANI` AS `DENKI`, `SYOKUIN1`.`SYOKUINNAME` AS `SYOKUIN1`, `SYOKUIN2`.`SYOKUINNAME` AS `SYOKUIN2`, `TANTOSYA`.`TANTOSYANAME` AS `TANTOSYA` FROM `MST` Left Join `TANIMST` AS `GUS` ON `MST`.`GUSno` = `GUS`.`no` Left Join `TANIMST` AS `SUIDO` ON `MST`.`SUIDOno` = `SUIDO`.`no` Left Join `TANIMST` AS `DENKI` ON `MST`.`DENKIno` = `DENKI`.`no` Left Join `SYOKUINMST` AS `SYOKUIN1` ON `MST`.`SYOKUINno1` = `SYOKUIN1`.`no` Left Join `SYOKUINMST` AS `SYOKUIN2` ON `MST`.`SYOKUINno2` = `SYOKUIN2`.`no` Left Join `SYOKUINMST` AS `TANTOSYA` ON `MST`.`TANTOSYAno` = `TANTOSYA`.`no`; - I tried this statement without error. But Ihave some questions. 1.How many left join keywords can I use in one SQL statement if there are 5000 datas in one table? As much as you like. there are no limitations. 2. when some customers use this query, can they read this query exactly? Depends on the MySQL knowledge of your customer. But when they are good in SQL they shouldn't have any problem with it. 3. Will the above query speed become slowly if there are 5000 datas in one table? Set indizes. This way your queries will speed up. Will the processing efficiency improve if I use multiple SQL statement? Always depends on the process. There are processes where multiple SQL queries come in handy. 4.Is there any other effective SQL statement I can get better processing efficiency? The beast way would be to start reading the optimization of MySQL: http://dev.mysql.com/doc/refman/5.0/en/optimization.html Here you get a lot of helpful omtimizations for your queries. それじゃ。 Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: *****SPAM***** Re: Aborted clients status variable seems increasing -how to tune the server to reduce the same
Thanks Brent. I increased my wait_timeout.But now also my aborted clients seems increasing than connections.As u said most of my front end code use mysql persistent connect only.Can u clarify my one more doubt that when to use persistent connect and when to use mysql_connect and their advantages and disadvantages. Now my connections is 1509317 and my aborted clients is 1747365.Is it a problem?Please let me know. -Lakshmi.M.P. Brent Baisley wrote: You have your wait_timeout set to 5 seconds. Which means a client connection will be aborted after 5 seconds of inactivity. Since your aborted connects is 0, you don't seem to having a problem connecting, just staying connected. 5 seconds is kind of low (default is 28800 I think), but is fine if you have a reason for setting it so low. Your threads_created number is fairly low, so you're not having a problem of constantly creating threads to handle connections, which can really hurt. I don't know what your front end is written in. But you may want to increase the wait_timeout or call mysql_close when you are done with your database connection. I'm guessing that since your aborted clients number is higher than the number of connections, you're using persistant connections. Which means connections are reused if still available. - Original Message - From: Lakshmi [EMAIL PROTECTED] To: mysql@lists.mysql.com Cc: [EMAIL PROTECTED] Sent: Thursday, June 15, 2006 3:42 AM Subject: Aborted clients status variable seems increasing -how to tune the server to reduce the same Hi, The aborted clients seems to be increasing than the connections made. Any solution Aborted_clients 67529 where as the connection made is 60462 . Here is my server details, Server : Red Hat Enterprise Linux AS release 4 (Nahant) Mysql Server version : 4.1.15-log *my.cnf variables:* key_buffer=350M max_allowed_packet=32M table_cache=1024 thread_cache_size=400 sort_buffer=64K net_buffer_length=64K read_buffer_size = 64K thread_stack=96K query_cache_size=64M max_connections=1000 max_connect_errors=100 max_user_connections=900 wait_timeout=5 record_buffer=5M thread_concurrency=8 myisam_sort_buffer_size=64M set-variable = innodb_buffer_pool_size=200M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 *Status Variables: *Aborted_clients 67529 Aborted_connects0 Connections 60462 Key_blocks_unused 275836 Key_blocks_used 42002 Key_read_requests 1836872 Key_reads 42002 Key_write_requests 3704 Key_writes 3701 Max_used_connections205 Open_tables 84 Opened_tables 90 Qcache_free_blocks 4451 Qcache_free_memory 54838840 Qcache_hits 18034 Qcache_inserts 66383 Qcache_lowmem_prunes0 Qcache_not_cached 11320 Qcache_queries_in_cache 11792 Questions 269605 Threads_cached 81 Threads_connected 124 Threads_created 205 Threads_running 4* -Lakshmi.M.P. MYSQL DBA, Sify Limited. ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. www.sifymax.com Get to see what's happening in your favourite City on Bangalore Live! www.bangalorelive.in -- 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]
Strange Illegal mix of collations error
Hello,
could someone help me to explain and resolve this error? Or maybe it is
a bug.
DROP TABLE IF EXISTS `test`.`karty`;
CREATE TABLE `test`.`karty` (
`ICO` char(12) collate latin2_czech_cs NOT NULL default '',
`CisloProvozu` char(6) collate latin2_czech_cs NOT NULL default '',
`CisPrac` char(10) collate latin2_czech_cs NOT NULL default '',
`TypKarty` smallint(6) NOT NULL default '0',
`Vyhotoveni` smallint(6) NOT NULL default '0',
`Jmeno` char(20) collate latin2_czech_cs NOT NULL default '',
`CisloProgramu` smallint(6) NOT NULL default '0',
`Embasing` char(7) collate latin2_czech_cs NOT NULL default '',
`VnitrniCislo` char(15) character set latin2 default NULL,
`Stanice` char(3) collate latin2_czech_cs NOT NULL default '',
PRIMARY KEY (`ICO`,`CisloProvozu`,`CisPrac`,`TypKarty`,`Vyhotoveni`),
UNIQUE KEY `VnitrniCislo` (`VnitrniCislo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;
DROP TABLE IF EXISTS `test`.`karty_imp_tmp`;
CREATE TABLE `test`.`karty_imp_tmp` (
`PracJmeno` char(30) collate latin2_czech_cs NOT NULL default '',
`VnitrniCislo` char(15) collate latin2_czech_cs default NULL,
`CisPrac` char(10) collate latin2_czech_cs NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;
INSERT INTO test.karty
values('','01','01',10,1,'test',0,'R0','9001AB12D3E','');
INSERT INTO test.karty_imp_tmp
values('test','9001AB12D3E','01');
SELECT k.*, kt.* FROM karty k JOIN karty_imp_tmp kt USING (vnitrnicislo);
returns error: Illegal mix of collations (latin2_general_ci,IMPLICIT)
and (latin2_czech_cs,IMPLICIT) for operation '='
I don't know where latin2_general_ci collation comes from.
OS WinXP, MySQL 4.1.15-nt-log
Thanks in advance
Dusan Pavlica
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Strange Illegal mix of collations error
Dušan Pavlica schrieb:
Hello,
could someone help me to explain and resolve this error? Or maybe it is
a bug.
DROP TABLE IF EXISTS `test`.`karty`;
CREATE TABLE `test`.`karty` (
`ICO` char(12) collate latin2_czech_cs NOT NULL default '',
`CisloProvozu` char(6) collate latin2_czech_cs NOT NULL default '',
`CisPrac` char(10) collate latin2_czech_cs NOT NULL default '',
`TypKarty` smallint(6) NOT NULL default '0',
`Vyhotoveni` smallint(6) NOT NULL default '0',
`Jmeno` char(20) collate latin2_czech_cs NOT NULL default '',
`CisloProgramu` smallint(6) NOT NULL default '0',
`Embasing` char(7) collate latin2_czech_cs NOT NULL default '',
`VnitrniCislo` char(15) character set latin2 default NULL,
`Stanice` char(3) collate latin2_czech_cs NOT NULL default '',
PRIMARY KEY (`ICO`,`CisloProvozu`,`CisPrac`,`TypKarty`,`Vyhotoveni`),
UNIQUE KEY `VnitrniCislo` (`VnitrniCislo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;
DROP TABLE IF EXISTS `test`.`karty_imp_tmp`;
CREATE TABLE `test`.`karty_imp_tmp` (
`PracJmeno` char(30) collate latin2_czech_cs NOT NULL default '',
`VnitrniCislo` char(15) collate latin2_czech_cs default NULL,
`CisPrac` char(10) collate latin2_czech_cs NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;
INSERT INTO test.karty
values('','01','01',10,1,'test',0,'R0','9001AB12D3E','');
INSERT INTO test.karty_imp_tmp
values('test','9001AB12D3E','01');
SELECT k.*, kt.* FROM karty k JOIN karty_imp_tmp kt USING (vnitrnicislo);
returns error: Illegal mix of collations (latin2_general_ci,IMPLICIT)
and (latin2_czech_cs,IMPLICIT) for operation '='
I don't know where latin2_general_ci collation comes from.
Well one table or the column has this collation.
Check your structures.
= `VnitrniCislo` char(15) character set latin2 default NULL,
shouldn it be
= `VnitrniCislo` char(15) collate latin2_czech_cs default NULL,
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Strange Illegal mix of collations error
flyerheaven - Barry Krein napsal(a):
Dušan Pavlica schrieb:
Barry napsal(a):
Dušan Pavlica schrieb:
Hello,
could someone help me to explain and resolve this error? Or maybe
it is a bug.
DROP TABLE IF EXISTS `test`.`karty`;
CREATE TABLE `test`.`karty` (
`ICO` char(12) collate latin2_czech_cs NOT NULL default '',
`CisloProvozu` char(6) collate latin2_czech_cs NOT NULL default '',
`CisPrac` char(10) collate latin2_czech_cs NOT NULL default '',
`TypKarty` smallint(6) NOT NULL default '0',
`Vyhotoveni` smallint(6) NOT NULL default '0',
`Jmeno` char(20) collate latin2_czech_cs NOT NULL default '',
`CisloProgramu` smallint(6) NOT NULL default '0',
`Embasing` char(7) collate latin2_czech_cs NOT NULL default '',
`VnitrniCislo` char(15) character set latin2 default NULL,
`Stanice` char(3) collate latin2_czech_cs NOT NULL default '',
PRIMARY KEY
(`ICO`,`CisloProvozu`,`CisPrac`,`TypKarty`,`Vyhotoveni`),
UNIQUE KEY `VnitrniCislo` (`VnitrniCislo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;
DROP TABLE IF EXISTS `test`.`karty_imp_tmp`;
CREATE TABLE `test`.`karty_imp_tmp` (
`PracJmeno` char(30) collate latin2_czech_cs NOT NULL default '',
`VnitrniCislo` char(15) collate latin2_czech_cs default NULL,
`CisPrac` char(10) collate latin2_czech_cs NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;
INSERT INTO test.karty
values('','01','01',10,1,'test',0,'R0','9001AB12D3E','');
INSERT INTO test.karty_imp_tmp
values('test','9001AB12D3E','01');
SELECT k.*, kt.* FROM karty k JOIN karty_imp_tmp kt USING
(vnitrnicislo);
returns error: Illegal mix of collations
(latin2_general_ci,IMPLICIT) and (latin2_czech_cs,IMPLICIT) for
operation '='
I don't know where latin2_general_ci collation comes from.
Well one table or the column has this collation.
Check your structures.
= `VnitrniCislo` char(15) character set latin2 default NULL,
shouldn it be
= `VnitrniCislo` char(15) collate latin2_czech_cs default NULL,
Barry
I have seen it too and checked both structures in MySQL Table Editor
and both columns had exactly same definitions. And both tables have
same character set and collation
Dusan
Nah look at your structrue:
CisloProgramu` smallint(6) NOT NULL default '0',
`Embasing` char(7) collate latin2_czech_cs NOT NULL default '',
`VnitrniCislo` char(15) character set latin2 default NULL,
`Stanice` char(3) collate latin2_czech_cs NOT NULL default '',
Here its just character set latin2
CREATE TABLE `test`.`karty_imp_tmp` (
`PracJmeno` char(30) collate latin2_czech_cs NOT NULL default '',
`VnitrniCislo` char(15) collate latin2_czech_cs default NULL,
And here is it collate latin2_czech_cs
That's causing the error.
Barry
You are right. If I create tables where both columns VnitrniCislo have
exactly same definitions, it doesn't throw the error.
Bug must be in the MySQL Table Editor which shows in column details
wrong collations
Thanks, Barry.
Dusan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MyMonitor - A novel SQL monitor tool for MySQL release 1
The first version of MyMonitor is now available in source form on sourceforge and can be downloaded from: http://sourceforge.net/projects/mymonitor The reason for this tool is simple, and it's also a bit different from other similar tools (at least the ones I've looked at). The tool gets the output from SHOW PROCESSLIST repeatedly and does some magic to this to count the number of executions and execution time. The difference is in how it handles the SQL statement text. Before somparing the SQL text of a statment to the statements in the previous run of SHOW PROCESSLIST or to the SQL in an internal list of frequently accessed SQL statements, it removes any references to literal values. So the these statements: SELECT * FROM customer WHERE cust_id = 123; and SELECT * FROM customer WHERE cust_id = 123; Which in SHOW PROCESSLIST is shown as 2 distinct statements are handled as two executions of the same statement: SELECT * FROM customer WHERE cust_id = ?, which is usually how it works anyway. The output through ncurses, a bit like top. The collected statements may also be written to file, and there are a bunch of other settings, and there is also documentation in shape of a User Guide in PDF format. The current version is considered a beta, so comments on porting are more than welcome. I have so far only run it on a couple of Linux'es, but there is more to come. ncurses library is required, as well as the MySQL Client library of course. Enjoy, and comments are welcome, I hope this tool will turn out useful -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer /_/ /_/\_, /___/\___\_\___/ Stockholm ___/ www.mysql.com Cellphone: +46 708 608121 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyMonitor - A novel SQL monitor tool for MySQL release 1
Is there any way with this tool, or some other tool, to monitor the amount of data (in KBytes or the likes) returned by a particular query? - John The first version of MyMonitor is now available in source form on sourceforge and can be downloaded from: http://sourceforge.net/projects/mymonitor The reason for this tool is simple, and it's also a bit different from other similar tools (at least the ones I've looked at). The tool gets the output from SHOW PROCESSLIST repeatedly and does some magic to this to count the number of executions and execution time. The difference is in how it handles the SQL statement text. Before somparing the SQL text of a statment to the statements in the previous run of SHOW PROCESSLIST or to the SQL in an internal list of frequently accessed SQL statements, it removes any references to literal values. So the these statements: SELECT * FROM customer WHERE cust_id = 123; and SELECT * FROM customer WHERE cust_id = 123; Which in SHOW PROCESSLIST is shown as 2 distinct statements are handled as two executions of the same statement: SELECT * FROM customer WHERE cust_id = ?, which is usually how it works anyway. The output through ncurses, a bit like top. The collected statements may also be written to file, and there are a bunch of other settings, and there is also documentation in shape of a User Guide in PDF format. The current version is considered a beta, so comments on porting are more than welcome. I have so far only run it on a couple of Linux'es, but there is more to come. ncurses library is required, as well as the MySQL Client library of course. Enjoy, and comments are welcome, I hope this tool will turn out useful -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer /_/ /_/\_, /___/\___\_\___/ Stockholm ___/ www.mysql.com Cellphone: +46 708 608121 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- --- John May : President http://www.pointinspace.com Point In Space Internet Solutions [EMAIL PROTECTED] Professional Lasso / PHP / MySQL / FileMaker Pro Hosting -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
my.cnf / mysqld logging
Hey there, I inherited a couple of servers that are in production but I noticed that there's not active logging for mysql on any of them. I looked and they don't have an active my.cnf file any where on the machines. One machine is running mysql 4.1.5 and the other is running mysql 5.0.18 When I ran a ps -ef on the machines I saw this for both /usr/local/mysql/bin/mysqld defaults-extra-file=/usr/local/mysql/data/my.cnf so I went and I put a my.cnf right where it was looking for it. Stopped/Started the mysql server and I'm still not seeing any logging happening for the mysql servers. Perhaps I'm messing this up? I want them to log everything to /var/log/mysqld.log and in the my.cnf I have the line: log = /var/log/mysqld.log Can anyone tell me where I'm messing this up or what is wrong? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: my.cnf / mysqld logging
Hi, Try to enable query log. Thanks Regards Dilipkumar [EMAIL PROTECTED]: Hey there, I inherited a couple of servers that are in production but I noticed that there\'s not active logging for mysql on any of them. I looked and they don\'t have an active my.cnf file any where on the machines. One machine is running mysql 4.1.5 and the other is running mysql 5.0.18 When I ran a ps -ef on the machines I saw this for both /usr/local/mysql/bin/mysqld defaults-extra-file=/usr/local/mysql/data/my.cnf so I went and I put a my.cnf right where it was looking for it. Stopped/Started the mysql server and I\'m still not seeing any logging happening for the mysql servers. Perhaps I\'m messing this up? I want them to log everything to /var/log/mysqld.log and in the my.cnf I have the line: log = /var/log/mysqld.log Can anyone tell me where I\'m messing this up or what is wrong? -- 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]
Re: MyMonitor - A novel SQL monitor tool for MySQL release 1
John! No, that is not within the scope of this tool. One could imaging that is was possible though, but without some effort. This information is not available in the show processlist, so some other means needs to be figured out. For a seelct one could always reissue the statement (not all statements, but the ones one is interested in) and count the # of rows returned. This is a rather terrible kludge though. The best you get right now is the original SQL text of the last instance of a particular query. In the example below, what is displayed as a query is SELECT * FROM customer WHERE cust_id = ?, but there is an option to show the last instance of the real query (SELECT * FROM customer WHERE cust_id = 456). This is rather far away from what you are looking for I guess. If I get some idea of where to find this information, I'd be happy to integrate this featuer into an upcoming version of the tool though. Best regards Anders Karlsson John May wrote: Is there any way with this tool, or some other tool, to monitor the amount of data (in KBytes or the likes) returned by a particular query? - John The first version of MyMonitor is now available in source form on sourceforge and can be downloaded from: http://sourceforge.net/projects/mymonitor The reason for this tool is simple, and it's also a bit different from other similar tools (at least the ones I've looked at). The tool gets the output from SHOW PROCESSLIST repeatedly and does some magic to this to count the number of executions and execution time. The difference is in how it handles the SQL statement text. Before somparing the SQL text of a statment to the statements in the previous run of SHOW PROCESSLIST or to the SQL in an internal list of frequently accessed SQL statements, it removes any references to literal values. So the these statements: SELECT * FROM customer WHERE cust_id = 123; and SELECT * FROM customer WHERE cust_id = 123; Which in SHOW PROCESSLIST is shown as 2 distinct statements are handled as two executions of the same statement: SELECT * FROM customer WHERE cust_id = ?, which is usually how it works anyway. The output through ncurses, a bit like top. The collected statements may also be written to file, and there are a bunch of other settings, and there is also documentation in shape of a User Guide in PDF format. The current version is considered a beta, so comments on porting are more than welcome. I have so far only run it on a couple of Linux'es, but there is more to come. ncurses library is required, as well as the MySQL Client library of course. Enjoy, and comments are welcome, I hope this tool will turn out useful -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer /_/ /_/\_, /___/\___\_\___/ Stockholm ___/ www.mysql.com Cellphone: +46 708 608121 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer /_/ /_/\_, /___/\___\_\___/ Stockholm ___/ www.mysql.com Cellphone: +46 708 608121 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyMonitor - A novel SQL monitor tool for MySQL release 1
Also, I need to learn how to spell. The docs arn't as bad as the language in the reply below. /Karlssons spellchecker Anders Karlsson wrote: John! No, that is not within the scope of this tool. One could imaging that is was possible though, but without some No, that is not within the scope of this tool. One could imagine that is was possible though, but not without some effort. This information is not available in the show processlist, so some other means needs to be figured out. For a seelct one could always reissue the statement (not all statements, but the ones one is interested in) and count the # of rows returned. This is a rather terrible kludge though. The best you get right now is the original SQL text of the last instance of a particular query. In the example below, what is displayed as a query is SELECT * FROM customer WHERE cust_id = ?, but there is an option to show the last instance of the real query (SELECT * FROM customer WHERE cust_id = 456). This is rather far away from what you are looking for I guess. If I get some idea of where to find this information, I'd be happy to integrate this featuer into an upcoming version of the tool though. Best regards Anders Karlsson John May wrote: Is there any way with this tool, or some other tool, to monitor the amount of data (in KBytes or the likes) returned by a particular query? - John The first version of MyMonitor is now available in source form on sourceforge and can be downloaded from: http://sourceforge.net/projects/mymonitor The reason for this tool is simple, and it's also a bit different from other similar tools (at least the ones I've looked at). The tool gets the output from SHOW PROCESSLIST repeatedly and does some magic to this to count the number of executions and execution time. The difference is in how it handles the SQL statement text. Before somparing the SQL text of a statment to the statements in the previous run of SHOW PROCESSLIST or to the SQL in an internal list of frequently accessed SQL statements, it removes any references to literal values. So the these statements: SELECT * FROM customer WHERE cust_id = 123; and SELECT * FROM customer WHERE cust_id = 123; Which in SHOW PROCESSLIST is shown as 2 distinct statements are handled as two executions of the same statement: SELECT * FROM customer WHERE cust_id = ?, which is usually how it works anyway. The output through ncurses, a bit like top. The collected statements may also be written to file, and there are a bunch of other settings, and there is also documentation in shape of a User Guide in PDF format. The current version is considered a beta, so comments on porting are more than welcome. I have so far only run it on a couple of Linux'es, but there is more to come. ncurses library is required, as well as the MySQL Client library of course. Enjoy, and comments are welcome, I hope this tool will turn out useful -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer /_/ /_/\_, /___/\___\_\___/ Stockholm ___/ www.mysql.com Cellphone: +46 708 608121 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer /_/ /_/\_, /___/\___\_\___/ Stockholm ___/ www.mysql.com Cellphone: +46 708 608121 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: my.cnf / mysqld logging
How would I do that? I'm still a novice when it comes to many aspects of mysql. [EMAIL PROTECTED] wrote: Hi, Try to enable query log. Thanks Regards Dilipkumar [EMAIL PROTECTED]: Hey there, I inherited a couple of servers that are in production but I noticed that there\'s not active logging for mysql on any of them. I looked and they don\'t have an active my.cnf file any where on the machines. One machine is running mysql 4.1.5 and the other is running mysql 5.0.18 When I ran a ps -ef on the machines I saw this for both /usr/local/mysql/bin/mysqld defaults-extra-file=/usr/local/mysql/data/my.cnf so I went and I put a my.cnf right where it was looking for it. Stopped/Started the mysql server and I\'m still not seeing any logging happening for the mysql servers. Perhaps I\'m messing this up? I want them to log everything to /var/log/mysqld.log and in the my.cnf I have the line: log = /var/log/mysqld.log Can anyone tell me where I\'m messing this up or what is wrong? -- 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]
Re: my.cnf / mysqld logging
Hi, log-queries=/path/ Tom Ray [Lists] wrote: How would I do that? I'm still a novice when it comes to many aspects of mysql. [EMAIL PROTECTED] wrote: Hi, Try to enable query log. Thanks Regards Dilipkumar [EMAIL PROTECTED]: Hey there, I inherited a couple of servers that are in production but I noticed that there\'s not active logging for mysql on any of them. I looked and they don\'t have an active my.cnf file any where on the machines. One machine is running mysql 4.1.5 and the other is running mysql 5.0.18 When I ran a ps -ef on the machines I saw this for both /usr/local/mysql/bin/mysqld defaults-extra-file=/usr/local/mysql/data/my.cnf so I went and I put a my.cnf right where it was looking for it. Stopped/Started the mysql server and I\'m still not seeing any logging happening for the mysql servers. Perhaps I\'m messing this up? I want them to log everything to /var/log/mysqld.log and in the my.cnf I have the line: log = /var/log/mysqld.log Can anyone tell me where I\'m messing this up or what is wrong? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Thanks Regards, Dilipkumar DBA Support ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. www.sifymax.com Get to see what's happening in your favourite City on Bangalore Live! www.bangalorelive.in -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyMonitor - A novel SQL monitor tool for MySQL release 1
Sounds great. Being able to track the amount of data from requests - even having something like a slow query log but a large query log or the likes - would make a BIG difference in tracking down performance issues. Thanks! - John At 4:02 PM +0200 6/16/06, Anders Karlsson wrote: John! No, that is not within the scope of this tool. One could imaging that is was possible though, but without some effort. This information is not available in the show processlist, so some other means needs to be figured out. For a seelct one could always reissue the statement (not all statements, but the ones one is interested in) and count the # of rows returned. This is a rather terrible kludge though. The best you get right now is the original SQL text of the last instance of a particular query. In the example below, what is displayed as a query is SELECT * FROM customer WHERE cust_id = ?, but there is an option to show the last instance of the real query (SELECT * FROM customer WHERE cust_id = 456). This is rather far away from what you are looking for I guess. If I get some idea of where to find this information, I'd be happy to integrate this featuer into an upcoming version of the tool though. Best regards Anders Karlsson John May wrote: Is there any way with this tool, or some other tool, to monitor the amount of data (in KBytes or the likes) returned by a particular query? - John The first version of MyMonitor is now available in source form on sourceforge and can be downloaded from: http://sourceforge.net/projects/mymonitor The reason for this tool is simple, and it's also a bit different from other similar tools (at least the ones I've looked at). The tool gets the output from SHOW PROCESSLIST repeatedly and does some magic to this to count the number of executions and execution time. The difference is in how it handles the SQL statement text. Before somparing the SQL text of a statment to the statements in the previous run of SHOW PROCESSLIST or to the SQL in an internal list of frequently accessed SQL statements, it removes any references to literal values. So the these statements: SELECT * FROM customer WHERE cust_id = 123; and SELECT * FROM customer WHERE cust_id = 123; Which in SHOW PROCESSLIST is shown as 2 distinct statements are handled as two executions of the same statement: SELECT * FROM customer WHERE cust_id = ?, which is usually how it works anyway. The output through ncurses, a bit like top. The collected statements may also be written to file, and there are a bunch of other settings, and there is also documentation in shape of a User Guide in PDF format. The current version is considered a beta, so comments on porting are more than welcome. I have so far only run it on a couple of Linux'es, but there is more to come. ncurses library is required, as well as the MySQL Client library of course. Enjoy, and comments are welcome, I hope this tool will turn out useful -- --- John May : President http://www.pointinspace.com Point In Space Internet Solutions [EMAIL PROTECTED] Professional Lasso / PHP / MySQL / FileMaker Pro Hosting -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error while displaying Multilanguages
Hi all, I am having a problem with JSP while trying to read the data from mysql database and displaying it on the screen.It has been diplayed as ?? rather the actual data.May i know whether the problem is with JSP or MYSQL.Where the changes to be made in order get it work correctly.I am sure that i have multilanguage option set while installing mysql configuration settings. Regards, venu.
Error 1045 - Access denied
I have searched the MySQL Administrator forum for help on this, but no joy. When I try to conect to a database on Dreamhost, using MySQL Administrator, I get this error, with a red X in a Windows dialog box: (The name of the database and and user are changed) --- Could not connect to the specified instance. MySQL Error Number 1045 Access denied for user'xxxtest'@'pc-24-222-199-71.cpe.rushcomm.ca'(using password: YES) If you want to check the network connection, please click the PING button [OK] [PING] -- It pings OK, and I can use phpMyAdmin, I just wanted to try a more direct tool. Dreamhost has not been a lot of help. I suspect it's because MySQL Administrator is too powerful. Regards - Miles Thompson -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.394 / Virus Database: 268.9.0/366 - Release Date: 6/15/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: my.cnf / mysqld logging
Hi Tom - In your my.cnf file, you need to specify that the setting you put in is for mysqld, the server process. Your file should look like so: [mysqld] log = /var/log/mysqld.log MySQL generally logs high-level info to files in the data directory: look for a file called hostname.err Question: are you sure you want to log *everything* ? MySQL does have a general log feature, but bear in mind that it is a log of every query (insert update select delete etc) that happens, including any inserted data, so it can become very large very quickly. I had this happen on a production server, and it wasn't really that fun. See http://dev.mysql.com/doc/refman/5.0/en/query-log.html for more info MySQL also offers a slow query log, which can be helpful in starting a performance/optimization process. To enable, put this in your my.cnf file under the [mysqld] section: log-slow-queries=/path/to/logfile See http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html HTH, Dan Tom Ray [Lists] wrote: Hey there, I inherited a couple of servers that are in production but I noticed that there's not active logging for mysql on any of them. I looked and they don't have an active my.cnf file any where on the machines. One machine is running mysql 4.1.5 and the other is running mysql 5.0.18 When I ran a ps -ef on the machines I saw this for both /usr/local/mysql/bin/mysqld defaults-extra-file=/usr/local/mysql/data/my.cnf so I went and I put a my.cnf right where it was looking for it. Stopped/Started the mysql server and I'm still not seeing any logging happening for the mysql servers. Perhaps I'm messing this up? I want them to log everything to /var/log/mysqld.log and in the my.cnf I have the line: log = /var/log/mysqld.log Can anyone tell me where I'm messing this up or what is wrong? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1045 - Access denied
Miles, can you access the remote database from any other tools on your local machine? mysql command line, etc. You state you can use phpmyadmin, but is that installed at your hosting provider? It's not unusual for hosting providers to lock down their database hosts to only allow access from other hosts on the provider's network. Added security, added control. My provider, pair Networks, by default locks the dbs down to their network only, but I have the option to open them up. Dan Miles Thompson wrote: I have searched the MySQL Administrator forum for help on this, but no joy. When I try to conect to a database on Dreamhost, using MySQL Administrator, I get this error, with a red X in a Windows dialog box: (The name of the database and and user are changed) --- Could not connect to the specified instance. MySQL Error Number 1045 Access denied for user'xxxtest'@'pc-24-222-199-71.cpe.rushcomm.ca'(using password: YES) If you want to check the network connection, please click the PING button [OK] [PING] -- It pings OK, and I can use phpMyAdmin, I just wanted to try a more direct tool. Dreamhost has not been a lot of help. I suspect it's because MySQL Administrator is too powerful. Regards - Miles Thompson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyMonitor - A novel SQL monitor tool for MySQL release 1
Anders I want this for Windows? how do I do it? Anders Karlsson escribió: The first version of MyMonitor is now available in source form on sourceforge and can be downloaded from: http://sourceforge.net/projects/mymonitor The reason for this tool is simple, and it's also a bit different from other similar tools (at least the ones I've looked at). The tool gets the output from SHOW PROCESSLIST repeatedly and does some magic to this to count the number of executions and execution time. The difference is in how it handles the SQL statement text. Before somparing the SQL text of a statment to the statements in the previous run of SHOW PROCESSLIST or to the SQL in an internal list of frequently accessed SQL statements, it removes any references to literal values. So the these statements: SELECT * FROM customer WHERE cust_id = 123; and SELECT * FROM customer WHERE cust_id = 123; Which in SHOW PROCESSLIST is shown as 2 distinct statements are handled as two executions of the same statement: SELECT * FROM customer WHERE cust_id = ?, which is usually how it works anyway. The output through ncurses, a bit like top. The collected statements may also be written to file, and there are a bunch of other settings, and there is also documentation in shape of a User Guide in PDF format. The current version is considered a beta, so comments on porting are more than welcome. I have so far only run it on a couple of Linux'es, but there is more to come. ncurses library is required, as well as the MySQL Client library of course. Enjoy, and comments are welcome, I hope this tool will turn out useful -- Saludos cordiales. Ing. Gabriel Mahiques Dto. Control de Gestión ELECTROINGENIERA S.A. Telefono: 474 1414 Uspallata 1461. Barrio San Martín. CP: X5008HSH Córdoba. República Argentina. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1045 - Access denied
Dan, I believe Dreamhost has it MySQL locked down so that only they have primary access, and yes phpMyAdmin is installed on their system. It would be .v. difficult for them to give me rights. g This is sort of off-topic, but hub.org, which operates out of Wolfville, NS, has shut down the central MySQL database for all their clients and each client now has a private instance running in the virtual host. V. nice. Thanks for having a look. Miles At 12:32 PM 6/16/2006, Dan Buettner wrote: Miles, can you access the remote database from any other tools on your local machine? mysql command line, etc. You state you can use phpmyadmin, but is that installed at your hosting provider? It's not unusual for hosting providers to lock down their database hosts to only allow access from other hosts on the provider's network. Added security, added control. My provider, pair Networks, by default locks the dbs down to their network only, but I have the option to open them up. Dan Miles Thompson wrote: I have searched the MySQL Administrator forum for help on this, but no joy. When I try to conect to a database on Dreamhost, using MySQL Administrator, I get this error, with a red X in a Windows dialog box: (The name of the database and and user are changed) --- Could not connect to the specified instance. MySQL Error Number 1045 Access denied for user'xxxtest'@'pc-24-222-199-71.cpe.rushcomm.ca'(using password: YES) If you want to check the network connection, please click the PING button [OK] [PING] -- It pings OK, and I can use phpMyAdmin, I just wanted to try a more direct tool. Dreamhost has not been a lot of help. I suspect it's because MySQL Administrator is too powerful. Regards - Miles Thompson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.394 / Virus Database: 268.9.0/366 - Release Date: 6/15/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Good day
Message de la Plate-Forme SECURITE de l'Universite Sidi Med Ben Abdallah de Fes - USMBA - ALERT!!! This e-mail contained one or more infected files. The following attachments were infected and have been repaired: No attachments are in this category. The following infected attachments were deleted: 1. body.pif: [EMAIL PROTECTED] The following infected attachments were blocked because of Mail Policy violations: No attachments are in this category. You may wish to contact the sender to inform them about their infections. Thank you, Your ISP Equipe USMBA Original message text follows The message cannot be represented in 7-bit ASCII encoding and has been sent as a binary attachment. Message de la Plate-Forme SECURITE de l'Universite Sidi Med Ben Abdallah de Fes - USMBA - File attachment: body.pif The file attached to this email was removed because it is infected with the [EMAIL PROTECTED] virus. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
restrict and no action problem
Hi all I have problem in MYSQL query browser tool. I make a two tables ,one have primary key, and in second table i put reference to first table. I make all this in Query browser and set foreign key of second table to on delete no action. I apply changes but next time when i want to edit second table i see that foreign key is set to on delete restrict, and i don`t know way? In MYSQL Admin Tool i gave user all privileges to that database which contains two tables. Database is INNODB type. I want to make that foreign key set to on delete no action but i can`t do it . Any idea how to make it in MySQL query browser tool? Thanks __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyMonitor - A novel SQL monitor tool for MySQL release 1
There will probably be a full-blown Windows GUI version eventually. But for now, I guess you have to compile it under cygwin, which should work but hasn't been tried so far. There is probably a demand for windows, keep me posted now and then, and I'll let you know when it's available. Or just look at the project at sourceforge now and then. Best regards Anders Karlsson Gabriel Mahiques wrote: Anders I want this for Windows? how do I do it? Anders Karlsson escribió: The first version of MyMonitor is now available in source form on sourceforge and can be downloaded from: http://sourceforge.net/projects/mymonitor The reason for this tool is simple, and it's also a bit different from other similar tools (at least the ones I've looked at). The tool gets the output from SHOW PROCESSLIST repeatedly and does some magic to this to count the number of executions and execution time. The difference is in how it handles the SQL statement text. Before somparing the SQL text of a statment to the statements in the previous run of SHOW PROCESSLIST or to the SQL in an internal list of frequently accessed SQL statements, it removes any references to literal values. So the these statements: SELECT * FROM customer WHERE cust_id = 123; and SELECT * FROM customer WHERE cust_id = 123; Which in SHOW PROCESSLIST is shown as 2 distinct statements are handled as two executions of the same statement: SELECT * FROM customer WHERE cust_id = ?, which is usually how it works anyway. The output through ncurses, a bit like top. The collected statements may also be written to file, and there are a bunch of other settings, and there is also documentation in shape of a User Guide in PDF format. The current version is considered a beta, so comments on porting are more than welcome. I have so far only run it on a couple of Linux'es, but there is more to come. ncurses library is required, as well as the MySQL Client library of course. Enjoy, and comments are welcome, I hope this tool will turn out useful -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer /_/ /_/\_, /___/\___\_\___/ Stockholm ___/ www.mysql.com Cellphone: +46 708 608121 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
localhost
I'm trying to use mysql on Linux type Fedora Core 4 and it works part way but I have no guess how to fix this problem. Here is what happens: [EMAIL PROTECTED] ~]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.1.20-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use mysql; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql' mysql I let you see the way I get mysql up and then I ask to use a DB and every time I get ERROR 1044 and so of course I can't use mysql. Does anyone know what error I have made? I loaded mysql from the Linux version I'm using and had the problem. I then deleted all and yum got the latest version which is up now. Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: localhost
When you just call mysql, it tries to login using the current logged user in linux. Try to call mysql -u root may be work. Karl Larsen [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] I'm trying to use mysql on Linux type Fedora Core 4 and it works part way but I have no guess how to fix this problem. Here is what happens: [EMAIL PROTECTED] ~]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.1.20-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use mysql; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql' mysql I let you see the way I get mysql up and then I ask to use a DB and every time I get ERROR 1044 and so of course I can't use mysql. Does anyone know what error I have made? I loaded mysql from the Linux version I'm using and had the problem. I then deleted all and yum got the latest version which is up now. Karl Larsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: The number of left join in one SQL statement.
Hi, 2006/6/16, Takanobu Kawabe [EMAIL PROTECTED]: [snip] I tried this statement without error. But Ihave some questions. 1.How many left join keywords can I use in one SQL statement if there are 5000 datas in one table? as this blog point out, its 31 or 61 depending on your version : http://mike.kruckenberg.com/archives/2006/06/limit_on_number.html And the number of rows in the table doen't have to do with this limit (only the query time :-). -- http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[mysql] Attention List
hello list, i have been receiving random emails infected with viruses from what appear to be the mysql mailing list. gmail kills the virus form me but i thought i would let y'all know about this, just to be on the safe side. here are the details of the email. Message de la Plate-Forme SECURITE de l'Universite Sidi Med Ben Abdallah de Fes - USMBA - ALERT!!! This e-mail contained one or more infected files. The following attachments were infected and have been repaired: No attachments are in this category. The following infected attachments were deleted: 1. body.pif: [EMAIL PROTECTED] The following infected attachments were blocked because of Mail Policy violations: No attachments are in this category. You may wish to contact the sender to inform them about their infections. Thank you, Your ISP Equipe USMBA Original message text follows The message cannot be represented in 7-bit ASCII encoding and has been sent as a binary attachment. MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Daniel McQuay [EMAIL PROTECTED] boxster.homelinux.org H: 814.825.0847 M: 814-341-6233
Re: localhost
--- Karl Larsen [EMAIL PROTECTED] escribió: I'm trying to use mysql on Linux type Fedora Core 4 and it works part way but I have no guess how to fix this problem. Here is what happens: [EMAIL PROTECTED] ~]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.1.20-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use mysql; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql' mysql I let you see the way I get mysql up and then I ask to use a DB and every time I get ERROR 1044 and so of course I can't use mysql. Does anyone know what error I have made? I loaded mysql from the Linux version I'm using and had the problem. I then deleted all and yum got the latest version which is up now. Karl Larsen Hi, the problem is that you are not specifying any user to use mysql monitor you have to start it like this: mysql -ujohn -p or mysql -u john -p -u indicates the user you are logging as -p indicates that you have a password and you want to type it. Of course for you to log in as john you `ve got to set permission for user john to log in mysql trough localhost. Hope it helps. PS: If you have further questions read this: http://dev.mysql.com/doc/refman/4.1/en/user-account-management.html ___ 1GB gratis, Antivirus y Antispam Correo Yahoo!, el mejor correo web del mundo http://correo.yahoo.com.ar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [mysql] Attention List
On Friday 16 June 2006 03:01 pm, Daniel McQuay wrote: hello list, i have been receiving random emails infected with viruses from what appear to be the mysql mailing list. gmail kills the virus form me but i thought i would let y'all know about this, just to be on the safe side. here are the details of the email. You've now experienced the lovely and wonderful world of email header spoofing. When you send an email, you get headers sent with it. They generally follow the format of: Header: Value Now, given that, you can put darn well anything you want in there. So I could say: From: mysql@lists.mysql.com Through some magic mojo and become the MySQL mailing list. So in conclusion, don't take what you see worth a grain of salt when it comes to who things are from in the email world. -- Chris White PHP Programmer/DB PLEASE NO MORE LEFT JOINS ;( Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Performance Question
Our server will be home to 50-100 separate clients. Each client will have their own set of databases that will be accessed by 10-60 users at each client's site. In terms of performance, is it better to have 1 instance of MySQL servicing multiple databases, or multiple instances of MySQL each serving 1 database? Here's some more information to work with: Each client has 3 databases. Database: 500 tables. 13 tables sized 10-100MB. Remaining tables all less that 10MB. (This is the only database that is updated. The others are just for reference.) Main table grows at a rate of a few hundred MB/year. Database2: 50 tables. 3 tables sized 10-100MB. All other tables less than 10MB. No data growth. Database3: 179 tables. 10 tables sized 1-15MB. All other tables less than 1MB. No data growth. --Eric Disclaimer - June 16, 2006 This email and any files transmitted with it are confidential and intended solely for [EMAIL PROTECTED] If you are not the named addressee you should not disseminate, distribute, copy or alter this email. Any views or opinions presented in this email are solely those of the author and might not represent those of Physician Select Management (PSM) or Physician's Managed Care (PMC). Warning: Although the message sender has taken reasonable precautions to ensure no viruses are present in this email, neither PSM nor PMC can accept responsibility for any loss or damage arising from the use of this email or attachments. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [mysql] Attention List
i took it more as a grain of pepper and just wanted to warn y'all of the impending virus attack that may or may not be sent around. thanks for the break down though. On 6/16/06, Chris White [EMAIL PROTECTED] wrote: On Friday 16 June 2006 03:01 pm, Daniel McQuay wrote: hello list, i have been receiving random emails infected with viruses from what appear to be the mysql mailing list. gmail kills the virus form me but i thought i would let y'all know about this, just to be on the safe side. here are the details of the email. You've now experienced the lovely and wonderful world of email header spoofing. When you send an email, you get headers sent with it. They generally follow the format of: Header: Value Now, given that, you can put darn well anything you want in there. So I could say: From: mysql@lists.mysql.com Through some magic mojo and become the MySQL mailing list. So in conclusion, don't take what you see worth a grain of salt when it comes to who things are from in the email world. -- Chris White PHP Programmer/DB PLEASE NO MORE LEFT JOINS ;( Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Daniel McQuay [EMAIL PROTECTED] boxster.homelinux.org H: 814.825.0847 M: 814-341-6233
Join 2 tables using specific fields
I have 2 table. Zones(Z1..Z20) and Radius(R0..R4) where R0 is equivalent to Z1 R1 Z5 R2 Z9 R3 Z13 R4 Z17 How can I make the query to join them in such ways? eg: select A,B,C,D from Zone inner join radius on R1 = Z5 on R2 = Z9 on R3 = Z13 on R4 = Z17 or do I have to use a subquery?? -- Ow Mun Heng [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: CRM: Labels instead of specific atributes
Bruno-- I am not an expert, but... I would think most contact systems probably have separate tables for organizations and individuals. And usually additional tables to allow multiple addresses and telephones to be linked to the organizations and individuals. Yours seems rather novel in having a single central entity table that combines all those. I think that's what's causing your problem: each different type of entity has its own set of attributes, which would ordinarily be columns in that entity-type's own table. But you are applying attributes to entities largely by linking 'type' records to them, hence you are adding tables rather than columns. I would suggest one of two approaches: 1. Have separate tables for organizations and individuals. You then must track three or four types of relationships: organization-to-organization individual-to-individual organization-to-individual (individual-to-organization) or 2. Keep your single entity table (with rows for both organizations and individuals), add tables for organizations and individuals, and link each entity row to a row in either the organizations or individuals table. All your relationships can then be between rows in the entity table. I'd better stop there. What do you think? --John Bruno B B Magalhães wrote: Hi everyone, Well I don´t have a question, but instead a proposition that I would to discuss with people to find what are they doing and why. For example I have developed and still developing a big and largely used CRM platform. And since it´s primary version the system has growth in a way to incorporate many, many, many functions that our users have asked, but as we are exploring new ways for the next version, a total ground-up release, I was thinking about how people, and consequently systems, categorizes their entities. Let me be more clear: For example today we have generic contact, which must have a entity type (person, industry or government), a gender (none, male, female), an economic sector (primary, secondary, tertiary, quaternary), and industry type (agriculture, robotics, real-estate, etc), an occupation (lawyer, engineer, farmer, etc) and so on, we have today almost 10 types also including statuses, and types (internal, prospect, client, partner, supplier, etc)... Well you got the picture. :) So all those tables look something like this: CREATE TABLE `contacts_types` ( `contact_type_id` int(5) unsigned NOT NULL auto_increment, `contact_type_name` char(40) NOT NULL default '', `contact_type_sequence` int(5) unsigned NOT NULL default '0', `contact_type_inserted_by` int(40) unsigned NOT NULL default '0', `contact_type_inserted_at` datetime default NULL, `contact_type_updated_by` int(40) unsigned NOT NULL default '0', `contact_type_updated_at` datetime default NULL, `contact_type_deleted_by` int(40) unsigned NOT NULL default '0', `contact_type_deleted_at` datetime default NULL, PRIMARY KEY (`contact_type_id`), KEY `INDEX` (`contact_type_inserted_by`,`contact_type_inserted_at`,`contact_type_updated_by`,`contact_type_updated_at`,`contact_type_deleted_by`,`contact_type_deleted_at`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 And course the many-to-many table: CREATE TABLE `contacts_to_contacts_types ` ( `contact_id` int(40) unsigned NOT NULL auto_increment, `contact_type_id` int(5) unsigned NOT NULL auto_increment, KEY `INDEX` (`contact_id `,`contact_type_id `) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 As you can imagine, the amount of tables has growth out of control (as we have a lot of entities as contacts, emails, addresses, telephones, projects, tasks, interactions, etc... etc..etc), well not quite but is getting there, as our clients more and more ask for one more categorization, but for each new category new need to create another, to hold chronological statistics for it (Well, it´s a CRM not an fancy address book) and also the business logic to insert every day new data, just like this one: CREATE TABLE `contacts_types_statistics` ( `contact_type_id` int(5) unsigned NOT NULL default '0', `contact_type_at` date default NULL, `contact_type_count` int(5) unsigned NOT NULL default '0', KEY `INDEX` (`contact_type_id`,`contact_type_at`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Course every business has it´s own needs, but most of then have common needs, as then all interact with customers and suppliers. Last night I was thinking about a sort of new approach for this: Instead of having many tables to specific categorizations, I would have only one, maybe to, called labels and labels groups, based on the idea of a paper on the desk in which you attach some stickers (that yellow small papers where you can write categories). So you would have labels groups, and the labels itself.. or you could have only labels, with parents and children labels. And course another to hold statistical data.
Need Information About MySql Support for Application Blocks
Hello, I am a dotnet developer and i want to use Data Access Application Blocks for dotnet, so i want to know whether MySql Supports Data Access APPlication Blocks, and if so pl provide the connector for that. -- Thanks Regards, veerabhadra rao narra, +91-988-556-5556
