Ongelma WinXP ->mYsQL

[Edvard]

Hyvä päivä!
Olen erittäin kiitollinen, jos löytyy ratkaisu tähän ongelman.
Toista viikkoa, ilman tulosta olen yrittänyt ratkaista ongelman.
Koneessa on WinXP(SP2), IIS, MySql(4.1)
Tehty web sivu, jossa käyttäjä syöttää tietoa. Kaikki näytä toimivaan 
hyvin,
kunnes syötetään TextBoxi:n, yli 6 merkkiä pitkä merkkijono. Tule
virheilmoitus:

* Virhetyyppi: Microsoft OLE DB Provider for ODBC Drivers (0x80040E21) Monivaiheinen OLE DB -toiminto aiheutti virheitä. Tarkista OLE DB -tila-arvot. Työtä ei tehty. /10/ver2.asp, line 27 Selaintyyppi: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705)  a.. Sivu:  POST 28 bytes to /10/ver2.asp  b.. POST Data:  nimi=12345678&puh=  c.. Aika:  6. maaliskuuta 2005, 8:01:33  Ilmoitus viitta siihen että on syötetty liian pitkä jono, mutta HTML koodin mukaan tila on vielä kuinkaan paljon :" Nimi :  " . MySql tietokannassa  kenttään typpi on VARCHAR( tietokannassa ei ole ongelmia, toimi mainiosti). Ystävällisin terveisin Edvard Hannolainen tel. +358 44 7 221066 P.S Liitetiedostossa on web sivun HTML koodi.
-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Use MySQL with Microsoft Office

[Tom Crimmins]

On Monday, March 07, 2005 23:03, GH wrote:

> Greetings, I would like to know if it is possible to do a mail merge
> in Microsoft Office with a mySql database as the source?
> 
> Thanks

You can use install MyODBC, set up a DSN, and then use this in Office.

http://dev.mysql.com/downloads/connector/odbc/3.51.html

-- 
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Use MySQL with Microsoft Office

[GH]

Greetings, I would like to know if it is possible to do a mail merge
in Microsoft Office with a mySql database as the source?

Thanks

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: How do I move the Mysql database files from /var/lib/mysql to someother directory

[Tom Crimmins]

On Monday, March 07, 2005 22:19, digvijoy chatterjee wrote:

> I have Mysql 4.1.9 on RHES-3.0 installed by rpms..the default socket
> path and database creation directory is /var/lib/mysqlnow there
> is a a dearth of space in /var therefore i would like to move the
> database files to something like /usr which has lots of free space ,
> creating Symlinks does not seem to help.what is the way out

If you are moving all of the databases you can do the following:
-Shutdown mysql
-Move the that database files from /var/lib/mysql to /my/new/path
-Edit /etc/my.cnf - change datadir=/var/lib/mysql to datadir=/my/new/path
-Start mysql

Here is some info on symbolic links and databases from the manual:
http://dev.mysql.com/doc/mysql/en/symbolic-links-to-databases.html

-- 
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How do I move the Mysql database files from /var/lib/mysql to someother directory

[digvijoy chatterjee]

I have Mysql 4.1.9 on RHES-3.0 installed by rpms..the default socket
path and database creation directory is /var/lib/mysqlnow there is a
a dearth of space in /var therefore i would like to move the database
files to something like /usr which has lots of free space , creating
Symlinks does not seem to help.what is the way out
--Digvijoy

Time to be shown with query result

[Kenken PA]

Hi All,
I need to answer the floowing quetions even I'm a newbie of C programming.
Anyone helps me out?

Q: Using mysql client, after issuing sql statements, we can see how
long it takes to get results, like;

1 row in set (0.01 sec)

Does the time, 0.01 sec in this case, mean what kind of time?

Is the time calculated at mysql client or at mysqld?

Time between a point to issue a statement from mysql client, and a
point to get all results to show?


I'm checking inside of the source file, \client\mysql.cc,
and "nice_time" seemed to me that this function calculate the time.
However, I'm not sure at all.

Thanks for your co-operation in advance.

Kenken PA

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql server crash on nested selects (fwd)

[Ronald Braunstein]

 0
join_tab = (JOIN_TAB *) 0x8490941
end_select = (int (*)()) 0x81653e6 
_db_func_ = 0x658ec1a4 "äÁ\216e1o\026\b¸ù¸\b"
_db_file_ = 0x658ec1a0 ""
_db_level_ = 958
_db_framep_ = (char **) 0x8165026
#8  0x8166a2a in JOIN::exec (this=0x8b8f9b8) at sql_select.cc:1482
this = (JOIN *) 0x8b8f9b8
tmp_error = 0
_db_func_ = 0x0
_db_file_ = 0x1 
_db_level_ = 146229328
_db_framep_ = (char **) 0x0
curr_join = (JOIN *) 0x8b8f9b8
curr_all_fields = (List *) 0x8b902f0
curr_fields_list = (List *) 0x8b4adf8
curr_tmp_table = (TABLE *) 0x0
#9  0x8166f31 in mysql_select (thd=0x8b4ac60, rref_pointer_array=0x8b4ae94, 
tables=0x8b74850, wild_num=1, [EMAIL PROTECTED], conds=0x0, og_num=0, 
order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2156153344, 
result=0x8b8f9a8, unit=0x8b4aca8,
select_lex=0x8b4ad90) at sql_select.cc:1602
err = 0
free_join = true
_db_func_ = 0x81e676e "\203Ä\020ë\004ë\002ë"
_db_file_ = 0x658ec254 "äÆ\216edÑ\023\b`¬´\b\234¬´\b¨ù¸\b"
_db_level_ = 146058336
_db_framep_ = (char **) 0x8632a60
join = (JOIN *) 0x8b8f9b8
#10 0x8162f5c in handle_select (thd=0x8b4ac60, lex=0x8b4ac9c, result=0x8b8f9a8) 
at sql_select.cc:193
res = 0
select_lex = (SELECT_LEX *) 0x8b4ad90
_db_func_ = 0x813d113 "\203Ä\020\211ÀPèNÊ,"
_db_file_ = 0x658ec6e4 "$Ç\216e®'\024\b`¬´\b`¬´\b8p·\b/\004"
_db_level_ = 1703855844
_db_framep_ = (char **) 0x9
#11 0x813d164 in mysql_execute_command (thd=0x8b4ac60) at sql_parse.cc:2082
result = (select_result *) 0x8b8f9a8
res = 0
lex = (LEX *) 0x8b4ac9c
slave_fake_lock = false
fake_prev_lock = (MYSQL_LOCK *) 0x0
select_lex = (SELECT_LEX *) 0x8b4ad90
tables = (TABLE_LIST *) 0x8b74c10
unit = (SELECT_LEX_UNIT *) 0x8b4aca8
_db_func_ = 0x0
_db_file_ = 0x0
_db_level_ = 140794780
_db_framep_ = (char **) 0x

(gdb)

==


>How-To-Repeat:


mysql < -
===
-- MySQL dump 10.9
--
-- Host: localhostDatabase: devmail
-- --
-- Server version   4.1.11-nightly-20050307-debug-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 
*/;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

--
-- Table structure for table `aggregates`
--

DROP TABLE IF EXISTS `aggregates`;
CREATE TABLE `aggregates` (
  `date` date NOT NULL default '-00-00',
  `average_open_time` int(10) unsigned default NULL,
  `average_response_time` int(10) unsigned default NULL,
  `average_total_response_time` int(10) unsigned default NULL,
  PRIMARY KEY  (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `assignment`
--

DROP TABLE IF EXISTS `assignment`;
CREATE TABLE `assignment` (
  `ticket_id` int(11) unsigned NOT NULL default '0',
  `assigned_to` varchar(128) NOT NULL default '',
  PRIMARY KEY  (`ticket_id`),
  KEY `assigned_to` (`assigned_to`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `cc`
--

DROP TABLE IF EXISTS `cc`;
CREATE TABLE `cc` (
  `ticket_id` int(11) NOT NULL default '0',
  `email_address` varchar(127) NOT NULL default '',
  PRIMARY KEY  (`ticket_id`,`email_address`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `contacts`
--

DROP TABLE IF EXISTS `contacts`;
CREATE TABLE `contacts` (
  `ticket_id` int(11) NOT NULL auto_increment,
  `subject` text NOT NULL,
  `status` varchar(127) NOT NULL default '',
  `type` varchar(255) NOT NULL default 'other',
  `urgency` enum('5','4','3') NOT NULL default '5',
  `requester_email` varchar(127) NOT NULL default '',
  `perforce_client` varchar(127) NOT NULL default '',
  `active_time` datetime NOT NULL default '-00-00 00:00:00',
  `resolved_time` datetime NOT NULL default '-00-00 00:00:00',
  PRIMARY KEY  (`ticket_id`),
  UNIQUE KEY `ticket_id` (`ticket_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `correspondence`
--

DROP TABLE IF EXISTS `correspondence`;
CREATE TABLE `correspondence` (
  `correspondence_id` int(11) NOT NULL auto_increment,
  `reply_to_id` int(11) NOT NULL default '0',
  `ticke

Re: database pooling problem

[William R. Mussatto]

Eric Bergen said:
> Apache 1.3 with php (not sure about tomcat) is a pre forked daemon. Any
> connection pooling numbers will be per child. Try setting your
> connection numbers per child (for most php apps this is 1) and let us
> know what happens. I'm guessing it will create as many connections as
> there are apache children. For more info see the fork() man page.
>
> -Eric
Actually the connection is on per worker process.  Tomcat response to
apache's children's requests, so it would be, at worst, one connnection
per tomcat worker, which should be a smaller number than apache
children/threads.  There are methods for tomcat workers to also share a
connection pool, but I've never used them.  For my needs dropping and
creating connections has been better (shared servers).

I'd look at the tomcat connection pooling information on the apache site
as a place to start rather than the web-sever.  Hopefully you have
configured tomcat to just handle the .jsp page not ALL PAGES.
> On Mon, 7 Mar 2005 17:04:47 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> wrote:
>> "Scott Purcell" <[EMAIL PROTECTED]> wrote on 03/07/2005 04:59:27
>> PM:
>>
>> > Thanks Sean,
>> >
>> > I am using standalone Apache/Tomcat 4.1.31
>> >
>> > mysql> \s
>> > --
>> > mysql  Ver 12.21 Distrib 4.0.15, for Win95/Win98 (i32)
>> >
>> > Connection id:  184
>> > SSL:Not in use
>> > Server version: 4.0.15-max-debug
>> > Protocol version:   10
>> > Connection: localhost via TCP/IP
>> > Client characterset:latin1
>> > Server characterset:latin1
>> > TCP port:   3306
>> > --
>> >
>> > mysql>
>> >
>> > I am using Java to code with and I am using a driver called:
>> > org.gjt.mm.mysql.Driver
>> >
>> >
>> > My connection class is too large to submit to the list, or I would
>> submit it.
>> >
>> > I guess what I would like to be able to do is create some type of
>> object that I could use to do pooling that is maybe inside the
>> container?
>> >
>> > I hope this helps,
>> > Scott
>>
>> It would be happy to try to help if I worked in or on either of those
>> platforms (Apache + Java).  I am Win32(IIS), ASP (VBScript/JavaScript)
>> using MyODBC as my connection library. Sorry but I can't help in any
>> way shape or form. I have CC-ed the description of your operating and
>> development environments to the list to see if anyone offers to help.
>>
>> Maybe next time!
>>
>> Shawn Green
>> Database Administrator
>> Unimin Corporation - Spruce Pine
>>
>> >
>> >
>> > -Original Message-
>> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>> > Sent: Monday, March 07, 2005 3:48 PM
>> > To: Scott Purcell
>> > Cc: mysql@lists.mysql.com
>> > Subject: Re: database pooling problem
>>
>> >
>> >
>> > "Scott Purcell" <[EMAIL PROTECTED]> wrote on 03/07/2005
>> 04:29:18
>> PM:
>> >
>> > > Hello,
>> > >
>> > > I am working with a traditional database pooling class basically
>> putting connection objects into a Vector.  When I run the code
>> from a main, it appears solid. I have run 10s of thousands of back
>> to back queries and all is good.
>> > >
>> > > Problem is when I connect it to a web-app, and reboot the
>> webserver a couple of times, I get a message from the driver
>> stating "Too many connection" and I am done.
>> > >
>> > > Upon thinking about this, I figured my traditional Vector of
>> connections, is getting created over and over, each time someone
>> "bumps" the web server with a new class, etc. So I start out with
>> 10 connections, then another 10 and another 10 and eventually I
>> guess the driver has no more connections to give?
>> > >
>> > > Anyway, this list is possibly the wrong, list, but I would hope
>> there are some developers here that may lend a hand or link. So I
>> am not happy with what I have created nor the way it works on the
>> web
>> server.
>> > >
>> > > Does anyone have any ideas how I should handle this? in a
>> web-based environment.
>> > >
>> > > Thanks,
>> > > Scott
>> > >
>> > >
>> >
>> > No matter which list you submit to, you need to provide more
>> > details. Technically what you are asking is a little off-topic (more
>> about making a pool work with a web server than just making the
>> connection, right?) But if you bring the question to the list,
>> someone _may_ be able to pitch in and help.
>> >
>> > Now exactly WHO can help (and to what degree they can help)
>> > completely depends on WHICH web server you use (there are dozens,
>> you know...), HOW you initialize your pool (again many methods
>> available), HOW you take and return connections from your pool
>> (ditto), and which languages are in use in this entire process
>> (again dozens of options). Just telling us that you use a web-server
>> did not provide nearly enough information as there are literally
>> thousands of combinations of ways to do what you described.
>> >
>> > Please tell whichever list you submit to:
>> > What OS you are using
>> > Whi

skip-name-resolve

[Mauricio Pellegrini]

Hi,
Sometimes our Internet conection goes down and then all conections via
tcp/ip to our the mysql server (v.4.1.5) are slow.

I've read in the manual that one could use --skip-name-resolve as a
possible solution to this problem under windows.

The thing is that I've set this option int /etc/my.cnf in this way

[mysqld]
port= 3306
socket  = /tmp/mysql.sock
skip-locking
skip-name-resolve


but I don't see it in the output from ps aux | grep mysql
my questions are 

No.1 
Is the option well set and in the right place ?


No.2
This slowness problem could occur also on a server running SuSe Linux
8.2 ?



Thanks 
Mauricio




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: database pooling problem

[Eric Bergen]

Apache 1.3 with php (not sure about tomcat) is a pre forked daemon.
Any connection pooling numbers will be per child. Try setting your
connection numbers per child (for most php apps this is 1) and let us
know what happens. I'm guessing it will create as many connections as
there are apache children. For more info see the fork() man page.

-Eric

On Mon, 7 Mar 2005 17:04:47 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> "Scott Purcell" <[EMAIL PROTECTED]> wrote on 03/07/2005 04:59:27 PM:
> 
> > Thanks Sean,
> >
> > I am using standalone Apache/Tomcat 4.1.31
> >
> > mysql> \s
> > --
> > mysql  Ver 12.21 Distrib 4.0.15, for Win95/Win98 (i32)
> >
> > Connection id:  184
> > SSL:Not in use
> > Server version: 4.0.15-max-debug
> > Protocol version:   10
> > Connection: localhost via TCP/IP
> > Client characterset:latin1
> > Server characterset:latin1
> > TCP port:   3306
> > --
> >
> > mysql>
> >
> > I am using Java to code with and I am using a driver called:
> > org.gjt.mm.mysql.Driver
> >
> >
> > My connection class is too large to submit to the list, or I would
> submit it.
> >
> > I guess what I would like to be able to do is create some type of
> > object that I could use to do pooling that is maybe inside the
> container?
> >
> > I hope this helps,
> > Scott
> 
> It would be happy to try to help if I worked in or on either of those
> platforms (Apache + Java).  I am Win32(IIS), ASP (VBScript/JavaScript)
> using MyODBC as my connection library. Sorry but I can't help in any way
> shape or form. I have CC-ed the description of your operating and
> development environments to the list to see if anyone offers to help.
> 
> Maybe next time!
> 
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
> 
> >
> >
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > Sent: Monday, March 07, 2005 3:48 PM
> > To: Scott Purcell
> > Cc: mysql@lists.mysql.com
> > Subject: Re: database pooling problem
> 
> >
> >
> > "Scott Purcell" <[EMAIL PROTECTED]> wrote on 03/07/2005 04:29:18
> PM:
> >
> > > Hello,
> > >
> > > I am working with a traditional database pooling class basically
> > > putting connection objects into a Vector.  When I run the code from
> > > a main, it appears solid. I have run 10s of thousands of back to
> > > back queries and all is good.
> > >
> > > Problem is when I connect it to a web-app, and reboot the webserver
> > > a couple of times, I get a message from the driver stating "Too many
> > > connection" and I am done.
> > >
> > > Upon thinking about this, I figured my traditional Vector of
> > > connections, is getting created over and over, each time someone
> > > "bumps" the web server with a new class, etc. So I start out with 10
> > > connections, then another 10 and another 10 and eventually I guess
> > > the driver has no more connections to give?
> > >
> > > Anyway, this list is possibly the wrong, list, but I would hope
> > > there are some developers here that may lend a hand or link. So I am
> > > not happy with what I have created nor the way it works on the web
> server.
> > >
> > > Does anyone have any ideas how I should handle this? in a web-based
> > > environment.
> > >
> > > Thanks,
> > > Scott
> > >
> > >
> >
> > No matter which list you submit to, you need to provide more
> > details. Technically what you are asking is a little off-topic (more
> > about making a pool work with a web server than just making the
> > connection, right?) But if you bring the question to the list,
> > someone _may_ be able to pitch in and help.
> >
> > Now exactly WHO can help (and to what degree they can help)
> > completely depends on WHICH web server you use (there are dozens,
> > you know...), HOW you initialize your pool (again many methods
> > available), HOW you take and return connections from your pool
> > (ditto), and which languages are in use in this entire process
> > (again dozens of options). Just telling us that you use a web-server
> > did not provide nearly enough information as there are literally
> > thousands of combinations of ways to do what you described.
> >
> > Please tell whichever list you submit to:
> > What OS you are using
> > Which web server you are using
> > What languages you are using
> >
> > And you will need to supply some code examples, too. The list
> > members will need to be able to see your code so that they can see
> > what is "wrong" with it.
> >
> > Best of luck,
> > Shawn Green
> > Database Administrator
> > Unimin Corporation - Spruce Pine
> 


-- 
Eric Bergen
[EMAIL PROTECTED]
http://www.ebergen.net

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: database pooling problem

[SGreen]

"Scott Purcell" <[EMAIL PROTECTED]> wrote on 03/07/2005 04:59:27 PM:

> Thanks Sean,
> 
> I am using standalone Apache/Tomcat 4.1.31
> 
> mysql> \s
> --
> mysql  Ver 12.21 Distrib 4.0.15, for Win95/Win98 (i32)
> 
> Connection id:  184
> SSL:Not in use
> Server version: 4.0.15-max-debug
> Protocol version:   10
> Connection: localhost via TCP/IP
> Client characterset:latin1
> Server characterset:latin1
> TCP port:   3306
> --
> 
> mysql>
> 
> I am using Java to code with and I am using a driver called: 
> org.gjt.mm.mysql.Driver
> 
> 
> My connection class is too large to submit to the list, or I would 
submit it.
> 
> I guess what I would like to be able to do is create some type of 
> object that I could use to do pooling that is maybe inside the 
container?
> 
> I hope this helps,
> Scott

It would be happy to try to help if I worked in or on either of those 
platforms (Apache + Java).  I am Win32(IIS), ASP (VBScript/JavaScript) 
using MyODBC as my connection library. Sorry but I can't help in any way 
shape or form. I have CC-ed the description of your operating and 
development environments to the list to see if anyone offers to help.

Maybe next time!

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine










 
> 
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 07, 2005 3:48 PM
> To: Scott Purcell
> Cc: mysql@lists.mysql.com
> Subject: Re: database pooling problem

> 
> 
> "Scott Purcell" <[EMAIL PROTECTED]> wrote on 03/07/2005 04:29:18 
PM:
> 
> > Hello,
> > 
> > I am working with a traditional database pooling class basically 
> > putting connection objects into a Vector.  When I run the code from 
> > a main, it appears solid. I have run 10s of thousands of back to 
> > back queries and all is good.
> > 
> > Problem is when I connect it to a web-app, and reboot the webserver 
> > a couple of times, I get a message from the driver stating "Too many
> > connection" and I am done.
> > 
> > Upon thinking about this, I figured my traditional Vector of 
> > connections, is getting created over and over, each time someone 
> > "bumps" the web server with a new class, etc. So I start out with 10
> > connections, then another 10 and another 10 and eventually I guess 
> > the driver has no more connections to give?
> > 
> > Anyway, this list is possibly the wrong, list, but I would hope 
> > there are some developers here that may lend a hand or link. So I am
> > not happy with what I have created nor the way it works on the web 
server.
> > 
> > Does anyone have any ideas how I should handle this? in a web-based 
> > environment.
> > 
> > Thanks,
> > Scott
> > 
> > 
> 
> No matter which list you submit to, you need to provide more 
> details. Technically what you are asking is a little off-topic (more
> about making a pool work with a web server than just making the 
> connection, right?) But if you bring the question to the list, 
> someone _may_ be able to pitch in and help. 
> 
> Now exactly WHO can help (and to what degree they can help) 
> completely depends on WHICH web server you use (there are dozens, 
> you know...), HOW you initialize your pool (again many methods 
> available), HOW you take and return connections from your pool 
> (ditto), and which languages are in use in this entire process 
> (again dozens of options). Just telling us that you use a web-server
> did not provide nearly enough information as there are literally 
> thousands of combinations of ways to do what you described. 
> 
> Please tell whichever list you submit to: 
> What OS you are using 
> Which web server you are using 
> What languages you are using 
> 
> And you will need to supply some code examples, too. The list 
> members will need to be able to see your code so that they can see 
> what is "wrong" with it. 
> 
> Best of luck, 
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine

Re: database pooling problem

[SGreen]

"Scott Purcell" <[EMAIL PROTECTED]> wrote on 03/07/2005 04:29:18 PM:

> Hello,
> 
> I am working with a traditional database pooling class basically 
> putting connection objects into a Vector.  When I run the code from 
> a main, it appears solid. I have run 10s of thousands of back to 
> back queries and all is good.
> 
> Problem is when I connect it to a web-app, and reboot the webserver 
> a couple of times, I get a message from the driver stating "Too many
> connection" and I am done.
> 
> Upon thinking about this, I figured my traditional Vector of 
> connections, is getting created over and over, each time someone 
> "bumps" the web server with a new class, etc. So I start out with 10
> connections, then another 10 and another 10 and eventually I guess 
> the driver has no more connections to give?
> 
> Anyway, this list is possibly the wrong, list, but I would hope 
> there are some developers here that may lend a hand or link. So I am
> not happy with what I have created nor the way it works on the web 
server.
> 
> Does anyone have any ideas how I should handle this? in a web-based 
> environment.
> 
> Thanks,
> Scott
> 
> 

No matter which list you submit to, you need to provide more details. 
Technically what you are asking is a little off-topic (more about making a 
pool work with a web server than just making the connection, right?) But 
if you bring the question to the list, someone _may_ be able to pitch in 
and help.

Now exactly WHO can help (and to what degree they can help) completely 
depends on WHICH web server you use (there are dozens, you know...), HOW 
you initialize your pool (again many methods available), HOW you take and 
return connections from your pool (ditto), and which languages are in use 
in this entire process (again dozens of options). Just telling us that you 
use a web-server did not provide nearly enough information as there are 
literally thousands of combinations of ways to do what you described.

Please tell whichever list you submit to:
What OS you are using
Which web server you are using
What languages you are using

And you will need to supply some code examples, too. The list members will 
need to be able to see your code so that they can see what is "wrong" with 
it. 

Best of luck,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Info EasyPHP 1.8 - Error !!! Urgent !

[Carlos Bergueira]

 

Hi !

 

I'm having a problem.

In my 2nd database acces, na error as occured: "Cannot run server: System
could not find specific path (3)."

In first Access i did not have problem; i have accessed data base via
phpMyAdmin.

Now, i can't do that !

Why ?

Someone can help me !!!

Thanks.

 

Cumprts,

Carlos Bergueira

Temp file hanling gone wrong

[Homam S.A.]

MySQL keeps throwing error 1114 on temp files (those
that MySQL creates behind the scenes when executing a
query and start with #), which is pretty dumb because
there's no way for the user to set the maximum row
size on temp table files. It seems that MySQL is
wrongly setting the temp size and then complaining
about it.

Is there a way to fix this kind of file hanlding
corruption? May be peek into some system tables and
see what's going on?

I ran MYISAMCHK and it couldn't fine any error in the
table, created a new table and copied the content of
the old table to it, deleted my temp directory (listed
in the TMP and TEMP environment variables), repointed
MySQL temp directory to a huge drive (even though the
existing drive had more than enough space for twice
the size of the table), but sadly, none of these would
fix it.

There is a setting for the in-memory temp table size
(tmp_table_size), but as the documentation indicate,
it's merely a threshold above which MySQL moves the
temp table from memory to disk.

It seems to me there's a bug in MySQL that either
corrupts the temp file tracking system tables (if
there are any) or can't reliably determine the maximum
table size of temp tables.

I would appreciate any help because I'm at a deadend
where reinstalling MySQL and rebuilding my tables is
the only remaining option.


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

database pooling problem

[Scott Purcell]

Hello,
 
I am working with a traditional database pooling class basically putting 
connection objects into a Vector.  When I run the code from a main, it appears 
solid. I have run 10s of thousands of back to back queries and all is good.
 
Problem is when I connect it to a web-app, and reboot the webserver a couple of 
times, I get a message from the driver stating "Too many connection" and I am 
done.
 
Upon thinking about this, I figured my traditional Vector of connections, is 
getting created over and over, each time someone "bumps" the web server with a 
new class, etc. So I start out with 10 connections, then another 10 and another 
10 and eventually I guess the driver has no more connections to give?
 
Anyway, this list is possibly the wrong, list, but I would hope there are some 
developers here that may lend a hand or link. So I am not happy with what I 
have created nor the way it works on the web server.
 
Does anyone have any ideas how I should handle this? in a web-based environment.
 
Thanks,
Scott
 
 
 
 

Re: Sum() unequal number of rows

[Eric Bergen]

Since those two queries don't seem to have any relation other than
being from the same table it seems more logical to keep them two
separate queries.


On Mon, 7 Mar 2005 15:30:16 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> "Dave Kennedy" <[EMAIL PROTECTED]> wrote on 03/06/2005 05:09:36 PM:
> 
> >
> > SELECT sum(col1) AS total1
> > FROM t1
> > GROUP by col1
> >
> > SELECT col1, sum(col2) AS total2
> > FROM t2
> > GROUP by col2
> >
> > Table t1 contains 4 rows to sum for each value in col1
> >
> > Table t2 contains 8 rows to sum for each value in col2
> >
> > If one select statement is used, the result has 8 rows and total2 is
> > correct but the tota11 is summed over 8 rows instead of 4
> >
> > How can they be joined to produce one row total1, total2
> 
> Without actually seeing your actual data it is nearly impossible to help
> you diagnose this issue. Especially since your results seem to match your
> descriptions (4 rows of data in one table = 4 rows of results if you do it
> one way)
> 
> Please post your table structures (SHOW CREATE TABLE xxx\G) and your
> sample data (SELECT * FROM xxx;), then show us what you think your queries
> SHOULD have given you (your expected results) and we can start to help.
> The xxx in the sample commands was just a placeholder for the actual table
> names of your data.
> 
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
> 
> 


-- 
Eric Bergen
[EMAIL PROTECTED]
http://www.ebergen.net

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Getting weird error when updating table

[Mihail Manolov]

Check the size of your partition that contains /tmp directory.
Just in case symlink it to a bigger partition. Your temporary table may 
be bigger than the available space in /tmp

Luck,
Mihail
Homam S.A. wrote:
Whenever I try to update an ISAM table (through a join
with nother small lookup table, also ISAM), I get the
following error:
Error Code : 1114
The table '#sql_910_0' is full
I read the following in the documentation:
http://dev.mysql.com/doc/mysql/en/full-table.html
But none of the reasons listed apply. It seems that
#sql_910_0 is some temp table that MySQL is using to
temporary spool intermediate results. But it doesn't
exist anywhere in my file system.
Have you guys gotten such an error?

	
		
__ 
Celebrate Yahoo!'s 10th Birthday! 
Yahoo! Netrospective: 100 Moments of the Web 
http://birthday.yahoo.com/netrospective/

 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Sum() unequal number of rows

[SGreen]

"Dave Kennedy" <[EMAIL PROTECTED]> wrote on 03/06/2005 05:09:36 PM:

> 
> SELECT sum(col1) AS total1
> FROM t1
> GROUP by col1
> 
> SELECT col1, sum(col2) AS total2
> FROM t2
> GROUP by col2
> 
> Table t1 contains 4 rows to sum for each value in col1 
> 
> Table t2 contains 8 rows to sum for each value in col2
> 
> If one select statement is used, the result has 8 rows and total2 is
> correct but the tota11 is summed over 8 rows instead of 4 
> 
> How can they be joined to produce one row total1, total2 

Without actually seeing your actual data it is nearly impossible to help 
you diagnose this issue. Especially since your results seem to match your 
descriptions (4 rows of data in one table = 4 rows of results if you do it 
one way)

Please post your table structures (SHOW CREATE TABLE xxx\G) and your 
sample data (SELECT * FROM xxx;), then show us what you think your queries 
SHOULD have given you (your expected results) and we can start to help. 
The xxx in the sample commands was just a placeholder for the actual table 
names of your data.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Re: permission denied error

[kaustubh shinde]

Hi Michael,
Thanks for getting back.
I did not change ownerships when I moved files.
I made a separate data directory mysqldata inside basedir as you suggested.
As of now both these are owned by mysql because I wasn't sure which files 
exactly belong to datadir and which don't. I have moved following files to 
data directory:
ib_arch_log_00  ibdata1  ib_logfile0  ib_logfile1  linux.err
and following are still in the basedir:
mysqld.log  mysqld.log-20050118.gz  mysqld.log-20050119.gz  
mysqld.log-20050120.gz
mysql(dir)
The file permissions are as follows:
drwxr-xr-x   7 mysql root   352 2005-03-07 14:26 .
drwxr-xr-x  13 root  root   352 2005-02-23 04:11 ..
drwx--   2 mysql mysql   48 2005-01-21 16:19 m
drwxr-xr-x   2 mysql mysql 2360 2005-01-21 01:22 maxd
drwxr-xr-x   2 mysql root   528 2005-01-19 16:28 mysql
drwxr-xr-x   2 mysql root   208 2005-03-07 13:48 mysqldata
-rw-r-   1 mysql mysql 7115 2005-03-06 02:54 mysqld.log
-rw-r--r--   1 mysql root   384 2005-01-19 16:18 mysqld.log-20050118.gz
-rw-r--r--   1 mysql root   598 2005-01-19 16:18 mysqld.log-20050119.gz
-rw-r--r--   1 mysql root   592 2005-01-20 04:15 mysqld.log-20050120.gz

Now, I tried following:
mysqld_safe --basedir=/data/mysql --datadir=/data/mysql/mysqldata  
--user=mysql &
and I still get following error:
Starting mysqld-max daemon with databases from /data/mysql/mysqldata
/usr/bin/mysqld_safe: line 307: /data/mysql/mysqldata/linux.err: Permission 
denied
/usr/bin/mysqld_safe: line 313: /data/mysql/mysqldata/linux.err: Permission 
denied
STOPPING server from pid file /data/mysql/mysqldata/linux.pid
tee: /data/mysql/mysqldata/linux.err: Permission denied
050307 14:29:50  mysqld ended
tee: /data/mysql/mysqldata/linux.err: Permission denied

And it doesn't write anything in the mysqld.log file in the /data/mysql dir.
Original Message Follows
From: Michael Stassen <[EMAIL PROTECTED]>
To: kaustubh shinde <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: permission denied error
Date: Sun, 06 Mar 2005 13:16:45 -0500
Usually, datadir is a subdirectory of basedir.  Something like
 mysqld_safe --basedir=/data/mysql --datadir=/data/mysql/data --user=mysql 
&

Are you certain you want your databases in your basedir, rather than in a 
subdirectory?

The errors you are getting seem to indicate that user mysql cannot write to 
your datadir (/data/mysql).  Wherever you put your datadir, it must be 
writeable by mysql, not just owned by mysql.  Usually, basedir is not 
writeable by mysql, only datadir is (and that's a good idea, security-wise). 
 Furthermore, all the contents of datadir must be writeable by mysql.  Did 
you preserve the datafiles' ownership when you moved them?

The usual setup would be to have basedir owned and writeable only by root, 
with datadir as a subdirectory owned and writeable by mysql.

If this doesn't get you going, send us the output of `ls -aFl /data/mysql`.
Michael
kaustubh shinde wrote:
>Hi,
>I have moved my base and data directories at /data/mysql on my
>system and /data/mysql is owned by user mysql. Earlier these were
>located at /var/lib/mysql
>my /etc/my.cnf has following entries:
>
># The following options will be passed to all MySQL clients
>[client]
>#password   = your_password
>port= 3306
>socket  = /tmp/mysql.sock
>
># Here follows entries for some specific programs
>
># The MySQL server
>[mysqld]
>port= 3306
>socket  = /tmp/mysql.sock
>skip-locking
>key_buffer = 16M
>max_allowed_packet = 1M
>table_cache = 64
>sort_buffer_size = 512K
>net_buffer_length = 8K
>myisam_sort_buffer_size = 8M
>
>set-variable = datadir=/data/mysql/
>set-variable = bdb_home=/data/mysql/
>set-variable = basrdir=/data/mysql/
>
>When I try to start mysql using
>mysqld_safe & I get following error:
>Starting mysqld-max daemon with databases from /var/lib/mysql
>/usr/bin/mysqld_safe: line 307: /var/lib/mysql/linux.err: Permission
>denied
>/usr/bin/mysqld_safe: line 313: /var/lib/mysql/linux.err: Permission
>denied
>STOPPING server from pid file /var/lib/mysql/linux.pid
>tee: /var/lib/mysql/linux.err: Permission denied
>050306 03:33:03  mysqld ended
>tee: /var/lib/mysql/linux.err: Permission denied
>
>I tried using mysqld_safe --basedir=/data/mysql
>--datadir=/data/mysql --user=mysql &
>Then I get error
>Starting mysqld-max daemon with databases from /data/mysql
>/usr/bin/mysqld_safe: line 307: /data/mysql/linux.err: Permission
>denied
>/usr/bin/mysqld_safe: line 313: /data/mysql/linux.err: Permission
>denied
>STOPPING server from pid file /data/mysql/linux.pid
>tee: /data/mysql/linux.err: Permission denied
>050306 03:08:03  mysqld ended
>tee: /data/mysql/linux.err: Permission denied
>
>It used to work fine when I had /var/lib/mysql folder still there.
>The data was getting written at /data/mysql. But when I moved the
>/var/lib/mysql folder to some other directory the problem started.
>I have suse 9.2. I am frustrated trying different things and I read
>all I could regar

Getting weird error when updating table

[Homam S.A.]

Whenever I try to update an ISAM table (through a join
with nother small lookup table, also ISAM), I get the
following error:

Error Code : 1114
The table '#sql_910_0' is full

I read the following in the documentation:

http://dev.mysql.com/doc/mysql/en/full-table.html

But none of the reasons listed apply. It seems that
#sql_910_0 is some temp table that MySQL is using to
temporary spool intermediate results. But it doesn't
exist anywhere in my file system.

Have you guys gotten such an error?





__ 
Celebrate Yahoo!'s 10th Birthday! 
Yahoo! Netrospective: 100 Moments of the Web 
http://birthday.yahoo.com/netrospective/

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Hebrew

[John Berman]

How's this


+--+---+
| Variable_name| Value |
+--+---+
| character_set_client | latin1|
| character_set_connection | latin1|
| character_set_database   | hebrew|
| character_set_results| latin1|
| character_set_server | latin1|
| character_set_system | utf8  |
| character_sets_dir   | /usr/mysql4/share/mysql/charsets/ |
+--+---+


John B

-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED] 
Sent: 07 March 2005 12:28
To: mysql@lists.mysql.com
Subject: Re: Hebrew

Hello.

> Pointers were I went wrong would be appreciated

What's the default character set for your server? Please, send
us an output of the following statement:

  show variables like '%char%';

Please, use mysql command line client.



"John Berman" <[EMAIL PROTECTED]> wrote:
> Using 4.1
> 
> Though I had it cracked ?
> 
> I created a new table and set the Charset to Hebrew and the field =
> =A0Collation
> to hebrew_general_ci=A0
> 
> I then uploaded data to the database using MS Acess (with an ODBC
> connection)
> 
> In MSAccess on my PC the Hebrew comes through fine.
> 
> However when I open the newly created table using MSAccess or phpMyAdmin
> the Hebrew is represented with question marks.
> 
> Pointers were I went wrong would be appreciated
> 
> Regards
> 
> John Berman
> 
> --=20
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.6.2 - Release Date: 04/03/2005
> =20
> 
> 


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


-- 
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.6.2 - Release Date: 04/03/2005
 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.6.2 - Release Date: 04/03/2005
 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL and DNS problem

[Ed Pauley II]

I have 3 different MySQL server setups. On two of the servers, one 
running 4.0 and one running 4.1, I have seen a peculiar problem. It 
seems that when a client server is taken offline for a period of time 
(few hours to couple of days) and is brought back online, MySQL has a 
problem resolving the hostname and the clients are denied access. 
Obviously my privileges are setup by hostname instead of IP. I have also 
seen a weird problem with one client that makes and closes a lot of 
connections. MySQL cannot resolve this servers hostname for brief 
periods around the same time every day. Are there any known issues with 
MySQL and its internal DNS caching? Could there be something wrong with 
my DNS servers configuration? It just seems odd that it works fine 99.9% 
of the time. I suppose I will have to change my privileges to use IPs.

Any help or input would be appreciated.
Thanks,
Ed
--
Ed Pauley II
[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Join Limits

[SGreen]

I agree with Greg, your data structure may be getting in your way. It's 
more "normalized" to make a list of values into rows of values, not into 
lots of columns. 

I may have had a similar design problem as you are facing. I have to deal 
with LOADS of laboratory analysis data (lots of data points for each 
sample) and rather than build a table "wide" enough to hold every possible 
analysis result (one row per sample), I normalized the data into two 
tables a "sample" table and a "results" table. I have been having 
excellent results with maintaining the data, with data retrieval times, 
and maintaining the user interface code.  Everything is so much more 
simple than if I had used a single row per result.

If you can, will you please post an example of your data structure? You 
can change all of the names you like so long as we get an idea of what you 
are trying to deal with. How do you need to use this data? I ask that 
because you can usually optimize query speed with good database design. 
What is an example of the query you are trying to write? Is this a common 
query or a special case?




Greg Fortune <[EMAIL PROTECTED]> wrote on 03/07/2005 01:46:18 PM:

> Any chance of condensing some of the flag fields into bit fields? 
> Alternatively, can you represent the variables as (rule id, variable 
name, 
> variable value) in a single table rather than using lots of 
columns/tables?
> 
> Greg Fortune
> 
> On Monday 07 March 2005 10:31 am, Kevin Cowley wrote:
> > Unfortunately both limits are getting in our way.
> >
> > We have approximately 32,000 variables scattered across a number of
> > tables that we need to convert to bitmaps. The problem is that about
> > 1500 of these variables need to go in a single bitmap hence the 
problems
> > with the 1024/64 column/table limit.
> >
> > If you're correct and its using a bitmap in the optimizer, then it 
means
> > its possible to extend the value by replacing the bitmap with a
> > structure and a clever set of functions. I've used this technique in
> > another application to overcome a 32 bit limit - its probably going to
> > be a bastard of a job to rewrite the relevant parts of MySql though.
> >
> > Kevin Cowley
> > Product Development
> > Alchemetrics Ltd
> > SMARTER DATA , FASTER
> > Tel: 0118 902 9000 (swithcboard)
> > Tel: 0118 902 9099 (direct)
> > Web: www.alchemetrics.co.uk
> > Email: [EMAIL PROTECTED]
> >
> > > -Original Message-
> > > From: Eric Bergen [mailto:[EMAIL PROTECTED]
> > > Sent: 07 March 2005 18:16
> > > To: Kevin Cowley
> > > Cc: mysql@lists.mysql.com
> > > Subject: Re: Join Limits
> > >
> > > The join table limit in MySQL is dictated by the arch that's running
> > > on. 32 tables for 32bit and 64 tables for 64bit (Somebody correct me
> > > if I'm wrong). I believe this is due to using a bitmap inside the 
join
> > > optimizer to keep track of tables. 64 tables is a very hefty query 
it
> > > makes me think that maybe you are doing something wrong when 
designing
> > > your application to need a join that big. When the optimizer 
optimizes
> > > a query it checks every possible execution path through every table 
so
> > > the more joins you have the more paths the opimizer has to check to
> > > find the optimal one (This isn't entirely true but close enough for 
my
> > > argument here).
> > >
> > > Needing more than 1024 columns in a table also seems like bad 
design.
> > > Maybe you can detail more of what you are doing and why you need so
> > > many columns
> > >
> > > -Eric
> > >
> > >
> > > On Mon, 7 Mar 2005 12:21:52 -, Kevin Cowley
> > >
> > > <[EMAIL PROTECTED]> wrote:
> > > > Does anyone know if there is a method of circumventing or changing
> >
> > the
> >
> > > > default join limits of 64 tables or 1024 columns? We're running
> >
> > Mysql
> >
> > > > 4.1.4 using MyISAM tables
> > > >
> > > > Kevin Cowley
> > > > Product Development
> > > > Alchemetrics Ltd
> > > > SMARTER DATA , FASTER
> > > > Tel: 0118 902 9000 (swithcboard)
> > > > Tel: 0118 902 9099 (direct)
> > > > Web: www.alchemetrics.co.uk 
> > > > Email: [EMAIL PROTECTED]
> >
> > 

> > **
> >
> > > 
> > >
> > > > ALCHEMETRICS LIMITED (ALCHEMETRICS)
> > > > Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX
> > > > Tel:  +44 (0) 118 902 9000Fax:  +44 (0) 118 902 9001
> > > > This e-mail is confidential and is intended for the use of the
> >
> > addressee
> >
> > > only.
> > >
> > > > If you are not the intended recipient, you are hereby notified 
that
> >
> > you
> >
> > > must
> > >
> > > > not use, copy, disclose, otherwise disseminate or take any action
> >
> > based
> >
> > > on this e-mail or any information herein.
> > >
> > > > If you receive this transmission in error, please notify the 
sender
> > > > immediately by reply e-mail or by using the contact details above
> >
> > and
> >
> > > then
> > >
> > > > delete this e

RE: what is select_limit (and what is it used for)?

[Caron, Christian]

Ok, thanks.

-
Christian Caron

> -Original Message-
> From: Greg Fortune [mailto:[EMAIL PROTECTED]
> Sent: 7 mars, 2005 13:58
> To: mysql@lists.mysql.com
> Cc: Caron, Christian
> Subject: Re: what is select_limit (and what is it used for)?
> 
> 
> It only affects the client and only when the --safe-updates, 
> --i-am-a-dummy, 
> -U flag is used.  I assume it just places an explicit limit 
> clause of LIMIT 
> 1000 on the end of any select statement run from the client.  
> It's meant to 
> keep less experienced users from running a couple of cross 
> product joins that 
> output millions of lines of data.
> 
> Greg Fortune
> 
> On Monday 07 March 2005 10:48 am, Caron, Christian wrote:
> > Hi,
> >
> > the default "select_limit" is set to 1000. What does this 
> mean and how can
> > it affect a server?
> >
> > Is there some information out there about this variable? I 
> can't find
> > anything except a one line description on the MySQL site...
> >
> > -
> > Christian Caron
> 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: what is select_limit (and what is it used for)?

[Greg Fortune]

It only affects the client and only when the --safe-updates, --i-am-a-dummy, 
-U flag is used.  I assume it just places an explicit limit clause of LIMIT 
1000 on the end of any select statement run from the client.  It's meant to 
keep less experienced users from running a couple of cross product joins that 
output millions of lines of data.

Greg Fortune

On Monday 07 March 2005 10:48 am, Caron, Christian wrote:
> Hi,
>
> the default "select_limit" is set to 1000. What does this mean and how can
> it affect a server?
>
> Is there some information out there about this variable? I can't find
> anything except a one line description on the MySQL site...
>
> -
> Christian Caron

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

what is select_limit (and what is it used for)?

[Caron, Christian]

Hi,

the default "select_limit" is set to 1000. What does this mean and how can
it affect a server?

Is there some information out there about this variable? I can't find
anything except a one line description on the MySQL site...

-
Christian Caron

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Join Limits

[Greg Fortune]

Any chance of condensing some of the flag fields into bit fields?  
Alternatively, can you represent the variables as (rule id, variable name, 
variable value) in a single table rather than using lots of columns/tables?

Greg Fortune

On Monday 07 March 2005 10:31 am, Kevin Cowley wrote:
> Unfortunately both limits are getting in our way.
>
> We have approximately 32,000 variables scattered across a number of
> tables that we need to convert to bitmaps. The problem is that about
> 1500 of these variables need to go in a single bitmap hence the problems
> with the 1024/64 column/table limit.
>
> If you're correct and its using a bitmap in the optimizer, then it means
> its possible to extend the value by replacing the bitmap with a
> structure and a clever set of functions. I've used this technique in
> another application to overcome a 32 bit limit - its probably going to
> be a bastard of a job to rewrite the relevant parts of MySql though.
>
> Kevin Cowley
> Product Development
> Alchemetrics Ltd
> SMARTER DATA , FASTER
> Tel: 0118 902 9000 (swithcboard)
> Tel: 0118 902 9099 (direct)
> Web: www.alchemetrics.co.uk
> Email: [EMAIL PROTECTED]
>
> > -Original Message-
> > From: Eric Bergen [mailto:[EMAIL PROTECTED]
> > Sent: 07 March 2005 18:16
> > To: Kevin Cowley
> > Cc: mysql@lists.mysql.com
> > Subject: Re: Join Limits
> >
> > The join table limit in MySQL is dictated by the arch that's running
> > on. 32 tables for 32bit and 64 tables for 64bit (Somebody correct me
> > if I'm wrong). I believe this is due to using a bitmap inside the join
> > optimizer to keep track of tables. 64 tables is a very hefty query it
> > makes me think that maybe you are doing something wrong when designing
> > your application to need a join that big. When the optimizer optimizes
> > a query it checks every possible execution path through every table so
> > the more joins you have the more paths the opimizer has to check to
> > find the optimal one (This isn't entirely true but close enough for my
> > argument here).
> >
> > Needing more than 1024 columns in a table also seems like bad design.
> > Maybe you can detail more of what you are doing and why you need so
> > many columns
> >
> > -Eric
> >
> >
> > On Mon, 7 Mar 2005 12:21:52 -, Kevin Cowley
> >
> > <[EMAIL PROTECTED]> wrote:
> > > Does anyone know if there is a method of circumventing or changing
>
> the
>
> > > default join limits of 64 tables or 1024 columns? We're running
>
> Mysql
>
> > > 4.1.4 using MyISAM tables
> > >
> > > Kevin Cowley
> > > Product Development
> > > Alchemetrics Ltd
> > > SMARTER DATA , FASTER
> > > Tel: 0118 902 9000 (swithcboard)
> > > Tel: 0118 902 9099 (direct)
> > > Web: www.alchemetrics.co.uk 
> > > Email: [EMAIL PROTECTED]
>
> 
> **
>
> > 
> >
> > > ALCHEMETRICS LIMITED (ALCHEMETRICS)
> > > Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX
> > > Tel:  +44 (0) 118 902 9000Fax:  +44 (0) 118 902 9001
> > > This e-mail is confidential and is intended for the use of the
>
> addressee
>
> > only.
> >
> > > If you are not the intended recipient, you are hereby notified that
>
> you
>
> > must
> >
> > > not use, copy, disclose, otherwise disseminate or take any action
>
> based
>
> > on this e-mail or any information herein.
> >
> > > If you receive this transmission in error, please notify the sender
> > > immediately by reply e-mail or by using the contact details above
>
> and
>
> > then
> >
> > > delete this e-mail.
> > > Please note that e-mail may be susceptible to data corruption,
> >
> > interception and unauthorised amendment.  Alchemetrics does not accept
>
> any
>
> > liability for
> >
> > > any such corruption, interception, amendment or the consequences
> >
> > thereof.
>
> 
> **
>
> > 
> >
> >
> >
> >
> > --
> > Eric Bergen
> > [EMAIL PROTECTED]
> > http://www.ebergen.net
>
> ***
>*** ALCHEMETRICS LIMITED (ALCHEMETRICS)
> Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX
> Tel:  +44 (0) 118 902 9000Fax:  +44 (0) 118 902 9001
> This e-mail is confidential and is intended for the use of the addressee
> only. If you are not the intended recipient, you are hereby notified that
> you must not use, copy, disclose, otherwise disseminate or take any action
> based on this e-mail or any information herein. If you receive this
> transmission in error, please notify the sender immediately by reply e-mail
> or by using the contact details above and then delete this e-mail.
> Please note that e-mail may be susceptible to data corruption, interception
> and unauthorised amendment.  Alchemetrics does not accept any liability for
> any such corruption, interception, amendment or the consequences thereof.
> *

Re: Hebrew

[Gleb Paharenko]

Hello.



> Pointers were I went wrong would be appreciated



What's the default character set for your server? Please, send

us an output of the following statement:



  show variables like '%char%';



Please, use mysql command line client.







"John Berman" <[EMAIL PROTECTED]> wrote:

> Using 4.1

> 

> Though I had it cracked ?

> 

> I created a new table and set the Charset to Hebrew and the field =

> =A0Collation

> to hebrew_general_ci=A0

> 

> I then uploaded data to the database using MS Acess (with an ODBC

> connection)

> 

> In MSAccess on my PC the Hebrew comes through fine.

> 

> However when I open the newly created table using MSAccess or phpMyAdmin

> the Hebrew is represented with question marks.

> 

> Pointers were I went wrong would be appreciated

> 

> Regards

> 

> John Berman

> 

> --=20

> No virus found in this outgoing message.

> Checked by AVG Anti-Virus.

> Version: 7.0.308 / Virus Database: 266.6.2 - Release Date: 04/03/2005

> =20

> 

> 



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

RE: Join Limits

[Kevin Cowley]

Unfortunately both limits are getting in our way. 

We have approximately 32,000 variables scattered across a number of
tables that we need to convert to bitmaps. The problem is that about
1500 of these variables need to go in a single bitmap hence the problems
with the 1024/64 column/table limit.

If you're correct and its using a bitmap in the optimizer, then it means
its possible to extend the value by replacing the bitmap with a
structure and a clever set of functions. I've used this technique in
another application to overcome a 32 bit limit - its probably going to
be a bastard of a job to rewrite the relevant parts of MySql though.

Kevin Cowley
Product Development
Alchemetrics Ltd
SMARTER DATA , FASTER
Tel: 0118 902 9000 (swithcboard)
Tel: 0118 902 9099 (direct)
Web: www.alchemetrics.co.uk
Email: [EMAIL PROTECTED]

> -Original Message-
> From: Eric Bergen [mailto:[EMAIL PROTECTED]
> Sent: 07 March 2005 18:16
> To: Kevin Cowley
> Cc: mysql@lists.mysql.com
> Subject: Re: Join Limits
> 
> The join table limit in MySQL is dictated by the arch that's running
> on. 32 tables for 32bit and 64 tables for 64bit (Somebody correct me
> if I'm wrong). I believe this is due to using a bitmap inside the join
> optimizer to keep track of tables. 64 tables is a very hefty query it
> makes me think that maybe you are doing something wrong when designing
> your application to need a join that big. When the optimizer optimizes
> a query it checks every possible execution path through every table so
> the more joins you have the more paths the opimizer has to check to
> find the optimal one (This isn't entirely true but close enough for my
> argument here).
> 
> Needing more than 1024 columns in a table also seems like bad design.
> Maybe you can detail more of what you are doing and why you need so
> many columns
> 
> -Eric
> 
> 
> On Mon, 7 Mar 2005 12:21:52 -, Kevin Cowley
> <[EMAIL PROTECTED]> wrote:
> > Does anyone know if there is a method of circumventing or changing
the
> > default join limits of 64 tables or 1024 columns? We're running
Mysql
> > 4.1.4 using MyISAM tables
> >
> > Kevin Cowley
> > Product Development
> > Alchemetrics Ltd
> > SMARTER DATA , FASTER
> > Tel: 0118 902 9000 (swithcboard)
> > Tel: 0118 902 9099 (direct)
> > Web: www.alchemetrics.co.uk 
> > Email: [EMAIL PROTECTED]
> >
> >
>

**
> 
> > ALCHEMETRICS LIMITED (ALCHEMETRICS)
> > Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX
> > Tel:  +44 (0) 118 902 9000Fax:  +44 (0) 118 902 9001
> > This e-mail is confidential and is intended for the use of the
addressee
> only.
> > If you are not the intended recipient, you are hereby notified that
you
> must
> > not use, copy, disclose, otherwise disseminate or take any action
based
> on this e-mail or any information herein.
> > If you receive this transmission in error, please notify the sender
> > immediately by reply e-mail or by using the contact details above
and
> then
> > delete this e-mail.
> > Please note that e-mail may be susceptible to data corruption,
> interception and unauthorised amendment.  Alchemetrics does not accept
any
> liability for
> > any such corruption, interception, amendment or the consequences
> thereof.
> >
>

**
> 
> >
> >
> 
> 
> --
> Eric Bergen
> [EMAIL PROTECTED]
> http://www.ebergen.net


**
ALCHEMETRICS LIMITED (ALCHEMETRICS)
Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX
Tel:  +44 (0) 118 902 9000Fax:  +44 (0) 118 902 9001
This e-mail is confidential and is intended for the use of the addressee only.
If you are not the intended recipient, you are hereby notified that you must 
not use, copy, disclose, otherwise disseminate or take any action based on this 
e-mail or any information herein.
If you receive this transmission in error, please notify the sender
immediately by reply e-mail or by using the contact details above and then
delete this e-mail.
Please note that e-mail may be susceptible to data corruption, interception and 
unauthorised amendment.  Alchemetrics does not accept any liability for 
any such corruption, interception, amendment or the consequences thereof.
**


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Join Limits

[Eric Bergen]

The join table limit in MySQL is dictated by the arch that's running
on. 32 tables for 32bit and 64 tables for 64bit (Somebody correct me
if I'm wrong). I believe this is due to using a bitmap inside the join
optimizer to keep track of tables. 64 tables is a very hefty query it
makes me think that maybe you are doing something wrong when designing
your application to need a join that big. When the optimizer optimizes
a query it checks every possible execution path through every table so
the more joins you have the more paths the opimizer has to check to
find the optimal one (This isn't entirely true but close enough for my
argument here).

Needing more than 1024 columns in a table also seems like bad design.
Maybe you can detail more of what you are doing and why you need so
many columns

-Eric


On Mon, 7 Mar 2005 12:21:52 -, Kevin Cowley
<[EMAIL PROTECTED]> wrote:
> Does anyone know if there is a method of circumventing or changing the
> default join limits of 64 tables or 1024 columns? We're running Mysql
> 4.1.4 using MyISAM tables
> 
> Kevin Cowley
> Product Development
> Alchemetrics Ltd
> SMARTER DATA , FASTER
> Tel: 0118 902 9000 (swithcboard)
> Tel: 0118 902 9099 (direct)
> Web: www.alchemetrics.co.uk 
> Email: [EMAIL PROTECTED]
> 
> **
> ALCHEMETRICS LIMITED (ALCHEMETRICS)
> Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX
> Tel:  +44 (0) 118 902 9000Fax:  +44 (0) 118 902 9001
> This e-mail is confidential and is intended for the use of the addressee only.
> If you are not the intended recipient, you are hereby notified that you must
> not use, copy, disclose, otherwise disseminate or take any action based on 
> this e-mail or any information herein.
> If you receive this transmission in error, please notify the sender
> immediately by reply e-mail or by using the contact details above and then
> delete this e-mail.
> Please note that e-mail may be susceptible to data corruption, interception 
> and unauthorised amendment.  Alchemetrics does not accept any liability for
> any such corruption, interception, amendment or the consequences thereof.
> **
> 
> 


-- 
Eric Bergen
[EMAIL PROTECTED]
http://www.ebergen.net

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: "Load Data Infile ... Repair with KeyCache" --WAY SLOW!

[mos]

At 05:18 PM 3/6/2005, Harrison Fisk wrote:
Hi,
On Mar 6, 2005, at 12:51 PM, mos wrote:
At 10:07 PM 3/2/2005, you wrote:
Hello.
You may use ALTER TABLE .. DISABLE KEYS to speed up the loading process
on the MyISAM table.
I gave that a try but I had to cancel "Alter Table ... Enable Keys" after 
49 hours. I find it amazing that it takes only 6.25 hours to load 450 
million rows into the table using Load Data Infile with the keys 
disabled, but over 49 hours (maybe a lot more) to rebuild 3 indexes.
Why do you find that amazing?  The import is pretty much a raw file copy 
by MySQL.  That 6 hours is just copying data from one place to 
another.  When you create indexes MySQL has to go through and sort the 
data.  While doing so it has to create a special structure and maintain it 
and write it to disk.  Creating an index is *much* more effort than a 
simple file copy.

 Even with 100g of disk space dedicated to the sort file. It started 
using "Repair with Filesort" for the first 7 hours, then it switched to 
"Repair with KeyCache".
It should only use one of the Repair methods.  If it switched then 
something was wrong with Repair by filesort (maybe out of disk space?)
Look in your error log and see if there is any message there about it.
There was a "[Warning] Warning: Enabling keys got errno 136, retrying" and 
it kept running for almost 2 more days. (Yes, I guess I should have checked 
earlier.)

So apparently it ran out of index space because I didn't build the table 
with Max_Rows=10 (1 billion?). I'm using NTFS so there is no 4gb 
limit. The data file is about 84g. There should have been plenty of disk 
space available for the index file.

I think what bothers me the most about all this is I'm kept in the dark 
about the progress of rebuilding the index (or table). Wouldn't it be nice 
if the "Show Process List" could say "10% complete" or "99% complete"? If 
it sat at 5% complete for a few hours (days?), then I would know something 
was wrong. But if the progress steadily increased every few hours and when 
it got to 99% complete I would know it is almost complete. I could let my 
client know it is 99% complete rather than saying "I don't know" every few 
hours. I would like to see this "% complete" as a feature so people aren't 
kept in the dark. At least then they would know whether the process is hung 
or not.

Just my 2 cents.
Mike

What did you have your myisam_* variables set to?
I don't know anyone who can afford to take their database down for a few 
days (weeks?) while building an index.
How often do you need to load in 450 million rows?  Generally this only 
occurs once, or in a batch process, such as once per month.  I don't know 
what your expectations are, but this is never going to be a very fast 
process under any DBMS.  Importing 450M rows will take some decent amount 
of time.

Mike

mos <[EMAIL PROTECTED]> wrote:
> I have a 50g CSV file that I am trying to import into an empty MyISAM
> table. It appears to go fine except after 10 hours it hasn't completed. A
> "Show Process List" shows Info="load data infile ..." and State="Repair
> with keycache". The table has a few hundred million rows of data. I 
assume
> it is using "Repair with keycache" to rebuild the indexes after the data
> has been loaded.
>
> From what I've read "Repair with keycache" is going to take a huge amount
> of time to complete. How do I disable "Repair with keycache" and use
> "Repair with sort" instead (which should be faster, right?)? I'm using
> MySQL 4.1.10 on Win XP and 1gb ram.
>
> TIA
>
> Mike
>
>

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
Regards,
Harrison
--
Harrison C. Fisk, Trainer and Consultant
MySQL AB, www.mysql.com
Get a jumpstart on MySQL Cluster -- 
http://www.mysql.com/consulting/packaged/cluster.html

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Partial and inexact matches

[SGreen]

news <[EMAIL PROTECTED]> wrote on 03/05/2005 04:21:26 PM:

> Probably a real n00b question.
> 
> I am writing a simple contact management database with MySQL (version 
> 3.23.49-8.9, Debian Woody).  I'd like users to be able to enter the 
first 
> few characters of a contact's name to do a search, and I'd like the 
option 
> of doing inexact matches or phonetic matches.
> 
> What sort of SELECT/WHERE statement do I need to do these things?
> 
> I've combed the documentation and used Google but haven't found any such 

> thing. 
> 

Check out the following comparison options

For partial word matches:
LIKE, RLIKE, REGEXP 
(http://dev.mysql.com/doc/mysql/en/string-comparison-functions.html)

For phonetic matches:
SOUNDEX (http://dev.mysql.com/doc/mysql/en/string-functions.html)

Full text searching (for starters):
http://dev.mysql.com/doc/mysql/en/fulltext-search.html
http://dev.mysql.com/doc/mysql/en/fulltext-restrictions.html

HTH ;-D

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Re: driver question

[Mark Matthews]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Scott Purcell wrote:
> Hello
> I am using org.gjt.mm.mysql.Driver to connect a web-app to a mysql database. 
> I ran into an error, I could use some help with.
>  
> I have a database that has a timestamp field
> CREATE TABLE FOO (
>create_date TIMESTAMP,
>approved_date TIMESTAMP,
> ) TYPE=InnoDB;
>  
> Now when I insert into foo, I insert the create_date of course when new foo 
> records are inserted. But I do not insert anything for the approved_date, 
> because the foo is not known yet. Anyway what I found was a problem. When 
> using the driver, and I say select * from foo, I get the following error, 
> which makes sense, because it says it cannot convert 00 which is 
> null of course. 

Scott,

'00' is _not_ NULL. It's an invalid date. There's a reason
the server does this that has to do with the fact that MyISAM doesn't
have transactions, so _every_ column has to have a default value,
however Java has no way of dealing with an all-zero datetime value.
Older versions of the driver _silently_ converted this to NULL, but it's
not correct behavior according to either the SQL standard or the JDBC
specification.

> So is this a driver problem, or just the way the driver handles the data? Any 
> ideas how to get around this?

Any reason you can't use DATETIME for one of the columns and leave that
one null when you do your inserts? TIMESTAMP is roughly the same,
however it auto-updates the value whenever the record is updated, while
DATETIMEs do not, in fact you probably want something more like:

CREATE TABLE FOO (
create_date DATETIME NOT NULL,
approved_date DATETIME NULL
) TYPE=InnoDB;

And then in your INSERT statement, use NOW() for your create_date.

-Mark


- --
Mark Matthews
MySQL AB, Software Development Manager - Connectivity
www.mysql.com

MySQL User Conference (Santa Clara CA, 18-21 April 2005)
Early registration until February 28: http://www.mysqluc.com/
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.6 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCLGjxtvXNTca6JD8RAlhGAJ98hvHSVfsZPulH/3usn0QpwKvO9ACfUO8D
BAAscENk+vUXMsRXrvttlq4=
=9Rl1
-END PGP SIGNATURE-

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Partial and inexact matches

[John Trammell]

> I'd like users to be able to enter the first 
> few characters of a contact's name to do a search, and I'd 
> like the option of doing inexact matches or phonetic matches.

MySQL does have the SOUNDEX function; see the docs for details...

  SELECT * FROM people WHERE SOUNDEX(lastname) = SOUNDEX('Smith');

I'm sure others can suggest optimizations...

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

driver question

[Scott Purcell]

Hello
I am using org.gjt.mm.mysql.Driver to connect a web-app to a mysql database. I 
ran into an error, I could use some help with.
 
I have a database that has a timestamp field
CREATE TABLE FOO (
   create_date TIMESTAMP,
   approved_date TIMESTAMP,
) TYPE=InnoDB;
 
Now when I insert into foo, I insert the create_date of course when new foo 
records are inserted. But I do not insert anything for the approved_date, 
because the foo is not known yet. Anyway what I found was a problem. When using 
the driver, and I say select * from foo, I get the following error, which makes 
sense, because it says it cannot convert 00 which is null of 
course. 
 
So is this a driver problem, or just the way the driver handles the data? Any 
ideas how to get around this?
 
 
Thanks,
Scott
 
 
 
java.sql.SQLException: Cannot convert value '00' from column 12 to T
IMESTAMP.
at com.mysql.jdbc.ResultSet.getTimestampFromString(ResultSet.java:5294)
at com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:2217)
at com.mysql.jdbc.ResultSet.getString(ResultSet.java:2132)
at com.skp.sql.Row.(Row.java:27)
at com.skp.sql.DBConn.getRows(DBConn.java:255)
at com.skp.sql.DBConn.getRows(DBConn.java:220)
at com.skp.bean.AssetBean.ShowAllAssets(AssetBean.java:30)
at com.skp.bean.AssetBean.(AssetBean.java:19)
at com.skp.taglib.displayAssetTag.doStartTag(displayAssetTag.java:43)
at org.apache.jsp.manageAssets_jsp._jspx_meth_menu_displayAssets_0(manag
eAssets_jsp.java:243)
at org.apache.jsp.manageAssets_jsp._jspService(manageAssets_jsp.java:170
)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:162)

 

 

Re: select date_format('2004-10-03 15:06:14','%m/%d/%y %T');

[Scott Hamm]

Thanks!  I'll try and import using ODBC.  Is there any good web sites
about ODBC and its operations that I can learn about it?

Scott


On Mon, 07 Mar 2005 09:26:56 +1100, Daniel Kasak
<[EMAIL PROTECTED]> wrote:
> Scott Hamm wrote:
> 
> >How do I create a table using:
> >
> >date_format('2004-10-03 15:06:14','%m/%d/%y %T');
> >
> >That way I can import Access Data?
> >
> >
> Can't do that.
> You can import Access data via ODBC - that way the driver figures out
> how to send the data to MySQL.
> I assume you are trying to export to a text file and then import from that?
> 
> The easiest way of doing this is to export your data in the correct format:
> 
> select date_format(MyDateField, '-mm-dd') as FormattedDateField
> 
> I have attached a VB function that does some fancy reformatting of
> DateTime fields. You shouldn't need it in this case ( see above ), but
> it could be handy for later. I use it this way:
> 
> - Alter the table and change your date or datetime field to a
> varchar(50) field.
> - Import into the table
> - run the attached reformat_dates() function on the table / field, which
> will format the data the correct way, and change it back to a date or
> datetime field
> 
> Hope it helps :)
<..>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Join Limits

[Kevin Cowley]

Does anyone know if there is a method of circumventing or changing the
default join limits of 64 tables or 1024 columns? We're running Mysql
4.1.4 using MyISAM tables
 
Kevin Cowley
Product Development
Alchemetrics Ltd
SMARTER DATA , FASTER
Tel: 0118 902 9000 (swithcboard)
Tel: 0118 902 9099 (direct)
Web: www.alchemetrics.co.uk  
Email: [EMAIL PROTECTED]
 


**
ALCHEMETRICS LIMITED (ALCHEMETRICS)
Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX
Tel:  +44 (0) 118 902 9000Fax:  +44 (0) 118 902 9001
This e-mail is confidential and is intended for the use of the addressee only.
If you are not the intended recipient, you are hereby notified that you must 
not use, copy, disclose, otherwise disseminate or take any action based on this 
e-mail or any information herein.
If you receive this transmission in error, please notify the sender
immediately by reply e-mail or by using the contact details above and then
delete this e-mail.
Please note that e-mail may be susceptible to data corruption, interception and 
unauthorised amendment.  Alchemetrics does not accept any liability for 
any such corruption, interception, amendment or the consequences thereof.
**

Re: Access Denied

[Gleb Paharenko]

Hello.



Are you doing FLUSH PRIVILEGES after granting?







Metal Host Contact <[EMAIL PROTECTED]> wrote:

> I have installed in a single user called "metal-host" 

> more than 10 databases all with different names 

> and in different php scripts (phpbb phpnuke mambo etc).

> the problem is that they only work as I install them,after some hour later

> all the scripts show me that error : Access denied for user:

> '[EMAIL PROTECTED]' (Using password: YES) 

> then im trying to do : GRANT ALL PRIVILEGES ON somethign.* TO

> [EMAIL PROTECTED] IDENTIFIED BY "password"; and then each database that

> i re-give  the GRANT all command works perfectly..but for 1 minute

> only,then it gives me the same : Access denied for user:

> '[EMAIL PROTECTED]' (Using password: YES)  

> So is there any limitation for the number of DBases that each user should

> run ?

> 



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

Re: Tables,

[David Logan]

Carlos Bergueira wrote:
Hi,
I need to know some things:
- Where can i get (url of document) the MySql database fields ? (For example, i
need to list all tables of a database (database: mydb) and for each table
properties like comments, size, record number, etc ?). I use PHP to write
output.
- I need to do the same with all fields of each table. (The output i need is
explain above)
Fields:  field(0), field(1), field(2), etc..
Records: 1,MyClient_1,56888554, etc...
Thanks in advance.
Cumprts,
Carlos Bergueira


O SAPO já está livre de vírus com a Panda Software, fique você também!
Clique em: http://antivirus.sapo.pt
 

Hi Carlos,
If you go to http://www.php.net and search for mysql you will find a 
number of different functions that will get you the info you need. Also 
try http://dev.mysql.com/doc/mysql/en/index.html (The english version, 
there are several possibly in languages which you may prefer)

If you need further functionality you can look at http://pear.php.net 
and look for the DB libraries. They have many functions to return column 
names etc. along with examples.

If you want practical examples, look at phpMyadmin 
(http://www.phpmyadmin.net) as this does almost exactly what you are 
trying to do, this is an open source product and you get many, many 
examples of your request.

Regards
--
David Logan
South Australia
when in trouble, or in doubt
run in circles, scream and shout
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Tables,

[Gabriel PREDA]

Hi, Carlos
> - Where can i get (url of document) the MySql database fields ? (For
example, i
> need to list all tables of a database (database: mydb) and for each table
> properties like comments, size, record number, etc ?).

You should use "SHOW TABLE STATUS" it will provide you with any info that
you need.

> - I need to do the same with all fields of each table. (The output i need
is
> explain above)
> Fields:  field(0), field(1), field(2), etc..
> Records: 1,MyClient_1,56888554, etc...

You can use any of the:
DESCRIBE `table_name`
SHOW COLUMNS FROM `table_name`

But the most verbose output you will get using:
SHOW FULL COLUMNS FROM `table_name`
This will show you collation, privileges the user has for the each column
and per-column-comment.

Verbose descriptions of the syntax can be found at
http://dev.mysql.com/doc/mysql/en/show.html

Good luck.

Gabriel PREDA
dev.falr.ro
www.amr.ro


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Tables,

[Carlos Bergueira]

Hi,

I need to know some things:

- Where can i get (url of document) the MySql database fields ? (For example, i
need to list all tables of a database (database: mydb) and for each table
properties like comments, size, record number, etc ?). I use PHP to write
output.

- I need to do the same with all fields of each table. (The output i need is
explain above)
Fields:  field(0), field(1), field(2), etc..
Records: 1,MyClient_1,56888554, etc...

Thanks in advance.

Cumprts,
Carlos Bergueira






O SAPO já está livre de vírus com a Panda Software, fique você também!
Clique em: http://antivirus.sapo.pt

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]