On Tue, May 09, 2006 at 12:13:41PM -0400, Rhino wrote:
>
> - Original Message -
> From: "Mohammed Sameer" <[EMAIL PROTECTED]>
> To:
> Sent: Tuesday, May 09, 2006 9:56 AM
> Subject: Order by leads to an empty set.
>
>
> >Hi all,
>
Hi all,
I have a strange problem and I can't really understand what's going on!
mysql> SELECT n.nid, n.sticky, n.created FROM node n WHERE n.type='image' AND
(n.uid = 1 OR n.status = 1) ORDER BY n.created desc;
Empty set (0.00 sec)
mysql> SELECT n.nid, n.sticky, n.created FROM node n WHERE n.ty
_using mysql5
_I have a table "points" with (atleast) following fields
points_id (int, primary key), logged (datetime), sale_points(float),
available_points(float)
When a new row is inserted "available_points" is set to the value of
"sale_points"
I need to update the "available points" for
need some urgent help
im using InnoBD database type...i need to explicitly lock a row and keep it
locked until i explicitly unlock that row..
it would be great if u could provide me with sql statements as a solution for
the above...
thanks
On Fri, Mar 18, 2005 at 11:02:50AM -0600, sharif islam wrote:
> # mysqld_safe
> Starting mysqld daemon with databases from /var/lib/mysql
> STOPPING server from pid file /var/lib/mysql/mymachine.pid
> 050318 11:01:31 mysqld ended
>
> [EMAIL PROTECTED] mysql]# ls -la /var/lib/mysql
> total 40
> dr
On Fri, Dec 31, 2004 at 05:17:27PM -0600, Bob Ramsey wrote:
>
> The only snage with the header function is that you must not print or
> echo anything to the browser before you use it. In other words you
> can't do this:
>
>
>
> I moved you to another page.
> http://someotherpage.com";); ?>
>
On Sat, Jul 17, 2004 at 11:25:33PM +0200, Loic Minier wrote:
> Did other MySQL users experience this?
I can confirm this on Debian testing and fedora core 2
--
-- Katoob Main Developer
Linux registered user #224950, ICQ #58475622
--
Don't send me any attachment in Micro$oft (.D
connection, Same for the 2 webservers.
I verified this now.
>
> On May 19, 2004, at 10:34 AM, Mohammed Sameer wrote:
>
> >On Wed, May 19, 2004 at 08:47:28AM -0400, Brent Baisley wrote:
> >>Something that small shouldn't really need optimizing. What is the
> &g
l P III with 2 GB RAM and a RAID controller.
Do you think there is much to be done, or shall I look for better hardware/or
clustering ?
> On May 19, 2004, at 3:26 AM, Mohammed Sameer wrote:
>
> >Hi,
> >I'm running a MySQL server on a duel P III 1G, with 2 GB RAM.
> >MySQL
sorry Egor Egorov, Mutt sent the mail to your private inbox ;)
resending to the mailing list.
On Wed, May 19, 2004 at 02:02:29PM +0300, Egor Egorov wrote:
> Mohammed Sameer <[EMAIL PROTECTED]> wrote:
> > I'm running a MySQL server on a duel P III 1G, with 2 GB RAM.
> >
Hi,
I'm running a MySQL server on a duel P III 1G, with 2 GB RAM.
MySQL 4.0.18 compiled from source.
We have 2 webservers running apache, And this is the backend database server.
The server is really slow.
a select on a table with 138,247 rows takes about 1.6 - 2+ seconds, I have about 50%
CPU id
11 matches
Mail list logo
