; > My question is: if I delete many records in a single delete statement
> > (i.e., DELETE FROM table WHERE id = 1 AND id = 5 ... AND ID = 100) how many
> > times are the foreign keys/indexes updated?
> >
> > Once for the entire DELETE operation or one time for each r
Hi Vikram,
As far as I know it's just table names: I think it's related to the fact
that the Windows file system is case-insensitive, while Linux
filesystems generally are not.
On Thu, 2010-03-18 at 15:18 +0530, Vikram A wrote:
> Hello Ian Simpson,
>
> Thank you for repl
purely from the webpage ?
>
> Cheers
> Neil
--
Ian Simpson
System Administrator
MyJobGroup
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
he INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
> http://in.yahoo.com/
--
Ian Simpson
System Administrator
MyJobGroup
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ost'. Has anyone ever removed this account? Do I need it or can
> I safely remove this account? I don't understand why it's there. I
> don't want to break MySQL even though there is no data or databases on
> this machine but I would like to keep this as clean as possib
n I do something like this:
>
> SELECT
> * from Projects where Project_ID = 5,
> Name from People where Projects.Boss_ID = People.ID as Boss_Name,
> Name from People where Projects.Admin_ID = People.ID as Admin_Name,
> Name from People where Projects.Assistant_ID = People.ID as
ws unless the statment include a LIMIT clause
> 3. Multiple-table SELECT statments are allowed only if MySQL will
> examine no more than 1,000,000 rows to process the query.
>
> The --i-am-a-dummy option is a synonym for --safe-updates. :)
>
> Gluck
>
> Darren
>
&g
gt; Regards
>
> John Daisley
> Mobile +44(0)7812 451238
> Email j...@butterflysystems.co.uk
>
> Certified MySQL 5 Database Administrator (CMDBA)
> Certified MySQL 5 Developer
> Cognos BI Developer
>
> -------
> Sent from HP IPAQ mobile device.
>
me unwilling to experiment with them without advice,
in case one of them disables networking or something similar.
Hoping someone can help with this.
Thanks
--
Ian Simpson
System Administrator
MyJobGroup
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
gt;
> >
> >
> > mysql> create database testdb;
> > ERROR 1044 (42000): Access denied for user 'user'@'localhost' to
> > database 'testdb'
> >
> > Can someone point out the error of my ways?
> >
> > Many thanks,
state.sql
> -- Connecting to 152.20.1.115...
> mysqldump: Got error: 1044: Access denied for user 'dip'@'152.20.1.%' to
> database 'dip' when doing LOCK TABLES
>
> Thanks,
> Krishna Chandra Prajapati
--
Ian Simpson
System Administrator
MyJobGroup
--
on 5.1.30, it did the same thing, 2 rows. But at least it DID update on
> 5.1.30, but not on 5.0.37.
>
--
Ian Simpson
System Administrator
MyJobGroup
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ame foreign key three times. You should be ok as you are specifying
a name for the constraint, and it checks for unique names.
On Fri, 2009-01-02 at 06:03 -0500, Lola J. Lee Beno wrote:
> Ian Simpson wrote:
> > If you want deletes to be blocked, then you shouldn't be using ON DE
at http://www.lolajl.net/blog/
> "No greater injury can be done to any youth than to let him feel that
> because he belongs to this or that race he will be advanced in life
> regardless of his own merits or efforts." - Booker T. Washington
>
>
--
Ian Simpson
Award Winning System Administrator
MyJobGroup
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
all is disabled.If this is caused by a firewall barrier please tell me
> how to open the port in Nortan Internet Security.
>
>
> Varuna
--
Ian Simpson
System Administrator
MyJobGroup
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
gt; I've said, we are dealing with at least 200,000 user records, probably
> 300,000-400,000 in the next year. The User table contains at least 50
> attributes, 15 of which are Foreign Keys that link to tables that will
> likely never change (the users choices for countryID, stateID
Safe Data, Inc.
> > (910) 285-7200 [EMAIL PROTECTED]
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
>
bian-sys-maint'@'localhost' IDENTIFIED BY
> PASSWORD 'LongPasswordHere' WITH GRANT OPTION
>
> To test it out, I try a mysql -u debian-sys-maint -p, type in the password
> and get the "Access denied" error again. What's going on? Why can
http://dev.mysql.com/doc/refman/5.0/en/delete.html
just search in the page for 'join' and you'll find the relevant section
On Tue, 2008-07-08 at 11:35 -0400, Jeff Mckeon wrote:
>
> > -Original Message-----
> > From: Ian Simpson [mailto:[EMAIL PROTECTED]
>
the deleted
> rows..)
>
> Can't this be done in one query? Or two?
>
> Thanks,
>
> Jeff
>
>
>
>
--
Ian Simpson
System Administrator
MyJobGroup
This email may contain confidential information and is intended for the
recipient(s) only. If an addressing o
008-06-16 13:00:00', 1);
> INSERT INTO `sales_activity` VALUES (9, '2008-06-17 13:00:00', 1);
> INSERT INTO `sales_activity` VALUES (10, '2008-06-17 13:00:00', 1);
>
> The result of the query should be:
>
> date salesreturns
> --
e current rate?
>
> Is there any way to reset that parameter so that the data can reflect
> current without restarting the MySQL
>
> Thanks in advance
> ..venu
--
Ian Simpson
System Administrator
MyJobGroup
This email may contain confidential information and is inten
es_activity` (
> `sales_id` int(11) NOT NULL auto_increment,
> `sales_date` datetime NOT NULL default '-00-00 00:00:00',
> `sales_type` tinyint(4) NOT NULL default '0',
> PRIMARY KEY (`sales_id`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=
rcentage of the bandwidth
it's using, and then doing a calculation with those numbers to get the
100% value, but I don't know if that's valid, since there are generally
a number of other operations going on at the same time.
Thanks
--
Ian Simpson
On Fri, 2008-06-13 at 08:48 -0700, Wm Mus
go) suggest
that the older server is handling roughly the same data quantities, but
just using a much lower percentage of the drive's bandwidth.
I can't seem to find a tool which reports on exactly how much write
bandwidth a drive has; everything seems to focus on reading speed.
Thanks,
this...
Thanks for all your help
--
Ian Simpson
On Fri, 2008-06-13 at 10:40 -0400, Jerry Schwartz wrote:
> >Disk usage: the older server (the one that's running fine) is running
> >more transactions per second, but has lower blocks written and read per
> >second t
Blk_read Blk_wrtn
sda 88.47 782.20 998.77 9046888130 11551757459
The new server, which is just trying to handle replication
Device:tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
sda 77.83 1367.55 2914.72 358474084 764029986
Thanks
trx_commit
Value: 1
Variable_name: sync_binlog
Value: 0
Variable_name: innodb_locks_unsafe_for_binlog
Value: OFF
Thanks
--
Ian Simpson
On Fri, 2008-06-13 at 17:43 +0530, Alex Arul Lurthu wrote:
> Please check if the my.cnf configurations to be the same.
>
entical table.
The MySQL configuration of the two databases is identical, except for
the tablespace file size (the new server has a larger tablespace
defined), and the InnoDB logs (again, new server has larger logs).
Can anybody suggest an area of investigation as to the cause?
Thanks,
--
Ian Simpso
Mark,
When you try to log-in to the new instance, are you specifying the new
port number to the client? If you don't give it the new port number,
then it will connect to the default port, which is presumably your
4.0.20 instance.
Mark-E wrote:
I have a Solaris box where MySQL 4.0.20 instanc
30 matches
Mail list logo
