Re: Blasted #$%$^$^ host has v3.23 when i need UNION
You may also want to look at http://www.php.net/manual/en/function.mysql-num-rows.php Ryan A wrote: Hey, Thanks for replying. Nope, the whole reason for selecting the data is the count, i need to display to the client how many records of each category he has...if there is any other way to do that (me being a newbie to mysql) I would happy to know of it. Cheers, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Dates
Joseph Bueno wrote: . . . rt3=# select age(now(),'2003-08-26'::timestamp); age 6 days 10:14:43.421275 +++ Thanks, and select age('2003-08-26',resolved) where 'resolved' is a 'timestamp'. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dates
I am in the process of porting some python scripts to Mysql. Currently, the scripts I have queries a Pg database for entries (made) between certain dates. The python script snippet of the query mainQuery = """ select distinct id,queue,owner,created,now(),age(now(),%s) from Tickets where ( (%s >= '%s'::timestamp) and ( %s <= '%s'::timestamp + '%s'::interval) ) and %s and %s(status='%s') order by id """ %(queryField,queryField,date,queryField,date,age,typeId,statusModifier,status) To make this more readable, in plain sql, the query for 7 day old entries would be: select distinct id,queue,owner,created,now(),age(now(),resolved) from Tickets where ( (resolved >= '2003-08-26'::timestamp) and ( resolved <= '2003-08-26'::timestamp + ' 7 days'::interval) ) and queue=3 and (lastupdatedby=2) and (status='resolved') order by id The problem with this that it uses 'age', 'timestamp' and 'interval' functions that are specific to Pg or just not implemeted in Mysql (version 3.23.56). What is the Mysql equivilent query? More than that, any qeuey that SQLsomeYear compliant would be great. I am considering the dates to be: resolved>='somedate1 sometime1' and resolved<='somedate2 sometime2' But, I still have a problem with: age(now(),resolved) More info (from a Pg session) to show what the Pg functions do +++ rt3=# select '2003-08-26'::timestamp + ' 7 days'::interval; ?column? - 2003-09-02 00:00:00 rt3=# select '2003-08-26'::timestamp; timestamp - 2003-08-26 00:00:00 rt3=# select age(now(),'2003-08-26'::timestamp); age 6 days 10:14:43.421275 +++ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Benchmark
I have the following setup : Apache 2 + mod_perl 2 mysql 3.23.54 I need to is measure the perfomance of a ticketing system (written in perl)which has web interface (html::mason, apache2) with Mysql as a backend. Users of the ticketing system can only connect to the backend via the web interface and they usually login to the system at the begining of the the day and remain connected untill they knock of. I have setup two test machines, one with Pg and the other with Mysql. Both machine have the same data (sample). I am looking for a benchmark utilty that the simulate a user session. For example, a user login in, displaying a ticket and searching for tickets; all these invlove a user connecting to the a url, like for search, a user needs to open "somehost.domain/path/to/search.html?with=arguments". The utiltly needs to simulate these actions. The following tools currently have so far caught my attention: Apache Jmeter ab I need suggestions for other utilities. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Perfomance Tuning
I have just installed redhat linux 9 which ships with mysql 3.23.56. Mysql has to be setup so that it can use innodb tables, and data inserts (blobs) should be able to handle at least 8M at a time. The machine has two P III 933MHz CPU's, 1.128G RAM (512M*2 + 128M), and a 36 Gig hd with 1 Gig swap and 3 equal size ext3 partitions. What would be the recomended setup for good performance considering that the db will have about 15 users for 9 hours in a day, and about 10 or so users throughout the day who wont be conistenly using the db. My configuration looks like this so far: /etc/mysql.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock max_allowed_packet=16M #InnoDB innodb_data_file_path = ibdata/ibdata1:2000M:autoextend innodb_data_home_dir = /var/lib/mysql [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid /etc/mysql.cnf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Rewrite
Would table names still be case sensitive if the connection is done through odbc? Diana Soares wrote: Read the first item that appears in MySQL manual if you search for "case sensitivity": http://www.mysql.com/doc/en/Name_case_sensitivity.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Rewrite
How can I write this query so it works on mysql 3.54: select groupmembers.memberid,users.name from groupmembers,users where (not users.name='root') and groupmembers.groupid=(select groups.id from groups where groups.type='Privileged') and groupmembers.memberid=users.id order by name And, it it possible to remove the case sensetivity of table names. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ideal setup
Perfomance matters the most. So, what would be the ideal setup for permomance in Mysql? Machine specs: PIII 1.0 GHz 640 MB Ram 36 Gig Hd partions as follows: /dev/sda1 linux swap1 Gig /dev/sda2 / 11 Gigs /dev/sda3 /var 11 Gigs /dev/sda4 Free 11 Gigs /dev/sda4 is not currently mounted, so that in future when redhat has new releases, the insallation can be made without changing the existing installtion -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Innodb table full
The size is already set to 2000M, and I may be wrong, but the autoextend feature is not support in mysql version earlier that 4. Nils Valentin wrote: Hi Mixo, Do you have the autoextend feature enabled for the innodb table ? It can be set f.e in my.cnf. Best regards Nils Valentin Tokyo/Japan 2003年 7月 8日 火曜日 22:45、mixo さんは書きました: How can I avoid this: DBD::mysql::st execute failed: The table 'Transactions' is full at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm The table type is InnoDB. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Innodb table full
How can I avoid this: DBD::mysql::st execute failed: The table 'Transactions' is full at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm The table type is InnoDB. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Benchmarking
How can I benchmark the perfomance of Mysql with the following setup: Perl 5.8.0 (perl-DBI, perl-DBI-Mysql) mysql-3.23.54a-11 apache-2.0.40-21 mod_perl-1.99_07-5 I want to compare the perfomance of Mysql against that of Pg using my own data. And, how can I resolve : "DBD::mysql::st execute failed: The table 'Attachments' is full at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm" My configuration is as follows: +++/etc/my.cnf+= [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock #InnoDB innodb_data_file_path = rt3ibdata/ibdata1:2000M; innodb_data_home_dir = /var/lib/mysql [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid +++/etc/my.cnf+= I have an additional 11Gig partition which is not is use. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql 'enum' column values
Is there a way I can get what the allowed values of an 'enum' coulmn are in mysql? I want to eventually list these values in a list box or something similar? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
entry just made in mysql table
sql,query Is there a way to find out what the value of the last entry just made in a mysql table where the field is being auto incremented? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php