3
sbsize infinity bytes
vmemoryuse infinity kb
[EMAIL PROTECTED] /home #
I have upped my RAM in the unit with 512Mb to 768Mb, so I think I should
have enough RAM now.
Any other ideas?
Thanks,
Ian
> -Original Message-
> From: Jeremy Cole [mailto:[EMAIL PROTECTED]
>
sslist |
++--+---+-+-+--+---+
--+
2 rows in set (0.00 sec)
I have put more RAM in (I now have 768Mb's, as well as 3Gig of SWAP).
Thanks for the suggestions!
Cheers
Ian
> -Original Message-
> From: mos [mailto:[EMAIL PROTECTED]
> Sent: 09 June 2006 07:15 PM
> To
the memory that MySQL is allowed to use?
I am running MySQL 5.0.18
Thanks,
Ian
Sorry, forgot to send to the list aswell. My reply is at the bottom.
> -Original Message-
> From: Ian Barnes [mailto:[EMAIL PROTECTED]
> Sent: 08 June 2006 09:58 PM
> To: 'Kishore Jalleda'
> Subject: RE: Importing 3Gb File
>
>
>
> > -Origina
-timeout
Does anyone have any advice as to what I could change to make it import, and
not break half way through. The command im running to import is: mysql -n -f
-p < alldb.sql
Thanks in advance,
Ian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
k with the ANSI pronunciation, although you
still hear "sequel" being used today... and not just by old-timers :-)
- ian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
te, I altered some my.cnf parameters, and then
the site stayed up for 14 days before doing the same.
This site is identical to others I have seen - that are running with no
issues.
Could this be hardware (memory related)?
Regards,
Ian Collins.
have to handle grouping 600,000 rows! Is that
correct? Is there a better solution?
I tried using sub queries but that didn't seem to be much faster. If I
had 1,000 items to search for 60 attributes the sub queries would be
called 60,000 times.
Any ideas? Thanks!
Ian
--
Hi,
I have a customer who wants to be able to replicate their live MySQL
database to a second server, but not to have any data deleted.
i.e., they want to accumulate the data.
I don't believe you can do this with replication. Does anyone know a way
of doing this?
Cheers,
Ian.
--
Hi,
I have a customer who wants to be able to replicate their live MySQL
database to a second server, but not to have any data deleted.
i.e., they want to accumulate the data.
I don't believe you can do this with replication. Does anyone know a way
of doing this?
Cheers,
Ian.
--
1' ORDER BY
cc.ordering, cc.title, c.ordering LIMIT 0,10;
Thanks,
Ian
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: 24 January 2006 09:50 PM
To: Ian Barnes
Cc: mysql@lists.mysql.com
Subject: Re: Query Help
Ian Barnes wrote:
>Hi,
>
>This is my curr
d=cc.id AND
cc.section=s.id AND s.scope='content' AND c.sectionid='1' ORDER BY
cc.ordering, cc.title, c.ordering LIMIT 0,10;
The error I get for both ones is: Unknown column 'c.access' in 'on clause'
Thanks and sorry for the stupid question.
Cheers
Ian
-
Hi Dan,
It would be a pretty large table of changes, but this solution would work,
if as you say, I don't mind making those sacrifices. Something to think
about. Thanks.
Ian
At 03:59 PM 1/20/2006 -0600, Dan Buettner wrote:
Perhaps you could use database triggers to keep track of
Rhino,
I appreciate your comments. This wasn't meant to be a real world
example. My actual application keeps track of changing data in a gas
network. I wanted to simplify the problem to help in finding an answer to
my dilemmas.
Ian
At 04:45 PM 1/20/2006 -0500, Rhino wrote:
Ian,
I
f each field that changes into it's own table. Any
recommendations?
Thanks again.
Ian
At 12:35 AM 1/19/2006 +, Marco Neves wrote:
Ian,
I'ld like to help you, but a more specific db design would depend
on more
specific description on your application needs.
2006-02-01 | 1 | 98
2006-04-01 | 1 | 50
date | product_id | rep
2006-01-01 | 1 | rep 1
2006-03-01 | 1 | rep 2
This seems to be the cleanest solution, other than requiring a table for
every field that I want to track.
Ian
At 02:36 PM 1/18/2006 -0800, Ed Reed wrote:
I built my inventory sy
s the way I would do it.
What you think?
mpneves
On Wednesday 18 January 2006 18:09, Ian Klassen wrote:
> Hi all,
>
> I'm trying to figure out a solution to the following problem.
>
> Let's say I have a store with various products. I take inventory of these
> pr
solutions but I would end up
with hundreds of tables which I would like to avoid.
Any help on the direction that I should go would be greatly appreciated.
Ian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ings
replicate-do-db=livedb_backup
replicate-rewrite-db=livedb->livedb_backup
--->8-
Thanks
Ian
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
queries run as "system user". There is no
"system user" in the privilege tables, so I can't give the account the
privileges necessary to run triggers. As a result, the triggers always
fail and break replication.
- ian
--
+--------
triggers to be fired off my replicated queries.
- the error log gives a stack dump, and says this "could be because you
hit a bug". I'm looking for a little more information than that...
- ian
--
+-----
d SET pd.allocated = IF(
pd.stock_level>sd.intMaxStockDisplay ,
(pd.stock_level-sd.intMaxStockDisplay) , 0 ) WHERE pd.product_uid =
sd.intProductID;
I can find no reference to unsupported syntax or a bug. Has anyone else
had the same happen to them?
Ian wrote:
Hi,
On Amazon uk there are two versions of the book "High Performance MySQL ":
1st:
High Performance MySQL
~Jeremy D. Zawodny, Derek Balling
O'Reilly
Paperback - April 23, 2004
£19.95
2nd:
High Performance MySQL
~Derek J. Balling
O'Reilly Vlg. GmbH &
October 31, 2004
£29.26
Does anyone know the difference between these two books?
Has Derek Balling somehow absorbed Jeremy D. Zawodny to
become Derek J. Balling? ;)
Ian
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem I have is that the triggers
themselves are not being replicated; they exist only on the 5.0.17 slave.
- ian
--
+---+
| Ian Sales Database Administrator
w
DEFINER that was added with 5.0.17 that seems to be causing the problem.
- ian
--
+---+
| Ian Sales Databas
EFINER as a
specific user and then assigning INSERT, UPDATE, DELETE, SELECT and
SUPER privileges to that user. To no avail.
Anyone have any ideas how to resolve this?
Thanks
- ian
--
+-------+
| Ian Sales
about... Our core database
platform contains some 2,600 tables in 50 databases. And that's only one
of 8 platforms...
- ian
--
+-------+
| Ian Sales Database Adm
RE customers.id= invoices.customer_id
GROUP BY customers.id
ORDER BY customers.creation desc
Thanks!
- you need a LEFT JOIN. See http://dev.mysql.com/doc/refman/5.0/en/join.html
- ian
--
+---+
| Ian Sales
he trigger. E.g.,
CREATE TRIGGER InsPopCoord AFTER INSERT ON locations FOR EACH ROW
UPDATE zipcodes
SET zipcodes.lat=NEW.lat, zipcodes.lon=NEW.lon
WHERE zipcodes.zip=NEW.zip;
- ian
--
+---+
| Ian Sales
query failed: Can't find file: './sqllive/XHEAD.frm' (errno: 24)
The query for this particular error was: select max(id) from XHEAD
Regards,
Ian.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
query failed: Can't find file: './sqllive/XHEAD.frm' (errno: 24)
The query for this particular error was: select max(id) from XHEAD
Regards,
Ian.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
r reading communication packets)
051004 22:08:34 Aborted connection 314 to db: 'sqllive' user: 'sqllive'
host: `localhost' (Got an error reading communication packets)
My /etc/my.cnf is:
cat /etc/my.cnf
[client]
port=3306
socket=/tmp/mysql.sock
[mysqld]
port=3306
socket
query failed: Can't find file: './sqllive/XHEAD.frm' (errno: 24)
The query for this particular error was: select max(id) from XHEAD
Regards,
Ian.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
3 times and i got the follwing
error
Invalid Query Lock wait timeout exceeded; try restarting transaction
- try using SHOW INNODB STATUS. That will give you more info on table locks.
- ian
--
+---+
| Ian Sales
.
- personally, I would consider integrity, and then reliability, above
performance. But then 80% of any performance hit is in the application
code. Design a database that gives you confidence in the data it stores
first and foremost.
- ian
ings start to work well
again, but alas my SQL is auto generated, and it's hard to tune things
like that.
Anyone have any feelings about this.. is it behaving correctly and my
expectations or wrong or might it indicate a minor feature?
Kindest Regards and Many thanks for your time!
Ian.
ith 1000s of
tables/files...
- don't split data into separate tables by location. Seperate it by the
type of information.
- ian
--
+-------+
| Ian Sales
operation of the sites
that all of the servers stay in sync at all times.
Does anyone have any suggestions?
- check out http://www.ultramonkey.org/3/ It's not the perfect solution
to your problem(s), but it might help.
INTRODUCTION TO DATABASE SYSTEMS and
DATABASE IN DEPTH, both by CJ Date. For MySQL skills: there are plenty
of books on the subject, and everyone no doubt has their favourite(s).
Other than that: experience. You could try building yourself a MySQL
database at home, for something like your book o
ent on whether RDBMS are *really*
relational, check out http://www.dbdebunk.com/index.html :-)
- ian
--
+---+
| Ian Sales Database Adminis
ll have to
enforce referential integrity programmatically. MySQL won't do it for you.
- ian
--
+---+
| Ian Sales Databas
symbulos wrote:
Is it possible to substitute, using SQL command, a certain word with another
word in all the field in all the rows (tinytext) within a certain table?
- see REPLACE here:
http://dev.mysql.com/doc/mysql/en/string-functions.html
- ian
://dev.mysql.com/doc/mysql/en/string-functions.html
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| &quo
to print an error message then, or it will be displayed
on
screen.
Regards
Ian
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
esary.
- I'd recommend not using float for money. You get rounding errors.
- ian
--
+-------+
| Ian Sales Database Adm
ql/en/union.html)
--
+-------+
| Ian Sales Database Administrator |
| |
| "All your database are belong to us" |
| ebuyer
tml
which describes your problems and how to fix it.
Regards
Ian
--
exit status from /var/tmp/rpm-tmp.35848 (%build)
rpm version:rpm-build-3.0.5-9.6x
gcc:gcc-2.95.3-1c1r4
uname -sr: Linux 2.2.16C35_III
This worked fine for version 4.1.7
Does anyone have any ideas?
Regards
Ian
--
--
MySQL General Mailing List
For list archives: h
loging.
- MySQL will only allow you to join 32 tables in a single SQL statement.
- ian
--
+---+
| Ian Sales Database Administrator
SQL
goes to look them up, which is the problem.
-Original Message-
From: Ian Meyer [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 17, 2005 11:46 AM
To: mysql@lists.mysql.com
Subject: Re: MySQL and DNS problem
Jeff Smelser wrote:
On Thursday 17 February 2005 09:41 am, Ian Meyer wrote:
W
Jeff Smelser wrote:
On Thursday 17 February 2005 11:46 am, Ian Meyer wrote:
I wish we could do that, however, it's not an option as we use DHCP.. so
the IP's change, yet the hostname does not. Besides, that's just a cheap
way to avoid fixing the problem when it should work to
Jeff Smelser wrote:
On Thursday 17 February 2005 09:41 am, Ian Meyer wrote:
When trying to connect, it fails with the message:
'MySQL Error Number 1045
Access denied for user 'user'@'192.168.2.103' (using password: YES'
The 192.168.2.103 is your tip that its n
Michael Dykman wrote:
On Thu, 2005-02-17 at 12:21, Ian Meyer wrote:
Michael Dykman wrote:
On Thu, 2005-02-17 at 10:41, Ian Meyer wrote:
Hello everyone,
We have a few MySQL servers (4.1.8) running on RedHat ES3. We're having
problems when trying to use hostnames in the grant command.
Ex
Michael Dykman wrote:
On Thu, 2005-02-17 at 10:41, Ian Meyer wrote:
Hello everyone,
We have a few MySQL servers (4.1.8) running on RedHat ES3. We're having
problems when trying to use hostnames in the grant command.
Example:
create database blah;
grant all on blah.* to 'user'@
Tom Crimmins wrote:
On Thursday, February 17, 2005 10:26, Ian Meyer wrote:
Tom Crimmins wrote:
On Thursday, February 17, 2005 09:41, Ian Meyer wrote:
Hello everyone,
We have a few MySQL servers (4.1.8) running on RedHat ES3. We're
having problems when trying to use hostnames in the grant co
Tom Crimmins wrote:
On Thursday, February 17, 2005 09:41, Ian Meyer wrote:
Hello everyone,
We have a few MySQL servers (4.1.8) running on RedHat ES3. We're
having problems when trying to use hostnames in the grant command.
Example:
create database blah;
grant all on blah.* to 'u
about MySQL and DNS, but I still can't figure
this out.
Thanks,
Ian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
using date_format and now(). See
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
- ian
--
+---+
| Ian Sales Database Administrator
d the time
to read
the whole manual!
Thanks
Ian
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
y better off changing the field type to a double and placing
the
pound sign in my php code, but I am curious as to why this happens.
Is it a problem with the character sets? Should I be using a different
character set
for English language text ( no international chars ).
Any help will be appreci
an't find it on google.
- have a look at http://atmail.com/index.ehtml It's a web-based email
system that uses a MySQL database as a back-end. It's written mostly in
Perl, and there might be something you can use. The db schema, ho
m i t
h', in that order, such as Smithfield, Aerosmith, Nasmith, Smithsonian...
- ian
--
+-------+
| Ian Sales Database Administrator |
|
location ids and location names
in a lookup table, and simply write the query as a join between the
animals table and the locations table? Hard-coding the meaning of ids
into the code itself is never a good idea.
- ian
--
+-------
what. Any help is greatly appreciated!
Define DoS?
- Denial of Service...
- ian
--
+---+
| Ian Sales Database Administ
columns in the link for each role might work...
performer_group_id, performer_person_id, lyricist_person_id, etc. There
will be one row per recording of a song, although some columns on that
row may be empty.
- ian
--
+--------
s the case.
- ian
--
+-------+
| Ian Sales Database Administrator |
| |
| "If your DBA is bu
that one.
- to remove the bin logs:
PURGE MASTER LOGS TO 'filename'; (where filename is the
name of the last bin log to keep)
- if you no longer required bin-logging enabled, you must comment out
the bin-log line in you
...
>
> Please, HELP!
Hi,
The MySQL API ( libmysql.dll ) is usually in the \bin folder.
Regards
Ian
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
) to see
what caused mysqld to die.
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| "If your D
). You can then
distribute this copy as a CD based website.
This also has the advantage of working on any platform that has a web browser
and
a CD drive.
Regards
Ian
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| "If your DBA is busy all the
SET FOREIGN_KEY_CHECKS = 0 to turn off referentiality checking.
- ian
--
+---+
| Ian Sales Database Administrator |
| |
|
also investigate whether DBD needs / reads a special entry in the
my.ini /
my.cnf file
You might be able to do something similar under windows using SysInternals
*junction* tool ( freeware:
http://www.sysinternals.com/ntw2k/source/misc.shtml )
but I believe this only works with directories.
Ian
--
[EMAIL PROTECTED] wrote:
I would think that the Jan solution should execute in a single pass
through the table. The Dave (subquery) version will probably need to make 3 passes through the table get the same results.
- er, it's Ian, not Jan :-)
As was mentioned in another response
(CONCAT(status,id) LIKE 'send%',1,0)) as send,
SUM(IF(CONCAT(status,id) LIKE 'cancelled%',1,0)) as cancelled
FROM
account
GROUP BY date;
- ian
--
+---+
| Ian Sales Database Admi
On Thu, 6 Jan 2005 11:30:33 +0200
"Heikki Tuuri" <[EMAIL PROTECTED]> wrote:
> > innodb_data_file_path = ibdata2:7M;ibdata1:10M:autoextend
>
> You have to add new data files to the end of the line, not to the
> start. Please follow the instructions at
> http://dev.mysql.com/doc/mysql/en/Adding_an
On Wed, 5 Jan 2005 08:19:07 -0800 (PST)
Kentucky Families <[EMAIL PROTECTED]> wrote:
> This is a huge database so the option of using LIKE to bring up
> everything beginning with the search term will result in too many
> hits. I need a way to isolate these entries and search them on whole
> words.
Dear Heikki
Many thanks for your reply.
On Mon, 3 Jan 2005 20:41:22 +0200
"Heikki Tuuri" <[EMAIL PROTECTED]> wrote:
> are you sure that you copied the complete ibdata1 file to the new
> place? It is strange how 7 MB can be missing from the file end.
I have just checked the tar file I used to do
On Wed, 05 Jan 2005 12:22:18 +
Stephen Moretti <[EMAIL PROTECTED]> wrote:
> Kentucky Families wrote:
>
> > ... If I use a VARCHAR or TINYEXT field to enter these values and
> >I want to be able to retrieve all records where the surname field
> >contains the whole word Stotts, how would I ente
Dear MySQL people
I have a question regarding the error:
InnoDB: Error: tablespace size stored in header is 17024 pages, but
InnoDB: the sum of data file sizes is only 16576 pages
which appeared when I upgraded from 4.0.7 to 4.1.7.
Somehow I am 448 pages (7M) short of table space.
Can I fix th
.
- delete the master.info file in the data directory, and then use CHANGE
MASTER ... to set the required values before starting replication on the
slave.
- ian
--
+---+
| Ian Sales Database
dump file and see.
- ian
--
+-------+
| Ian Sales Database Administrator |
| |
| eBuyer http://www.
erver logs of anything special
going on at these times.
- one possibility could be DNS refreshes taking place... Do you have the
web server's name and IP in the hosts file on the database server?
- ian
--
+-----
ya", "HSDN
350" , "041-267733 / 077-7 " are all under clients field, Yet the info is
supposed to be distributed to all the columns of the table. What could i be
doing wrong here.
- add FIELDS TERMINATED BY ',' ENCLOSED BY '
luck there
either...
Any suggestions?
- you've got a Cartesian results set because you haven't joined the
tables. Try joining on name, or writing two queries and then using a UNION.
- ian
--
+--------
solve this .
- if you're copying the csv file between a Windows and a *NIX box, you
might have issues with carriage-return characters. Try running dos2unix
against the file to convert it.
- ian
--
+---+
| Ian
m the command line run a SQL script containing
SELECT CONCAT_WS(',', ...column names...) etc., and pipe the output into
a .csv file. Excel will happily import the data. There'll be no column
headings, though.
- ian
--
+--------
[EMAIL PROTECTED] wrote:
Need to know the similar one in MySQL. Do we have views or any other
system tables in MySQL 4.0.21 which OUTPUTS the constraints and indices
in a particular table?
- show indexes from DATABASE_NAME.TABLE_NAME
- or, show create table DATABASE_NAME.TABLE_NAME;
- ian
The only user I have does not have grant or create privileges.
> Am I screwed?
Hi,
Take a look at:
How to Reset the Root Password
http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
Regards
Ian
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
command line install options run this command and then read the txt
file
that is created ( help.txt )
mysqld-max-nt.exe --help > help.txt
There are options to install the service under a different name and with
different start
up options.
Hope this helps
Regards
Ian
--
If a slave dies, is there any way to determine that state from an
external point of view (ie: via Perl/DBD) so we can write a script of
some kind to either connect to the slave and issue a "START SLAVE" or
send the last xx lines of the .err log file to our tech staff?
I tried writing a Perl scri
Except that changes made on the master are not automatically picked up
by the slaves.
My bad, I wasn't running "START SLAVE" to get them going. Seems odd that
this has to be done manually.
Also, overnight, my slaves reported this error:
041108 19:06:42 [Note] Slave I/O thread: connected to maste
Id Study keyword
1 AK1
2 AK2
3 BK1
4 BK2
5 CK1
6 Ck3
SELECT DISTINCT Study FROM yourtablename WHERE keyword='K1' AND NOT
keyword='K2'
That *should* give you a single entry for 'C' since its keywords do not
match both 'K1' *and* 'K2'
But your posting *was* a little
After a little more RTFM-surfing, I found the "GRANT REPLICATION SLAVE"
for the master, and a "LOAD DATA" worked just fine.
Except that changes made on the master are not automatically picked up
by the slaves.
Am I missing something?
-id
--
MySQL General Mailing List
For list archives: http://li
LIENT" on the
master, which didn't work.
After a little more RTFM-surfing, I found the "GRANT REPLICATION SLAVE"
for the master, and a "LOAD DATA" worked just fine.
-id
ian douglas wrote:
One master, two slaves, mysql 4.1.7 installed via compiled source code,
on Red
One master, two slaves, mysql 4.1.7 installed via compiled source code,
on RedHat 8.0
On the master system I did this:
grant SUPER,REPLICATION CLIENT on *.* to 'repl_user'@'known.hostname1'
identified by 'repl_passwd' ;
grant SUPER,REPLICATION CLIENT on *.* to 'repl_user'@'known.hostname2'
iden
,
CaseNumber CHAR(12) NOT NULL,
Payment_Amount FLOAT(8,2),
INDEX CaseNumber ( CaseNumber ),
INDEX ID ( ID ),
INDEX ( ID )
);
On Fri, 05 Nov 2004 10:22:42 -0800, ian douglas <[EMAIL PROTECTED]> wrote:
Put Purge into backticks.
`Purge` char
Put Purge into backticks.
`Purge` char(1),
It worked great but I would like to know why, thank!
It could be that 'purge' is a reserved word in MySQL. I wanted to have a
table with a shortened name of 'description' by trying to create a table
with a 'desc' field, and MySQL had problems wi
odbc3-3.51.06.bundle
> libmyodbc3.bundle (alias)
>
> Under the ODBC Admin I have added a driver with the name
> mysqlreporting specifying the driver file path as :
This shows library with a capital L:
>
> /Library/MyODBC/lib/libmyodbc3-3.51.06.bundle.
^
Could it be that sim
101 - 200 of 387 matches
Mail list logo