Hi Alex, all!
Alex Katebi wrote:
Any information on how to run the test scripts for the embedded client.
Call the test script, mysql-test-run.pl, and pass it the option
--embedded-server
It does not support replication or cluster, so you should add
--skip-rpl --skip-ndbcluster
I have not specified any values for join_buffer_size and
sort_buffer_size. What should be the optimal values for this?
-Karthik
From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2008 10:03 AM
To: Karthik Pattabhiraman
Cc: mysql@lists.mysql.com
Subject:
I tried to make a query that joins to subqueries:
SELECT discontinued.b
FROM
(SELECT mrc_titles.title AS a
FROM mrc_titles JOIN prod ON mrc_titles.title = prod.prod_title
JOIN pub ON prod.pub_id = pub.pub_id
WHERE pub.pub_code = MRC
Hi,
Can we make adjustments in mysql or php code to display time in php sites
in EST , although server runs on CDT ?
Thanks
You can use the convert_tz function for this
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function
_convert-tz
On 10/15/08 12:03 PM, Madan Thapa [EMAIL PROTECTED] wrote:
Hi,
Can we make adjustments in mysql or php code to display time in php sites
in EST , although
On Wed, 2008-10-15 at 12:08 -0400, Olaf Stein wrote:
You can use the convert_tz function for this
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function
_convert-tz
On 10/15/08 12:03 PM, Madan Thapa [EMAIL PROTECTED] wrote:
Hi,
Can we make adjustments in mysql
Hi All,
Just some simple questions I am somehow not able to find an answer to.
- Does optimize table tablename do the same thing as mysqlcheck [options]
db_name [tables] ?
- Do they take care of large chunks of deleted data?
- and I am assuming optimize table would replicate, mysqlcheck I
All,
I am developing a service in MySQL that models a service I've already
built in PostgreSQL. I'm trying to port over some of my ideas from that
platform to MySQL. Here's the setup:
Let's say I have 2 tables: 'account' and 'widget'. Each of these tables
have a primary key but the
Date: Tue, 14 Oct 2008 16:55:11 +0300
From: Olexandr Melnyk [EMAIL PROTECTED]
To: [EMAIL PROTECTED], mysql@lists.mysql.com
Subject: Re: Problem with GROUP BY
http://jan.kneschke.de/projects/mysql/groupwise-max
2008/10/14 Peter Brawley [EMAIL PROTECTED]
Philip
mysql SELECT
Hi,
It depends on your query using join and sort. Also, on how much ram you
have. You can refer to huge_my.cnf
You can find huge_my.cnf in the complied mysql-server binary.
join 12 MB
sort 8 MB
On Wed, Oct 15, 2008 at 3:29 PM, Karthik Pattabhiraman
[EMAIL PROTECTED] wrote:
I have not
Hi,
1. Since requestid is a primary key then why you are using distinct in your
query. It's not required.
2. Index needs to be created on logtime.
3. Explain will best describe where indexing is required.
4. In your query use group by a.logtime (date_format is not required)
Your system must
Hi Krishna,
I have one more question for you. My table schema is as follows
create table RequestDO (
country VARCHAR(256),
device VARCHAR(256),
devicemanufacturer VARCHAR(256),
entryPage INTEGER,
exitPage INTEGER,
logicalPageName VARCHAR(3999),
logtime
I would do a muli key PK with a after insert trigger to that would
change widget_number 1 to 1000. Just my HO...
I would use this combo as the primary key, but I hate doing joins with
multiple primary keys, so I'll also keep the widget_id for the purpose of
making joins easier.
Why? Both of
Hello Olaf,
1) OPTIMIZE TABLE is the same as mysqlcheck with --optimize flag.
2) Both take care of large chunks of deleted data.
3) As mysqlcheck is just a frontend for OPTIMIZE TABLE command, it should be
replicated in either case.
2008/10/15, Olaf Stein [EMAIL PROTECTED]:
Hi All,
Just
There's an awesome feature that was added to PostgreSQL a while back
called RETURNING that allows you to make an INSERT, UPDATE, and DELETE
statement behave like a SELECT statement. You can do something like this:
INSERT INTO mytable (id, value)
VALUES (1, 'something')
RETURNING
On Wed, Oct 15, 2008 at 12:25 PM, D. Dante Lorenso [EMAIL PROTECTED] wrote:
There's an awesome feature that was added to PostgreSQL a while back called
RETURNING that allows you to make an INSERT, UPDATE, and DELETE statement
behave like a SELECT statement. You can do something like this:
Rob Wultsch wrote:
On Wed, Oct 15, 2008 at 12:25 PM, D. Dante Lorenso [EMAIL PROTECTED] wrote:
There's an awesome feature that was added to PostgreSQL a while back called
RETURNING that allows you to make an INSERT, UPDATE, and DELETE statement
behave like a SELECT statement. You can do
On Wed, Oct 15, 2008 at 2:00 PM, D. Dante Lorenso [EMAIL PROTECTED] wrote:
Rob Wultsch wrote:
On Wed, Oct 15, 2008 at 12:25 PM, D. Dante Lorenso [EMAIL PROTECTED]
wrote:
There's an awesome feature that was added to PostgreSQL a while back
called
RETURNING that allows you to make an INSERT,
D. Dante Lorenso wrote:
There's an awesome feature that was added to PostgreSQL a while back
called RETURNING that allows you to make an INSERT, UPDATE, and DELETE
statement behave like a SELECT statement.
...
Does RETURNING exist in any current release of MySQL or is it on the
TODO list
On Wed, Oct 15, 2008 at 2:09 PM, Rob Wultsch [EMAIL PROTECTED] wrote:
On Wed, Oct 15, 2008 at 2:00 PM, D. Dante Lorenso [EMAIL PROTECTED] wrote:
Rob Wultsch wrote:
On Wed, Oct 15, 2008 at 12:25 PM, D. Dante Lorenso [EMAIL PROTECTED]
wrote:
There's an awesome feature that was added to
20 matches
Mail list logo