RE: what about the stability?

Hi Bence, We are running mysql with over 1,000 tables - plenty of them have 10 Million to 40 Milion records (Geographic data) - about 500 concurrent sessions doing about 800 to 1000 queries total per second at peak. We haven't had any problems in the last 2.5 years. (our system is read heavy

RE: Mysql vs. Oracle and concat ||

Hi, You need to use : Select concat(numer,',',test) from table; See: http://www.mysql.com/doc/en/String_functions.html for more. Cheers, Andrew -Original Message- From: MySQL [mailto:[EMAIL PROTECTED]] Sent: Thursday, 26 September 2002 19:47 To: [EMAIL PROTECTED] Subject: Mysql

I have a slow query that needs optimising..

varchar(25) NOT NULL default '', KEY class_idx (class_code), KEY cat_idx (cat), KEY idx1 (class_code,cat) ) TYPE=MyISAM; - Thanks to all who try Kindest Regards, Andrew Sql, query Andrew Braithwaite Implementation Manager multimap.com e

RE: raid vs splitting the database

Hi, In my experience (assuming that you are using mysql for all of these operations) the best way is to separate your tables into read-heavy and write heavy and put each into separate databases. Put the write-heavy logs database onto a separate disk/spindle and use delayed inserts (so that the

RE: Archive of this mysql list

Yep, It's here http://www.mysql.com/documentation/searchlists.html Cheers, Andrew Sql,query -Original Message- From: Chris Becker [mailto:[EMAIL PROTECTED]] Sent: Friday, 04 October 2002 00:43 To: [EMAIL PROTECTED] Subject: Archive of this mysql list Is there an archive of

RE: Problem with moving database using mysqldump

Hi, Some of the old mysqldump apps have a bug where they're missing quotes on long rows. Try the dump the other way - i.e. use the mysqldump client on the new machine and pipe it from the old machine back to the new machine (make sure the new machine has permissions to grab from the old

RE: Re: Fwd: Re: Server comparison running Mysql

Hi James, What kind of disks are in the old system and the new system (scsi or ide, any raid, what rpm do they have etc..?) I ask this because high cpu levels can be a symptom of a diskbound server... Try running the following: iostat -x 5 5 vmstat 5 5 Let me know I'll try to help.

RE: Question about solving a query !

Is this what you're looking for? mysql select city,name,max(numbeds) from hospitals group by city; +---+--+--+ | city | name | max(numbeds) | +---+--+--+ | Lyon | Tonkin | 300 | | Marseille | Clairval | 150

MySQL Replication - v4 slave with v3 master

Hi all, Does anyone have any experience with running a v3 master and v4 slaves? Will it work? - I can't see why not... Thanks in advance, Andrew sql, query - Before posting, please check:

RE: password

Ed, I feel that your response to this problem is not in the spirit of the open source world (more like the RTFM response that you would get from a support desk). We should be encouraging new users with replies like: Yes - this is quite a common problem with new installs - you could try x, y or

RE: mysql 4.04beta

the mysql.host and the database but i don't find it yet So in which file I can't get this information ? thanks yoann Andrew Braithwaite a écrit: Hi, If I had to guess - I would say that you do not have permissions for the datadir. Try the following: Chown -R mysql:root /usr/local/mysql/data

RE: mysql 4.04beta

Hi, If I had to guess - I would say that you do not have permissions for the datadir. Try the following: Chown -R mysql:root /usr/local/mysql/data (or wherever your datadir is) And Chmod -R 660 /usr/local/mysql/data (or wherever your datadir is) Cheers, Andrew Sql, query,

reverse date_format problem

Hello All, I want to convert the string '18 October 2002' to the date format '2002-10-18' using MySQL. Essentially this is the reverse of the DATE_FORMAT(date,format) function. I'm pretty sure it can't be done but does anyone out there have any ideas? Thanks, Andrew sql,query

RE: Query and export to a Excel file

Hi, You can use mysqldump (http://www.mysql.com/doc/en/mysqldump.html) to dump the file into a tab delimited text file or cvs. You will be able to open it in excel in those formats. Alternatively (if you want to get a bit more involved) there is a perl module you could use called

RE: Query and export to a Excel file

, Sql,query -Original Message- From: Andrew Braithwaite Sent: Tue 29 October 2002 09:58 To: 'Ma, Billy'; [EMAIL PROTECTED] Subject: RE: Query and export to a Excel file Hi, You can use mysqldump (http://www.mysql.com/doc/en/mysqldump.html) to dump the file into a tab delimited text file

RE: Copying one table to another

Ed, You could use the insert .. select syntax. See: http://www.mysql.com/doc/en/INSERT_SELECT.html Cheers, Andrew -Original Message- From: [EMAIL PROTECTED] [mailto:ed;home.homes2see.com] Sent: Thursday, 14 November 2002 18:50 To: [EMAIL PROTECTED] Subject: Copying one table to

mysql return days in month?

Hi all, Can anyone help? I want to know if there is an easy way to return the number of days in a month from mysql. Ideally there would be a function that did the following... mysql SELECT DAYSINMONTH('2002-10'); +---+ | DAYINMONTH('2002-10') | +---+ |

RE: mysql return days in month?

Thanks for solving this all, I have do something ugly because I only have the -mm (3rd party DB) which ends up like this: Mysql select dayofmonth((concat('2004-02','-01') + interval 1 month) - interval 1 day); Urrggg ;) Still, much more graceful (and more future proof) than what I just

RE: Disappearing records?

Greg Macek said.. --- I have a problem that I could use some help with. We're running a mysql/php intranet site for time sheets (home grown solution). However from time to time a user will tell me hours from the previous week are just gone. I go to look and sure

RE: mysql return days in month?

Exactly... That's why Rogers solution is good (and future proof) and my solution is bad! I was illustrating that point by using 2004-02 in the example.. Andrew -Original Message- From: Pae Choi [mailto:[EMAIL PROTECTED]] Sent: 18 November 2002 22:56 To: Andrew Braithwaite; [EMAIL

RE: delete where column = null

David, I get the same behaviour with mysql 3.23.47 (not max) and with mysql v 4.0.4-beta Without the index it works fine. Must be a bug Cheers, Andrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 November 2002 16:45 To: [EMAIL PROTECTED]

RE: delete where column = null

safe equal and should work. It works fine in the delete if there is no index, which suggests that the problem is with the index, not with the comparison. Cheers, Andrew -Original Message- From: Arthur Fuller [mailto:[EMAIL PROTECTED]] Sent: 19 November 2002 17:39 To: Andrew Braithwaite

RE: The dreaded move from Oracle to MySQL

Wesley, Forgive me because I'm not overly familiar with Oracle, and this is an unproven idea If you can run the oracle export function from unix shell, you could do something like the following -- Install the mysql client on the oracle db server (will be quick and won't need any

comparing two databases in readiness for implementing replication - please stop me from spending 3 hours writing a perl script

anyone help please? Cheers, Andrew Andrew Braithwaite Implementation Manager multimap.com t: +44 020 7430 5450 e: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

why is this query not being cached.....

Hi all, I seem to have a problem with query caching with MySQL 4.0.5a. Check the two results below to see what I mean (the 2 queries were run one after another with no other changes.) I have tried it with and without and various combos of the following my.cnf settings - same result!

RE: Collective Row Concatenation

Hi, I'm pretty sure that's not possible in MySQL - sounds like the kind of thing that would be way easier to write a bit of script for instead. picky I don't think you'll get away with using 'order' as a column name either - I'm fairly sure it's a reserved name in MySQL. /picky Cheers, Andrew

replication bug? - replace into db.table being recorded in the wrong bin-log....

Hi all, This is quite an involved one... Using MySQL 4.0.11 on linux I have two logical db's on the same machine, lets say db1 and db2. I have perl apps doing the following: replace into db2.tablename . In my.cnf I have the line binlog-do-db= db1 The queries are being performed OK on

mysqladmin processlist = weird in version 4.0.12

Hi all, Anyone know why mysqladmin processlist is not showing the host that is connected, but instead is showing the following in v4.0.12: truncated excerpt +-+-+--+--+ | Id | User| Host | db | Command

RE: mysqladmin processlist = weird in version 4.0.12

that is connecting. The /etc/hosts file is fine and is the same as it was before Bug or feature? Cheers, Andrew -Original Message- From: R. Hannes Niedner [mailto:[EMAIL PROTECTED] Sent: Tuesday 18 March 2003 22:48 To: Andrew Braithwaite; MySQL Mailinglist Subject: Re: mysqladmin

RE: mysqladmin processlist = weird in version 4.0.12

Anyone else notice this, or is it just me? Andrew -Original Message- From: Andrew Braithwaite Sent: Tuesday 18 March 2003 23:05 To: 'R. Hannes Niedner'; MySQL Mailinglist Subject: RE: mysqladmin processlist = weird in version 4.0.12 Hi, I do understand what you're saying and I did

RE: Mirroring a table

If you want to mirror a single table and your DB's don't both have full access to each other then you can push one table from the server on the private IP address to the other with a cron jobby by using (in unix) the mysqldump --add-drop-table -h someserver_with_good_permissions dbname tablename |

RE: Revoking Privs

Yes it will revoke those privileges, but only after you issue a flush privileges. Generally speaking, It's a good idea to get rid of those blank entries anyway... Just make sure your apps aren't connecting to the DB with those blank uname passwd privs first.. Cheers, Andrew -Original

load data infile not being replicated properly....

Hi all, I've seen a strange replication problem with MySQL v4.0.12. Steps to duplicate... I have a table 'andrew'.. mysql desc andrew; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra |

RE: Optimize query, avoid 'using temporary'

Hi, I would add some indicies to the two tables. Looking at the below I waould add an index on the following fields: files.directory_id files.lang_id files.class_tbl access.conn_id access.group_id access.class_id You can do this easily with the alter table add index... syntax easily. It

RE: Adding index fails with error 1034: 126

Hi, What are the sizes of your index files? (i.e. name_index2.MYI in the datadir). It's a complete guess but with a large table like that, it's possible that you're reaching some kind of limit with your os/mysql setup due to file size. (greater than 4 GB would be my guess) Cheers, Andrew

RE: Insert query

Hi, I would use mediumint rather than int for the ID column (int has support for up to 2.1 Billion records wheras mediumint is up to 8.3 million - more efficient for your data type). I don't think the varchar will cause much of a problem. Useful section here:

RE: table copying/replication

Hi, Assuming that this system runs on *nix and that prod is set up to replicate to all the replicas you could write a small bash script to push the data from the stage to the prod which would then replicate as normal. I would author the script something like this... [bash]# mysqldump -e -hstage

RE: table copying/replication

or something to let your scripts do the copying (I wouldn't recommend nfs for large amounts of fast data transfer personally...) Hope this helps... Andrew -Original Message- From: Ross Simpson [mailto:[EMAIL PROTECTED] Sent: Tuesday 03 June 2003 23:57 To: Andrew Braithwaite Cc: Dathan

RE: MySQL Mirroring.

Assuming that you speak english - you can do the following... http://www.mysql.com/doc/en/Replication.html Cheers, Andrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday 04 June 2003 00:24 To: [EMAIL PROTECTED] Subject: MySQL Mirroring. Hi,

RE: Hmm looks like this query works

Try this instead... SELECT val_column, 0.1+RAND() as rand_col from TABLE ORDER BY rand_col limit 10; Cheers, A -Original Message- From: Eric Wagner [mailto:[EMAIL PROTECTED] Sent: Tuesday 10 June 2003 21:36 To: Dathan Vance Pattishall; [EMAIL PROTECTED] Subject: RE: Hmm looks like

RE: Hmm looks like this query works

Ah - I missed the weighting requirement - forget my last post then... You could try increasing the 0.1 weighting factor until it gave you the required result instead.. Cheers, Andrew -Original Message- From: Eric Wagner [mailto:[EMAIL PROTECTED] Sent: Tuesday 10 June 2003 21:36 To:

RE: empty a table

Hi, If you want this to run faster, you can use the 'truncate table' syntax as explained here: http://www.mysql.com/doc/en/TRUNCATE.html Cheers, Andrew -Original Message- From: Roger [mailto:[EMAIL PROTECTED] Sent: Tuesday 10 June 2003 23:01 To: Fabio Bernardo Cc: [EMAIL PROTECTED]

RE: Group by and Count query

You could do the following: select host,count(*) as counthost from TABLE_HOST group by 1 having counthost = 1; Which will list all the hosts with only 1 record.. Then get the numrows from that query to find uot how many there are.. Cheers, Andrew -Original Message- From: Mithun

RE: binary log

In order to help, could you post some info about both servers config (cpu speed, disk speed and OS as well as network capacity) - That would really help people understand the problem and find the bottleneck... Cheers, A -Original Message- From: Sam Jumper [mailto:[EMAIL PROTECTED]

RE: Replication troubles

In the case of both the master and the slave the max_allowed_packet is set to 1047552. In both cases I raised it to 2047552 just to be generous. In order for changes to the max_allowed_packet to take effect, you'll need to restart mysqld on that server. Cheers, Andrew -Original

RE: date format

mysql select date_sub(curdate(), interval 1 day) as wibble; ++ | wibble | ++ | 2003-06-30 | ++ 1 row in set (0.00 sec) -Original Message- From: Fabio Bernardo [mailto:[EMAIL PROTECTED] Sent: Tuesday 01 July 2003 15:32 To: Mysql (E-mail) Subject:

Replication bin log rollover....

Hi, I have a MySQL master server doing huge amounts of inserts and updates. I'm rapidly reaching the point where my binlogs will get to: myserver-bin.999 Does anyone know if MySQL treats the rollover gracefully? Will it rollover to myserver-bin.001 or will it move to a 4 figure extension? I

RE: Select not producing desired results

Hi, If you send a table def (mysqldump would be good) I will be able to experiment and come up with an answer... Cheers, Andrew -Original Message- From: Patrick Shoaf [mailto:[EMAIL PROTECTED] Sent: Wednesday 09 July 2003 20:30 To: [EMAIL PROTECTED] Subject: Select not producing

MySQL performance question..

Hi, Can anyone help? I'm running a server with a Pentium 133 w/32meg ram, 512 pipeline burst, with a wd 512MB HD and I want to store George Bush in our MySQL database. As far as table definitions are concerned, should I use a BLOB or should I store him on disk and make a reference to the

RE: Recomended RAM for production server. 3Gb overboard?

The db directory is 80mb total handling 14 requests/s with all queries being simple INSERT or SELECT's. 1GB ram should be more than enough for your needs. If you are doing lots of the same kind of selects, I would dedicate a good chunk of that memory to MySQL query caching (maybe 64MB ish).

RE: Pull updated Records without a date field?

Is there a way to pull all updated records without having a date field in each record? No. Generally speaking it's a good idea to have a timestamp field in these oft updated tables to perform just the kind of operation you describe. Cheers, Andrew -Original Message- From: Keith

RE: Turn off log-bin without restarting database

Hi, If you are using unix, comment out those lines and set a cron job for 2am to do the server restart for you... If you're using windows then comment out the lines and set ?schedule? (or whatever the ms equiv is) to do the restart at 2am. Cheers, Andrew -Original Message- From: Ian

RE: MySQL 3 and 4 side by side?

There is a doc on it here: http://mysql.us.themoes.org/doc/en/Installing_many_servers.html (the same page on www.mysql.com/doc seems to have gone missing!!) Cheers, Andrew -Original Message- From: James B. Wetterau Jr. [mailto:[EMAIL PROTECTED] Sent: Thursday 10 July 2003 23:28 To:

RE: ORDER BY with Date Format

Try: order by left(start_date,7) That will order by year then month for a standard date column.. Cheers, Andrew -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Thursday 10 July 2003 20:51 To: [EMAIL PROTECTED] Subject: ORDER BY with Date Format I am trying to

RE: Multiple concurrent MySQL question?

Paul, You need to run another server on a different port with a different socket path. See http://www.mysql.com/doc/en/Multiple_servers.html And http://www.mysql.com/doc/en/mysqld_multi.html to manage multiple MySQL servers. Cheers, Andrew -Original Message- From: Paul Maine

RE: Database Query Question

Shaun, The length can be any value between 1 and 255. (As of MySQL Version 3.23, the length of CHAR may be 0 to 255.) See http://www.mysql.com/doc/en/CHAR.html If you're looking to find the maximum length of the values in a particular column, use something like this: In table 'tablename' for

RE: No my.cnf file on Linux?

Hi - they're located in the mysql support-files dir. Choose from small, medium, large or huge depending on how you're going to use mysql. Copy rename to /etc EG: cp /usr/local/mysql/support-files/my-large.cnf /etc/my.cnf Cheers, Andrew -Original Message- From: Lindberg, Petrus

RE: Enabling Cache feature in MySQL 4

Hi, I have a server doing 26,000 queries a second so thought it was about time to enable caching. Did some research with MySQL 4 and got it to work. After running it for a while it turned out that more than 70% of queries were coming out of cache (straight out of memory not hitting the disk

query cache not working with alter table rename as...

Hi List, Anyone know what the problem is with the mysql query cache not flushing cache properly (see snip below)? Is this a bug or am I missing something here? I'm using Mysql Standard 4.0.9-gamma on Linux (x86, libc6) Any help would be appreciated, Cheers, Andrew -start

RE: query cache not working with alter table rename as...

and not hitting the disks (and I'm talking about thousands of queries per second)). Thanks again, Andrew Sql,query -Original Message- From: Sanja Byelkin [mailto:[EMAIL PROTECTED]] Sent: 23 January 2003 23:56 To: Andrew Braithwaite Cc: [EMAIL PROTECTED] Subject: query cache not working

RE: SELECTing across a Network

Please can someone tell me how to run a SELECT between databases on a network. I want to SELECT some data from a mySQL server named PC1 to a table on a second mySQL server named PC2. Thanks in advance. Hi, As long as you have a valid logon for each of the databases on each of the servers, you

RE: Is it my English or does this sound bad?

This thread is funny, When I first read the phrase in question it made perfect sense in the context in which it was written. Is the next change to the manual going to remove the example in chapter 6.4.5 UPDATE Syntax which refers to age; mysql UPDATE persondata SET age=age*2, age=age+1;

mysql privs table level security

Hi all, Can anyone help me please? I have a database with hundreds of tables and I want to lock down certain tables for select only. The order of presidence for mysql privs as far as I can tell is that if there are database level privileges, these override the table level privs. I don't want to

RE: mysql privs table level security

Any idea at all, anyone? Cheers, Andrew -Original Message- From: Andrew Braithwaite Sent: 11 February 2003 17:52 To: [EMAIL PROTECTED] Subject: mysql privs table level security Hi all, Can anyone help me please? I have a database with hundreds of tables and I want to lock down

RE: mysql privs table level security

setting table level privileges on all the tables in the database (because tables are being added and dropped all the time this would not be feasible). Help anyone? Andrew -Original Message- From: Salada, Duncan [mailto:[EMAIL PROTECTED]] Sent: 12 February 2003 16:37 To: Andrew Braithwaite

RE: Generating an automatic e-mail via MySQL

I use perl for this. Something like this: -- #!/usr/bin/perl use MIME::Base64; use Mail::Sendmail 0.77; $email = '[EMAIL PROTECTED]'; $subject = 'some stuff here'; $entire_msg = `/usr/local/mysql/bin/mysql -H -e 'some query here' somedatabase`;

RE: Generating an automatic e-mail via MySQL

February 2003 17:43 To: Andrew Braithwaite; Dan Tappin; [EMAIL PROTECTED] Subject: RE: Generating an automatic e-mail via MySQL I am interested as to why no one seems to be using the DBI/DBD-MySQL perl modules? Something like: == #!/usr/bin/perl use strict; use warnings

RE: Error 7 - Errorcode 13

Are you tring to create a fulltext index on a blob field? If so - it won't work - fulltext can use only text fields. Cheers, Andrew -Original Message- From: Sauer - brfree [mailto:[EMAIL PROTECTED]] Sent: 13 February 2003 16:36 To: Lista Mysql 1 Subject: Error 7 - Errorcode 13 I'm

RE: # of Business Days?

Can anyone out there help me with a SQL query? I need to find the number of business days between date a and b? Obviously finding simply the number of days is easy, but I have no clue how to find the number of business days. TIA! Here's some ropey perl I wrote a ages back to calculate working

bk bitkeeper to get the source for MySQL 4.1

Hello, Can anyone tell me where I can get an up-to-date copy of bz from? They're not responding to my colleague's or my own applications at their site bitmover.com. Failing that, can anyone point me in the direction of a compiled MySQL 4.1? Cheers, Andrew mysql,query

RE: What is a good benchmark?

I get the following on dual Athlon MP 1666MHz 1GB RAM which is 40% cpu loaded mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |

RE: mysql stops processing

Hi, I don't know what type of applications are using your database but if I had to guess at the problem, I would guess that you have a very slow query which runs every now and again that is locking up certain tables/records causing all the other queries to queue up and eventually running out of

RE: Re-attaching DB to mysql

Is the backup a mysqldump or a copy of the data files? Andrew -Original Message- From: Henrik Schmiediche [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 19:48 To: 'Mysql' Subject: Re-attaching DB to mysql Hello, I have a backup of a mysql v3.0.18 DB. I need to extract

RE: Re-attaching DB to mysql

data into the new but I'm happy to be corrected on that! Cheers, Andrew -Original Message- From: Henrik Schmiediche [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 20:05 To: Andrew Braithwaite; 'Mysql' Subject: RE: Re-attaching DB to mysql Copy of the data files :-( - Henrik

RE: Re-attaching DB to mysql

the mysql_convert_table_format script You've got me interested now - I should be doing real work instead... :) Andrew -Original Message- From: Andrew Braithwaite Sent: Wednesday 23 July 2003 20:59 To: 'Henrik Schmiediche'; 'Mysql' Subject: RE: Re-attaching DB to mysql Hi, If that backup uses the old .ISD

RE: Re-attaching DB to mysql

it whatever you like) and run the restore just once. This should give you a nice clean backup restore to then do whatever you want with... Andrew -Original Message- From: Henrik Schmiediche [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 21:07 To: Andrew Braithwaite; 'Mysql

RE: mysql stops processing

INNODB STATUS to the .err file every 15 seconds. What is the CPU usage from 'top' during the hang? 4.0.14 has better diagnostics than 3.23.56. An upgrade might help, but let us wait a couple of days first. joe Regards, Heikki On Wed, 2003-07-23 at 12:02, Andrew Braithwaite

RE: large mysql/innodb databases

Hi, We have similar numbers here. A couple of questions: - are they logfiles that could be rolled over on a daily basis or are they constantly updated huge tables? - is the type of backup you want incremental or a daily/weekly snapshot one? - do you have a requirement for the speed of

RE: large mysql/innodb databases

PROTECTED] Sent: Wednesday 23 July 2003 21:50 To: Andrew Braithwaite Cc: [EMAIL PROTECTED] Subject: RE: large mysql/innodb databases The data is constantly updated. There are 3 or 4 huge tables, and several smaller tables. We would love to have an incremental solution that is *guaranteed

RE: large mysql/innodb databases

, with decent reliability. And I'm trying to find the secret of eternal youth :) Cheers, Andrew -Original Message- From: Joe Shear [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 22:51 To: Andrew Braithwaite Cc: [EMAIL PROTECTED] Subject: RE: large mysql/innodb databases We

atime removal and MySQL MyISAM performance improvement

Hi All, I have a database with many files in it and our research tells us that disabling the recording of atime (access time) for that DB may have significant performance improvement. 2 questions: 1. Has anyone done this and if so, what results did they have? 2. Is the atime used in

Fulltext and Soundex

Hi All, Has anyone had any experience of using soundex with fulltext searching? I have looked through the archives and cannot find anything.. I want to avoid building my own idicies for soundex. Thanks for any help Andrew Sql,query -- MySQL General Mailing List For list archives:

RE: RAID, miiror OR replication?

Hi, Having implemented all the solutions you suggest, I would need more information to answer this problem. 1. What is the acceptable uptime of the system? 95%, 99%, 99.9%, 99.99% ? 2. In the event of a failure, what is the acceptable recovery time? None, 20 mins, 1 hr, 5 hrs, 1 day ? 3.

RE: [Fwd: MySQL w/dual-master replication?]

Is the system read-heavy or write-heavy? Cheers, Andrew -Original Message- From: Don MacAskill [mailto:[EMAIL PROTECTED] Sent: Monday 06 October 2003 20:47 To: [EMAIL PROTECTED] Subject: [Fwd: MySQL w/dual-master replication?] Hey all, I sent this a few days ago, but it may have

RE: Help With a DATETIME Query

Hi, I would do this in the application layer something like this: $list_of_days_you_want_to_look_at = ('mon','tue','wed'..); Foreach ($day in $list_of_days_you_want_to_look_at) { use a similar query to below but geared to only look at $day instead; } You should get an output like this:

RE: RAID, miiror OR replication?

Hi, Having implemented all the solutions you suggest, I would need more information to answer this problem. 1. What is the acceptable uptime of the system? 95%, 99%, 99.9%, 99.99% ? 2. In the event of a failure, what is the acceptable recovery time? None, 20 mins, 1 hr, 5 hrs, 1 day ? 3.

RE: Help With a DATETIME Query

Hi, I would do this in the application layer something like this: $list_of_days_you_want_to_look_at = ('mon','tue','wed'..); Foreach ($day in $list_of_days_you_want_to_look_at) { use a similar query to below but geared to only look at $day instead; } You should get an output like this:

FW: [Fwd: MySQL w/dual-master replication?]

Is the system read-heavy or write-heavy? Cheers, Andrew -Original Message- From: Don MacAskill [mailto:[EMAIL PROTECTED] Sent: Monday 06 October 2003 20:47 To: [EMAIL PROTECTED] Subject: [Fwd: MySQL w/dual-master replication?] Hey all, I sent this a few days ago, but it may have

RE: [Fwd: MySQL w/dual-master replication?]

, Andrew -Original Message- From: Don MacAskill [mailto:[EMAIL PROTECTED] Sent: Tuesday 07 October 2003 17:59 To: Andrew Braithwaite Cc: '[EMAIL PROTECTED]' Subject: Re: [Fwd: MySQL w/dual-master replication?] Hi Andrew, Thanks for the reply. Great question. It's a very read-heavy system

Auto generate MySQL schema based on a text file?

Hi, Does anyone know of a perl module or other code that can look at a text file (CSV, tab-delim etc..) of data and determine a MySQL table definition from it? The data may or may not have a set of column headers as the first line. I would appreciate it greatly if anyone could give me any

RE: Auto generate MySQL schema based on a text file?

it for use in my app? Would be much appreciated... Cheers, Andrew -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Tuesday 14 October 2003 19:19 To: Andrew Braithwaite; '[EMAIL PROTECTED]' Subject: Re: Auto generate MySQL schema based on a text file? At 19:05 +0100

Online Tutorials for beginners

Hi, Does anyone know of any good mysql tutorials online that would suit someone who has a computer science degree but knows nothing about MySQL. Pointers will be most welcome. Cheers, Andrew Sql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Last access time of a table

Hi everyone, Does anyone know if there is a way to get the last access time from a mysql table through mysql commands/queries? I don't want to go to the filesystem to get this info. I understand that this could be tricky especially as we have query caching turned on and serve quite a few sql

Re: slow count(1) behavior with large tables

Hi, You're doing a join on 'BoardID' on the tables MSGS and MBOARD. Is the BoardID field indexed on the MSGS table too? If not then that may be your problem. Cheers, Andrew On 15/7/05 23:31, Jon Drukman [EMAIL PROTECTED] wrote: i'm trying to run this query: SELECT COUNT(1) FROM MSGS m,

Re: Group By query optimization

Hi, Put indexes on 'valid' and 'sessiontype' and all will be good. Cheers, Andrew On 15/7/05 18:26, Kishore Jalleda [EMAIL PROTECTED] wrote: Hi All, I have a mysql query which takes 8 seconds to run ona dual xeon 2.4, 3Gig ram box, SELECT gamename, MAX(score) AS score,

Re: slow count(1) behavior with large tables

Sorry, I meant to say is the 'BoardID' field indexed on the MBOARD table too? Cheers, A On 16/7/05 00:01, Andrew Braithwaite [EMAIL PROTECTED] wrote: Hi, You're doing a join on 'BoardID' on the tables MSGS and MBOARD. Is the BoardID field indexed on the MSGS table too

possible MySQL bug - insert into 'double' column problem with mysql 4.1

Hi All, I have a strange error when trying to insert into a table with 2 'double' fields. It inserts into the 1st field OK but fills the 2nd one with nines. See below for a complete recreate. Is this a known problem? Does anyone have a solution? I'm running standard MySQL binaries on redhat

RE: possible MySQL bug - insert into 'double' column problem with mysql 4.1

Thanks; you're absolutely right - doh! It's just amazing that this ever worked in MySQL 4.0 and below... Andrew -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED] Sent: Mon, 19 Sep 2005 12:27 To: mysql@lists.mysql.com Cc: Andrew Braithwaite Subject: Re: possible MySQL bug

Re: possible MySQL bug - insert into 'double' column problem with mysql 4.1

| +---+---+---+ 2 rows in set (0.06 sec) Looks like while MySQL 4.1 was not changing what was stored in the data but changing what is inserted into new records to match the proper data tye definitions. On 19/9/05 17:49, Andrew Braithwaite [EMAIL PROTECTED] wrote: Thanks; you're absolutely right

4.1 replication logs growing at a much greater rate than with 4.0

Hi all, I have just upgraded a master slave database system from 4.0 to 4.1. the replication binlogs are now growing at a vastly greater rate. The queries going through are the same. Did 4.0 use some kind of compression by default or something? Does anyone have any idea what's going on

  1   2   >