We just upgraded our mysql from 5.0.32 on debian lenny, to 5.1.49 on
debian squish.
I wasn't told that it was doing an incremental version upgrade, i was
under the impression it was just going from 5.0.32 to 5.0.8x.
Anyways, I am getting some weird issues now, that is filling up the
syslog, and i
Ok, say i have this table:
CREATE TABLE `User` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(50) DEFAULT NULL,
`email` VARCHAR(50) DEFAULT NULL,
`pass` VARCHAR(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MYISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1
and i have
On Thu, 2011-04-21 at 09:35 -0400, Jerry Schwartz wrote:
> >-Original Message-
> >From: ?? [mailto:tyzha...@gmail.com]
> >Sent: Thursday, April 21, 2011 7:09 AM
> >To: mysql
> >Subject: mysql deal with specail character problem
> >
> >Hi:
> >I have a table that the field a is primary key;
>
On Thu, 2011-03-03 at 13:43 -0600, Chris W wrote:
>
> On 3/2/2011 5:59 PM, Reindl Harald wrote:
> > Am 03.03.2011 00:31, schrieb Claudio Nanni:
> >> Anyone knows how to get the server* IP address* thru SQL?
> > no, because it is nonsense and has nothing to do with a db-server
> >
> > if you connec
On Thu, 2011-01-13 at 13:51 -0700, Steve Meyers wrote:
> On 1/13/11 1:21 PM, Steve Staples wrote:
> > table type is MyISAM, it is a "customer_account" table, which holds the
> > email address, and the customer_id field, the queries that are
> > constantly being
discount the value of measuring your raw i/o performance, but
> first we should determine how your data is being stored.
>
> - michael
>
> On Thu, Jan 13, 2011 at 2:44 PM, Steve Staples wrote:
> > Hello,
> >
> > I've been noticing a little lag in my application
Hello,
I've been noticing a little lag in my application lately, it seems as
if 1 table in 1 database is getting slower to read from. Mind you,
that table is being accessed a LOT of times per second every hour of
every day, and then the "application" searches on this same table too.
In my sand
On Fri, 2010-11-05 at 15:46 +0800, Changying Li wrote:
> yes, I tried :
> mysql> explain SELECT forumid,visible,sticky,dateline FROM `abc` WHERE
> `forumid` = 25 AND `visible` = 1 AND `sticky` = 0 order by dateline \G
> *** 1. row ***
>
Ok, been googling all morning, and keep getting the same post (on
multiple different sites).
Is there a way, where i corrupt a table purposely? I've tried playing
with the .MYD file, and yeah, it "marks" it deleted under the check
routine, but the table is still readable/writable, just doesn't
Good afternoon...
I had a huge issue this weekend, we had a table crash (again), it is a
high usage table, where there are MANY writes, and reads from it all the
time (it is a radius accounting table). the problem is, is that i did:
check table radius.radacct201010 quick
and it came back fine...
Google has not been kind to me on this one, so I figured I would ask
here...
how can I select with NICE options, so that it doesn't KILL my server,
or any other queries...
Do you understand what I am asking?
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
T
What about:
select `id`, `column1` as 'column2', `column2` as 'column1';
Steve
On Wed, 2010-09-22 at 13:06 -0500, Johnny Withers wrote:
> Couldn't you just rename the columns?
>
> JW
>
>
> On Wed, Sep 22, 2010 at 11:53 AM, Rolando Edwards
> wrote:
>
> > I ran these commands:
> >
> > use tes
On Tue, 2010-09-14 at 15:45 -0400, george larson wrote:
> Daevid Vincent wrote:
> > Get this tool: http://sqlyog.com/ it rocks.
> >
> > There is also http://www.quest.com/toad-for-mysql/ which is pretty great.
> >
> >
> Alternatively, there is MySQL WorkBench. Some of the guys around here
>
>From what I read, it puts a lock on the tables (read lock). the tables
in one of the databases are continuously being written/read/updated, so
I dont want to lock them if at all possible.
Are there any other ways?
Steve
On Mon, 2010-09-13 at 15:11 +0100, a.sm...@ukgrid.net wrote:
> Why not use
Good day MySQL!
I had a table that crashed last night. There is a cron function that
goes out every 6 hours or so, that does a quick table backup (it's also
replicated, it's just something that we have running now). ANYWAY, I
think it crashed early in the evening, but when the backup ran, it lo
he Mac?
> >
> > Uwe Brauer
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=george.g.lar...@gmail.com
> >
> >
>
--
Steve Staples
Web Application Developer
519.258.2333 x8414
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi there,
I have a WEIRD question, that I can't find an answer too...
Here is my stored function:
DELIMITER $$
USE `mydatabase`$$
DROP FUNCTION IF EXISTS `SPLIT_STR`$$
CREATE definer=`thisus...@`%` FUNCTION `SPLIT_STR`(
X VARCHAR(255),
delim VARCHAR(12),
pos INT
) RETURNS VARCHAR(255) CH
Hello again!
I am trying to convert my tables to InnoDB, and i am getting an error...
Error: 1075
Incorrect table definition; there can be only one auto column and it must be
defined as a key
Now, I converted a table in my sandbox earlier this morning to do some
testing, and it worked fine... mi
@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: February 8, 2010 10:01 AM
To: mysql@lists.mysql.com
Subject: Re: MyISAM no table lock
On Mon, Feb 8, 2010 at 3:37 PM, Steve Staples wrote:
> Hi there.
>
> I was reading last week (and of course, i can't find i
Hi there.
I was reading last week (and of course, i can't find it now) something about
'nicifying' a query, so taht it doesn't lock the table...
How is this done? I've read so much stuff lately, that i can't find it for
the life of me, and google is not being my friend :(
Steve.
--
MySQL
ginal Message-
From: Steve Staples [mailto:sstap...@mnsi.net]
Sent: January 6, 2010 2:35 PM
To: mysql@lists.mysql.com
Subject: Binary Logging
Good afternoon.
I am having a weird problem with the Binary Logging of my MySQL.
For some reason, we have it on (still not sure why) but when i look in
reate them when we do go to a master/slave setup?
Once i finish moving data around, i can remove the old tables that i am
moving them out of, so I don't really see a huge issue with dumping them, i
just want to make sure.
Thanks in advance!
Steve Staples.
--
MySQL General Mailing List
Fo
Silly question here...
But can I have multiple definers for a stored proc, rather than allowing
`us...@`%`? basically, I want to only allow 1 user name, but from only 2
or 3 IP's.
My Googleing didn't turn up anything of use, so now, I am here asking :)
Thanks in advance!
Ste
23 matches
Mail list logo
