Connectivity problem (?), mysql_ping ()

Hi, Is mysql_ping () suppose to restore a db connection even after a db restart? Thnx, Lefteris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: default table type = innodb is stable??

- Original Message - From: "Hiu Yen Onn" <[EMAIL PROTECTED]> > if i uncomment it, then mysql server wont start at all. if i comment it, > then, that's ok. please advise. thanks again If the mysql server does not start it will probably leave a lot of messages in the error log. If you sen

Re: default table type = innodb is stable??

hereby, i attached the my.cnf file. by default, i copied it from /usr/share/mysql/my-huge.cnf. however, i have added default table type = INNODB. from the my.cnf, i can see that there are flags for innodb table, starting from # Uncomment the following if you are using InnoDB tables #innodb_dat

Re: default table type = innodb is stable??

Are you using the my-innodb-heavy-4G.cnf file for your machine? i loaded the cnf file to /etc/my.cnf. then, it fails to start. what's wrong with it? mind to tell me on how to set the default table type equal to innodb?perhaps, can you guide me for cnf configuration for a 6G memory big machine

Re: update row/tbl question...

In the last episode (Oct 14), bruce said: > a basic/new/curious question. i have the following sample tbl schema. > i do the following update on the mysql command line and it updates > for both cases. my question is why??? > > update UserTBL set gid='25', usertype='Super Administrator11' where > u

update row/tbl question...

hi... a basic/new/curious question. i have the following sample tbl schema. i do the following update on the mysql command line and it updates for both cases. my question is why??? it was my understanding that the two cases are different and shouldn't both be triggered.the value of 'username' in

Maximum execution time?

Hi Is there a way to setup a maximum query execution time per user. I understand the options max_connections and max_questions. But I am looking for a way to kill a query per user if it takes longer than XX minutes! Thanks John -- MySQL General Mailing List For list archives: http://lists.mysql

RE: Non-linear degradation in bulk loads?

I've tried tweaking the structure of the schema to have, for example, a PRIMARY KEY index on email, no other indexes, and then insert in sorted order -- made no improvement whatsoever. Another clue that leads me to believe that this may be an OS issue: Starting a large cp on the same box (from

Re: IP Resolution

MySQL 4.1.14 is the current version. You should always upgrade to the lastest release and test your problem before trying to report bugs. Ben Clewett wrote: Dear MySQL, My MySQL 4.1.9 has lost the ability to work out what IP address clients are connecting from. Eg: $ mysqladmin processl

RE: connection issue

Than you very much . It is working Anil DBA -Original Message- From: Dobromir Velev [mailto:[EMAIL PROTECTED] Sent: Thursday, October 13, 2005 8:58 PM To: mysql@lists.mysql.com Cc: Anil Subject: Re: connection issue When you connect without specifing the host, the mysql client will tr

Re: Innodb?

"Joe Herman" <[EMAIL PROTECTED]> wrote on 10/14/2005 01:42:41 PM: > Hello, I am just starting with MySQL and PHP, but this discussion about > innodb has rather piqued my interest. Can someone please give a brief > explanation as to what it is. > > Cheers, > > Joe. In a nutshell, InnoDB is one o

Re: How to get a count from this query

Gerald Taylor <[EMAIL PROTECTED]> wrote on 10/14/2005 10:42:33 AM: > Thank you for your answer. What I'm trying to do is return the scores of >the diff values of datapoints between a particular user and all the > other users in the system. (hence the mypmd.uid != pmd.uid) Some > datapoin

Innodb?

Hello, I am just starting with MySQL and PHP, but this discussion about innodb has rather piqued my interest. Can someone please give a brief explanation as to what it is. Cheers, Joe.

Re: Importing a database error

[EMAIL PROTECTED] wrote: (response interspersed) Boris Villazon <[EMAIL PROTECTED]> wrote on 10/14/2005 08:30:13 AM: Hi I am working with MySql 4.1.14 under Windows XP. I am trying to do a database import from a file. I have the following table definiton CREATE TABLE attribute_instan

Query dies silently

Hi all, I have a rather strange problem that I cannot seem to figure out. When I run the following query from the MySQL console: SELECT Inventory.ID as InventoryID, Inventory.Name, Inventory.Capacity, Inventory.Beds, Avails.ID as AvailabilityID,

Re: Convert Subquery - need to find max of a set

[EMAIL PROTECTED] wrote: "Kristen G. Thorson" <[EMAIL PROTECTED]> wrote on 10/14/2005 09:15:21 AM: I need to convert this query into one without a subquery: SELECT r.selector_forms_results_max_points AS points, r.selector_forms_results_description AS description, FROM selector_forms

Re: Convert Subquery - need to find max of a set

"Kristen G. Thorson" <[EMAIL PROTECTED]> wrote on 10/14/2005 09:15:21 AM: > I need to convert this query into one without a subquery: > > SELECT > r.selector_forms_results_max_points AS points, > r.selector_forms_results_description AS description, > FROM selector_forms_results AS r > WH

Re: How to test the MySQL Server (windows version) ?

Hi! [EMAIL PROTECTED] wrote: "lu ming" <[EMAIL PROTECTED]> wrote on 10/14/2005 12:20:19 AM: Hi, joerg Thank you very much! But i want to know more about this problem. I find a perl script about mysql server's test in the mysql-test subdirectory(/mysql-test/mysql-test-run.pl). Is thi

Re: Importing a database error

(response interspersed) Boris Villazon <[EMAIL PROTECTED]> wrote on 10/14/2005 08:30:13 AM: > Hi > > I am working with MySql 4.1.14 under Windows XP. > > I am trying to do a database import from a file. > > I have the following table definiton > > CREATE TABLE attribute_instance ( > name v

Convert Subquery - need to find max of a set

I need to convert this query into one without a subquery: SELECT r.selector_forms_results_max_points AS points, r.selector_forms_results_description AS description, FROM selector_forms_results AS r WHERE r.selector_forms_id = 1 AND r.selector_forms_results_max_points = ( SELECT DI

Re: How to test the MySQL Server (windows version) ?

"lu ming" <[EMAIL PROTECTED]> wrote on 10/14/2005 12:20:19 AM: > Hi, joerg > > Thank you very much! > But i want to know more about this problem. I find a perl script about > mysql server's test in the mysql-test > subdirectory(/mysql-test/mysql-test-run.pl). Is this the test script >

Importing a database error

Hi I am working with MySql 4.1.14 under Windows XP. I am trying to do a database import from a file. I have the following table definiton CREATE TABLE attribute_instance ( name varchar(200) NOT NULL default '', id int(11) NOT NULL default '0', PRIMARY KEY (id,name), KEY id (id,name), KEY

Re: upload images / mp3 more Than 1 MB capacity ---- please help

Dan Buettner wrote: I tend to disagree - at my place of employment, a newspaper, we have hundreds of gigabytes of BLOB data (ad and page layouts & digital artwork) stored in SQL databases. Granted we are using Sybase for that and not MySQL but there are a lot of advantages to it - access contr

RE: Raw devices and MySQL

Hi Alec, Thanks for the response. You are probably quite right about the gains, mostly my query was through curiosity more than anything. I use raw devices with Informix and a couple of other databases and there are small improvements to be seen on these products. On very large scale implementatio

Re: Raw devices and MySQL

"Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> wrote on 14/10/2005 03:28:15: > Hi Listers, > > Does anybody know if the MyISAM engine (apart from InnoDB) allows the > use of raw disk space rather than having cooked files? If not, is this > feature likely to be included in a future release?

Re: Counting total results from a table

Alexandra wrote: Hello, I am trying to build a sql statement for MySQL 4.0.x which does count the accumulated total entries in a table per day since a specified start date. For example: Day 1 = 10 Day 2 = 12 Day 3 = 9 The statement I am using gives back the entries per day, starting each

Re: default table type = innodb is stable??

Currently i have 4 Gbyte RAM and RH 9 Linux using InnoDB and yes, it's stable :) Hiu Yen Onn wrote: hi, i have a machine with 6G memory, loaded with RHEL4. now, my question is mysql support innodb as the default table type? will be stable running RHEL4? i saw /usr/share/mysql/my-innodb-heavy

Counting total results from a table

Hello, I am trying to build a sql statement for MySQL 4.0.x which does count the accumulated total entries in a table per day since a specified start date. For example: Day 1 = 10 Day 2 = 12 Day 3 = 9 The statement I am using gives back the entries per day, starting each day with 0. For e

a question about system page.

I learn configuring the mysql server in the manul 5.3.1.I notice there is a parameter "--large pages".Please tell my how do i alter linux system memory pages . _ 免费下载 MSN Explorer: http://explorer.msn.com/lccn -- MySQL Gener

IP Resolution

Dear MySQL, My MySQL 4.1.9 has lost the ability to work out what IP address clients are connecting from. Eg: $ mysqladmin processlist ++--+---+--+-+--+---+--+ | Id | User | Host | db | Command | Time | State | Info|

default table type = innodb is stable??

hi, i have a machine with 6G memory, loaded with RHEL4. now, my question is mysql support innodb as the default table type? will be stable running RHEL4? i saw /usr/share/mysql/my-innodb-heavy-4G.cnf file, then, i replace the existing one (/etc/my.cnf). but, it failed to start the mysql server