learnt more from here.
On Jan 16, 2008 2:31 PM, Dan Nelson <[EMAIL PROTECTED]> wrote:
> In the last episode (Jan 16), mos said:
> > I tried :
> >
> > select SQL_NO_CACHE * from table where col1='abc';
> >
> > which took 800ms the first time it was executed. The second time it
> > was executed it
In the last episode (Jan 16), mos said:
> I tried :
>
> select SQL_NO_CACHE * from table where col1='abc';
>
> which took 800ms the first time it was executed. The second time it
> was executed it took 0ms. How is that possible if the query is not
> put into the query cache? Should the query take
mos wrote:
I tried :
select SQL_NO_CACHE * from table where col1='abc';
which took 800ms the first time it was executed. The second time it was
executed it took 0ms. How is that possible if the query is not put into
the query cache? Should the query take roughly the same amount of time?
Dis
I tried :
select SQL_NO_CACHE * from table where col1='abc';
which took 800ms the first time it was executed. The second time it was
executed it took 0ms. How is that possible if the query is not put into the
query cache? Should the query take roughly the same amount of time?
TIA
Mike
MySQL
What is method mean in your sql statement?
On Jan 15, 2008 5:33 PM, Martijn Tonies <[EMAIL PROTECTED]> wrote:
> Hi,
>
> >I am having a problem with MySQL 5.0.45 returning what I consider to be
> >unexpected results.
> >
> >Basically I am attempting the following query, and ALL records are being
>
To know the exact speed improvement ,you have to have a test yourself append
on your hardware mathine.
On Jan 15, 2008 11:39 PM, mos <[EMAIL PROTECTED]> wrote:
> At 11:25 AM 1/14/2008, Jay Pipes wrote:
> >Are you using the PREPARE STATEMENT server-side syntax or an emulated
> >prepared statement
You should post your error message here at first.
On Jan 16, 2008 4:49 AM, Saravanan <[EMAIL PROTECTED]> wrote:
> Hi,
>
> You don't need to change the hostname to reflect the new server if you run
> php from the same server. Could you post the error you get when you insert
> new records.
>
> Sara
Post your error message here.
On Jan 16, 2008 4:27 AM, MAS! <[EMAIL PROTECTED]> wrote:
> Can anyone help me to understand why my site (php 4.4.2 / ubuntu
> dapper) loose all connections to mysql server when /etc/cron/hourly
> starts? (there are no process to start hourly, the directory is empty)
Show you results of ps aux | grep mysql | grep -v grep
On Jan 14, 2008 11:41 PM, <[EMAIL PROTECTED]> wrote:
> Or maybe the pid is still existing?
>
> -Original Message-
> From: Ross Crawford [mailto:[EMAIL PROTECTED]
> Sent: Saturday, January 12, 2008 5:13 PM
> To: mysql@lists.mysql.com
>
Here is corrent sql sentence.
INSERT INTO sections (`order`,`edit`,`remove`,`section`,`type`) VALUES
('blah','blah','blah','blah','blah');
The best habit is to use backquotes beside every column you used.
You can just use function sum to get what you want.
On Jan 16, 2008 6:23 AM, Imran <[EMAIL PROTECTED]> wrote:
> Hi:
>
>
>
> I have a table that I need help to summarize the data. I need to be able
> to
> create one row of data for custno + prodno + period + weekno combination
> summarized by Invt
On Tue, January 15, 2008 14:19, Daevid Vincent wrote:
>> -Original Message-
>> From: [EMAIL PROTECTED]
>> [mailto:[EMAIL PROTECTED] On Behalf Of Baron Schwartz
>> Sent: Tuesday, January 15, 2008 1:49 PM
>> To: Daevid Vincent
>> Cc: mysql@lists.mysql.com
>> Subject: Re: does 'disable network
Hi:
I have a table that I need help to summarize the data. I need to be able to
create one row of data for custno + prodno + period + weekno combination
summarized by Invtot.
Any help will be greatly appreciated.
Best regards
I am attaching the relevant info below:
Sales
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Baron Schwartz
> Sent: Tuesday, January 15, 2008 1:49 PM
> To: Daevid Vincent
> Cc: mysql@lists.mysql.com
> Subject: Re: does 'disable networking' make mySQL faster?
>
> > > On Jan 14, 2008 7:00 AM, Da
> > On Jan 14, 2008 7:00 AM, Daevid Vincent < [EMAIL PROTECTED]> wrote:
> >
> >> I saw this on the PHP list and was wondering if there is any merit to
> it?!
> >> I would be surprised if disabling networking made a difference. I'm only
> >> concerned about the added speed. I get the security benefi
Huh? This doesn't make any sense to me.
If I'm running a LAMP box (all services on the same box), and my PHP calls
out to the mySQL database, I would expect it to use the fastest method
possible (since it's LOCAL). If that's sockets, then that's what it should
use. I would think this to be a horr
Best practice: Don't use reserved words for object (table, column,
constraint, etc.) names.
Here's your complete reserved word list for MySQL 5:
http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-refe
rence-reservedwords-5-0.html
-Original Message-
From: Rolando Edwards
Thank you so much, that worked!
--
Steve M.
on 1/15/08 3:17 PM Rolando Edwards ([EMAIL PROTECTED]) wrote:
> ORDER is a reserved word in standard SQL
>
> Example : SELECT FirstName,LastName FROM Names ORDER BY LastName,FirstName;
>
> If the column name in the table is ORDER, then put backquote
On Jan 15, 2008 4:10 PM, Pastor Steve <[EMAIL PROTECTED]> wrote:
> Thanks,
>
> Here it is:
>
> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
> that corresponds to your MySQL server version for the right syntax to use
> near 'order,edit,remove,section,type) VALUES
> ('bl
At 11:57 AM 1/15/2008, you wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I am an unabashed PostgreSQL user. However i am giving a talk on
MySQL/PostgreSQL shortly. I would like to know from a MySQL user
perspective what MySQL has over PostgreSQL, why is it good? Why would
use use
ORDER is a reserved word in standard SQL
Example : SELECT FirstName,LastName FROM Names ORDER BY LastName,FirstName;
If the column name in the table is ORDER, then put backquotes (`) around the
word ORDER when using it as a column name
INSERT INTO sections (`order`,edit,remove,section,type) VA
Thanks,
Here it is:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'order,edit,remove,section,type) VALUES
('blah','blah','blah','blah','blah')' at line 1
--
Steve M.
on 1/15/08 3:06 PM S
Hi everyone ,
I'm using a script file to do the "reset master"
command every saturday to clean up the log files. My script is called by a
bigger script that stop mysql , take server backup , then start mysql.
Just after the start command is issued the reset master scr
Hi,
Post the error.
Saravanan
--- On Wed, 1/16/08, Pastor Steve <[EMAIL PROTECTED]> wrote:
> From: Pastor Steve <[EMAIL PROTECTED]>
> Subject: Error
> To: "MySQL List"
> Date: Wednesday, January 16, 2008, 3:32 AM
> Greetings,
>
> I am trying to enter this information into a database
> called
Greetings,
I am trying to enter this information into a database called cms_md, with a
table called sections.
INSERT INTO sections (order,edit,remove,section,type) VALUES
('blah','blah','blah','blah','blah');
I am getting an error whenever I use this.
--
Steve M
Thank you
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Baron Schwartz
Sent: Tuesday, January 15, 2008 1:54 PM
To: Mark Wexler
Cc: mysql@lists.mysql.com
Subject: Re: Select multiple rows with no reference table
Hi Mark,
On Jan 15, 2008 12:51 PM, M
Hi,
You don't need to change the hostname to reflect the new server if you run php
from the same server. Could you post the error you get when you insert new
records.
Saravanan
--- On Wed, 1/16/08, meridklt <[EMAIL PROTECTED]> wrote:
> From: meridklt <[EMAIL PROTECTED]>
> Subject: Help with
Can anyone help me to understand why my site (php 4.4.2 / ubuntu
dapper) loose all connections to mysql server when /etc/cron/hourly
starts? (there are no process to start hourly, the directory is empty)
I have heavvy web/apache2 traffic on my site and that is not so nice
for my users..
t
Firstly I know nothing about MySQL but had to move hosts and followed the
export from old server to import to new server and all went well in that the
records are all there. However, I can't now upload new records as it always
says '0 ROWS ADDED'.
The php file to upload has this in: (I changed a
Hi Mark,
On Jan 15, 2008 12:51 PM, Mark Wexler <[EMAIL PROTECTED]> wrote:
> Hey folks. I just joined the list. Please let me know if I am not
> posting to the correct list.
You're in the right list.
>
> I am trying to use a select statement to retreive multiple records
> without a reference tabl
Hey folks. I just joined the list. Please let me know if I am not
posting to the correct list.
I am trying to use a select statement to retreive multiple records
without a reference table.
Obviously retreiving a single record is simple enough:
mysql> SELECT 'value1' AS var1, 'value2' AS var2;
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I am an unabashed PostgreSQL user. However i am giving a talk on
MySQL/PostgreSQL shortly. I would like to know from a MySQL user
perspective what MySQL has over PostgreSQL, why is it good? Why would
use use MySQL versus PostgreSQL? Any particu
At 11:25 AM 1/14/2008, Jay Pipes wrote:
Are you using the PREPARE STATEMENT server-side syntax or an emulated
prepared statement like in PDO?
-jay
Jay,
Currently I'm not using prepared statements at all. Before I switch,
I wanted to know how much of a speed improvement I can expect, if
Hi,
I have a partitioned table based on hash, like so:
PARTITION BY HASH(id1)
PARTITIONS 1000;
I have lots and lots of rows (therefore the high number of partitions) and
since id1 is auto-incremented the distribution is pretty even.
The problem is that every night I need to update all rows in
Moon's Father schrieb:
Because client's submit speed also affects servers's data.
please read more carefully, and make no ToFu
why should disabling networking speedup clients submit speed?
(i am not talking about using sockets, possible this is faster than using
networking, but why should d
Because client's submit speed also affects servers's data.
On Jan 14, 2008 6:54 PM, Sebastian Mendel <[EMAIL PROTECTED]> wrote:
> Moon's Father schrieb:
> >
> > On Jan 14, 2008 7:00 AM, Daevid Vincent <[EMAIL PROTECTED]> wrote:
> >
> >> I saw this on the PHP list and was wondering if there is any
Hi,
>I am having a problem with MySQL 5.0.45 returning what I consider to be
>unexpected results.
>
>Basically I am attempting the following query, and ALL records are being
>returned.
>
>" SELECT * FROM `jos_products_orders` WHERE NOT `method` "
For the uninformed, what should this do according
OldManRiver schrieb:
I uploaded the mysql console screenshot at:
http://www.sitepoint.com/forums/showthread.php?t=525160
this requires a login ...
why not just post (copy and paste) the console output, with all the commands
and results your where trying to execute?
--
Sebastian
--
MySQL G
38 matches
Mail list logo