Re: simple concurrency problem - any advice ??

Heyho! Tim Wood wrote: Hi I have a number of clients connecting to a DB in order to take jobs off a queue, mark them active, then run them. In pseudo code, each client executes the following sequence of queries: a-- select test_id from tests where status=1 and priority < 11 order by priority b

Re: Importing data from MS Access

I found SQLyog Enterprise (www.webyog.com) to be the best when importing data from ODBC to MySQL. Karam --- Peter Brawley <[EMAIL PROTECTED]> wrote: > Using a data modelling tool (like Dezign from > Datanamic) or a scripting > tool (like DbScripter), all you need do, I think, is > load the Acces

simple concurrency problem - any advice ??

Hi I have a number of clients connecting to a DB in order to take jobs off a queue, mark them active, then run them. In pseudo code, each client executes the following sequence of queries: a-- select test_id from tests where status=1 and priority < 11 order by priority b-- update tests set st

Re: Mysqldump error 1017: errno: 24 - help?

Yep, that seems to have done it, at least when I'm testing it. I'm pretty sure the problem is fixed, but the next couple of days of automated backups will tell. Thanks! On Tue, 2005-01-11 at 00:43, Gleb Paharenko wrote: > Hello. > > Try '--open-files-limit=8192' at least. Check the real value o

Re: Importing data from MS Access

Using a data modelling tool (like Dezign from Datanamic) or a scripting tool (like DbScripter), all you need do, I think, is load the Access database into the tool, configure the tool to create an export script for MySQL (say, using InnoDB to enable FKs), touch up as desired, and generate the s

MySQL Memory Issue

Windows 2000 Advance Server (latest service pack) Physical Address Extension enabled Dual 2.4Ghz Intel Pentium 4 Xeon 6gb of memory This system is running as a dedicated MySQL 4.0.12-max-nt server. Issue: The problem first exhibited itself as a connection issue. We weren't able to obtain more t

RE: Slow queries, need advice on how to improve; key_buffer?

I recently had a similar problem, however you may find that its more of a case of correctly indexing your tables. Yyou should look for the tables which need indexing, I enabled the slow-query-log as well as enabling of logging of queries which didn’t use indexes and found some which did some very

RE: Importing data from MS Access

Its my understanding you need InnoDB table types, but I do not know of the single foreign key per table. I have a DB with multiple foreign keys per table and its seems to work fine. Bob -Original Message- From: Paun [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 11, 2005 5:19 PM To:

Re: GRANT can't grant with a password?

Yes, I hadn't thought of that. But at the same time, the way it's presently set up, you *can,* and must, create a user with no password. That doesn't seem very safe either. j- k- On Tuesday 11 January 2005 05:17, Tom Crimmins said something like: > [snip] > It seems that the GRANT syn

Importing data from MS Access

I use MySQL-Front 2.5 (freeware) for importing data from MSAccess databaase in MySQL 4.1.7. Of course, there is no possibility to import "foreign keys" from MSAccess. Question: If I read properly documentation in MYSql is possible to use only one "foreing key" per table, and fields with foreign

Re: Slave integrity.

On Jan 7, 2005, at 5:16 AM, RV Tec wrote: Folks, I'm doing replication (one master, two slaves) with MySQL 4.0.23. I'm really happy with it. Although, every once in a while, the slaves get desync'ed, one at a time (the DB is 6GB large, and has 140 tables). I can't help with verifying your slave, bu

Re: Trouble w/ mysqldump (images attached)

amazing.. I failed to see that in the last msg - but that seemed to do the trick - The images appear correctly now.. is there anyway in my.cnf to tell it to always use the command?? Thanks much for the help! In a message dated 1/11/2005 4:48:27 AM Eastern Standard Time, Gleb Paharenko <[EMA

RE: Tuning MySQL

> -Original Message- > From: Eric Gunnett [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 11, 2005 9:36 AM > To: mysql@lists.mysql.com > Subject: Tuning MySQL > > I have a quad processor server, with 4 gigs of memory. > It is only running MySQL right now and seems really slow

MySQL Connector/J 3.2.0 Alpha Has Been Released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL Connector/J 3.2.0, a new version of the Type-IV all-Java JDBC driver for MySQL has been released. Version 3.2.0 is the first ALPHA release of the 3.2 series that is suitable for use with all versions of MySQL, including MySQL-4.1 or MySQL-5

MySQL Connector/J 3.1.6 Has Been Released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL Connector/J 3.1.6, a new version of the Type-IV all-Java JDBC driver for MySQL has been released. Version 3.1.6 is the first production release of the 3.1 series that is suitable for use with all versions of MySQL, including MySQL-4.1 or My

Re: Root user

Hello. You should start mysqld-nt with --skip-grant-tables option and manually update the user table. Connect to server using mysql command line client. Execute the following statements: use mysql; update user set Grant_priv='Y' where user='root' and host='localhost'; Restart the se

Re: Mysqldump error 1017: errno: 24 - help?

Hello. Try '--open-files-limit=8192' at least. Check the real value of open_file_limits with such statement: show variables like '%open_f%'; You can find some recommendations for SuSe Linux at: http://dev.mysql.com/doc/mysql/en/Linux-post-install.html Mysql user <[EMAIL PROTECTED]>

Re: BUG on SELECT

Hello. See: http://dev.mysql.com/doc/mysql/en/Bug_reports.html I think that your bug is related to bug #6303. "Federico J. Fernandez" <[EMAIL PROTECTED]> wrote: > > Hi, > > i'm using mysql-alpha ver 5.0.2. > > while i was using a cgi script, i discovered that SELECT querys us

Re: easy way to drop a tempoary table created by Create view?

Hello. No. Because mysql -e 'drop view v' just executes the SQL statement. And DROP VIEW doesn't support such syntax. See: http://dev.mysql.com/doc/mysql/en/DROP_VIEW.html sam wun <[EMAIL PROTECTED]> wrote: > sam wun wrote: > >> Gleb Paharenko wrote: >> >>> Hello. >>> >>> >>>

Re: Trouble w/ mysqldump (images attached)

Hello. Have you tried to perform the dump using --default-character-set=latin1 option and then restore data from it? [EMAIL PROTECTED] wrote: > Hello, thanks for helping! Here is the output of the requested statements on > live database: > > > SHOW CREATE TABLE avatardata; > | custo

Tuning MySQL

I have a quad processor server, with 4 gigs of memory. It is only running MySQL right now and seems really slow. Can someone give me a few suggestions on optimizing My.cnf file for this system. We are running mysql-standard-4.0.23-pc-linux-i68, on it. Here is the my.cnf file # The MySQ

SOLVED (at last) Re: c program Bus Error (core dumped)

It was mentioned by the two people cc'd in this mail that the mixture of a 64bit mysqld and libraries with a 32-bit gcc/g++ was not a good idea. How right they were!! I have just installed the latest 4.1.8 32-bit Solaris 2.8 binary and it all works wonderfully. Thanks for all of your help Andy

Re: can't get the order I want after inserting new rows

Marcus Claesson <[EMAIL PROTECTED]> wrote on 01/11/2005 11:05:49 AM: > Thanks for helping! > > > So you ARE having problems trying to change your sbj_count and > > hsp_count columns after adding information to your table your so that > > data is re-ranked according to some rule(s) you have. Exac

Re: can't get the order I want after inserting new rows

Marcus Claesson wrote: Hi Michael! Before the holiday you tried to help me with a problem that I had over-simplified and made more confusing than it was. I'll now try again, and also by giving the columns their right names. My table consists of parsed outputs from a bioinformatics tool called blast

Re: Generic graphing tool?

On Tue, Jan 11, 2005 at 05:55:31PM +0100, Olivier Kaloudoff wrote: > Cacti, based on mysql stored rrd database is probably the kind > of tool you are looking for; Ahh, so is there a cacti-like tool that understands MySQL? Thanks, -Jason Martin -- This message is PGP/MIME signed. pgpUVrrAJRbSG.p

mysql error

I got a mysql-4.1.8-win.zip,when installed,i got a error:Cannot create Windows service for MySQL.Error:0~~How to solve?thanks~~ :) sorry for my poor english~~ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: c program Bus Error (core dumped)

Hi Andy! > After compiling with the options (as suggested by Jose Miguel Pérez) [...] > I now get ... > Everything Cool with the connection > Bus Error (core dumped) > > Sound familiar!! Sorry Andy but I couldn't help any more. I am not familiar with Solaris, not even with 64 bit machines

Re: Generic graphing tool?

On Tue, Jan 11, 2005 at 11:44:34AM +1100, Daniel Kasak wrote: > Jason Martin wrote: > >Does anyone know of a web-based tool that will let you graph > >arbitrary data out of of MySQL? I'm thinking of something that > >lets you define a select statement, some graph options and > >produce a graph. > J

Re: c program Bus Error (core dumped)

After compiling with the options (as suggested by Jose Miguel Pérez) g++ -m64 -o check check.cpp -L/usr/local/mysql/lib -L/usr/local/lib/sparcv9 -L/usr/lib -lmysqlclient -lsocket -lnsl -lm ... and getting the subsequent error when running the compiled binary 'check'... ld.so.1: ./check: fata

Re: c program Bus Error (core dumped)

I have a slight variation on that for my Solaris 2.8 machine... >g++ -m64 -o check check.cpp -L/usr/local/mysql/lib -L/usr/local/lib/sparcv9/ -lmysqlclient -lsocket -lnsl -lm // this part works fine When running 'check' I get ... >check ld.so.1: ./check: fatal: libstdc++.so.5: open failed: No suc

RE: does anyone know of a utility that will processes the query log to rerun the queries?

I am familiar with mysqlbinlog that is used to process the binary log to produce a text file that can then be feed back into mysql. That appears to be what you are referring to. But I'm not referring to the binary log, or any derivative of it, at all. I am referring to the actual general query lo

Re: can't get the order I want after inserting new rows

Thanks for helping! > So you ARE having problems trying to change your sbj_count and > hsp_count columns after adding information to your table your so that > data is re-ranked according to some rule(s) you have. Exactly, how do > you determine the new ranking? I could make a guess based on your

Re: c program Bus Error (core dumped)

Hi Andy! > but I still get the Bus Error message with the following code... > int main(char **args) { > MYSQL_RES *result; > MYSQL_ROW row; > MYSQL *connection, mysql; > int state; > int PORTNUM = 3306; [...] Andy, I have copied and pasted your code into a fresh new check.

RE: Putting data in seperate tables

I know that your options for physical partitioning depend on your OS, your filesystem, and whether you are using InnoDB or MyISAM. I cannot speak from personal experience on the mechanics of this but I know that several others on the list have performed this particular optimization (which is ho

Re: c program Bus Error (core dumped)

I can get something working however. int main(char **args) { MYSQL_RES *result; MYSQL_ROW row; MYSQL *connection, mysql; char *serverInfo=""; int state; int PORTNUM = 3306; unsigned long int version; mysql_init(&mysql); connection = mysql_real_connect(&mysq

Re: NOT LIKE

> How do I exclude any records where the path column is > '/realtors/Kokomo/%'? You're too funny... you gave the answer on the subject line of your e-mail :-) Read http://dev.mysql.com/doc/mysql/en/String_comparison_functions.html Scroll down past the section on LIKE and you'll find: expr NOT LI

Re: JDBC driver support

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Manish wrote: > We're having some problems in getting MySQL 4.1.8 to work with JDBC drivers > in - > mysql-connector-java-2.0.14-bin.jar > > Do these drivers work with MySQL 4.1.8? hey seem to be working fine with > 4.0.14 version of MySQL. > Is there

NOT LIKE

I've been searching the docs and can't find examples how to do what I need to do. I need to exclude some records from my SELECT statement results but it appears I can't use (=, != or LIKE) for it. What I have is a result set having a column name 'path'. I need to exclude any record reulting in

RE: Does MySQL support server with 2 cpu??

This is really based on your OS, not MySQL. If you install MySQL on Red Hat Linux Enterprise Symmetric Multi-Processing (SMP), then MySQL will use both CPUs based on instruction sets in the OS. If you install it on WinXP or Win2k3 server, they both have SMP and can support it. So the question is

Re: can't get the order I want after inserting new rows

Marcus Claesson <[EMAIL PROTECTED]> wrote on 01/10/2005 02:00:37 PM: > Hi Michael! > > Before the holiday you tried to help me with a problem that I had > over-simplified and made more confusing than it was. I'll now try again, > and also by giving the columns their right names. > > My table co

RE: Does MySQL support server with 2 cpu??

Not sure what you mean. MySQL (4.0.0+) runs perfectly happily under Linux on multi-processor boxes. Allocation of processes to CPU's is an OS function not an application function. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk >

Does MySQL support server with 2 cpu??

Hi! We wanna know is does MySQL support the use of the server with 2 cpu? I have trouble finding that on the mysql.com website. If so, how does the configuration for the use of 2 CPU work?? Thanks, Scott D. Fletcher

Re: c program Bus Error (core dumped)

Thanks Jose ... but I still get the Bus Error message with the following code... int main(char **args) { MYSQL_RES *result; MYSQL_ROW row; MYSQL *connection, mysql; int state; int PORTNUM = 3306; mysql_init(&mysql); connection = mysql_real_connect(&mysql, "localhost"

RE: GRANT can't grant with a password?

[snip] It seems that the GRANT syntax should allow the setting of a password upon account creation without requiring access to the mysql db. [/snip] Example: GRANT SELECT ON dbihavegrantprivon.* TO 'root'@'localhost' IDENTIFIED BY 'newpassword'; If you don't have privs to the mysql.user table yo

Re: c program Bus Error (core dumped)

Hi Andy, > state = mysql_query(connection, "SELECT * from mytable"); *** ^^ > if( state ) { > printf(mysql_error(connection)); > return 1; > } else { > printf("Everything Cool with the query\n"); > } // New code,

Re: ALTER TABLE....with CHANGE syntax

Hello, I am using 4.1.7 and it works for it. I just wanted to know from which version it support has started because it does not run on my 3.23.58 server. Regards, Karam --- Andy Ford <[EMAIL PROTECTED]> wrote: > Which version are you running. Quite often when you > see a 'check the > version y

Re: ALTER TABLE....with CHANGE syntax

Which version are you running. Quite often when you see a 'check the version you are running' message indicates a syntax error in your mySQL statement.. Andy On Tue, 2005-01-11 at 05:13 -0800, Karam Chand wrote: > Hello, > > Can somebody tell me from which version of MySQL is - > > ALTER TABLE

Re: c program Bus Error (core dumped)

I can send the truss output of anyone can decipher it!! Regards Andy On Tue, 2005-01-11 at 13:05 +, Andy Ford wrote: > Hi everyone. > > I have been trying to write a simple c program to access a local mySQL > database (with the help of David Logan). With the following code I am > getting th

ALTER TABLE....with CHANGE syntax

Hello, Can somebody tell me from which version of MySQL is - ALTER TABLECHANGE... syntax supported. Regards, Karam __ Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. http://info.mail.yahoo.com/mail_250 --

c program Bus Error (core dumped)

Hi everyone. I have been trying to write a simple c program to access a local mySQL database (with the help of David Logan). With the following code I am getting the error ... Bus Error (core dumped) ... when I run my compiled program 'test'. [code] int main(char **args) { MYSQL_RES

installing query-browser on mac?

Hi, I don't know much sorry, can anyone help? I'm trying to install the Query browser on my Mac OS X. I downloaded the Linux version which Stuffit expanded to the folder 'mysql-query-browser' on my desktop. Now I'm trying to install it... I think I have to use the Terminal application, right?

RE: compilation errors in mySQL C app

Got it ... Thanks David >gcc -m64 test.c -L/usr/local/mysql/lib -lmysqlclient -lsocket -lnsl -lm -o test .. seemed to work I get a 'Bus Error (core dumped)' when I run it - but that's a problem with the code!! Thanks Andy On Tue, 2005-01-11 at 22:23 +1100, Logan, David (SST - Adelaide) wrot

RE: compilation errors in mySQL C app

Hi Andy, I resolved the problem by reinstalling a 32bit version of mysql and the DBI worked fine after that. Looks like you are missing a library or 2, try nsl and socket. I think they have all the routines that you need to link against. You may also need an include or 2. All the routines have m

RE: compilation errors in mySQL C app

Hi David Yes it is something like you say... >file /usr/local/bin/gcc /usr/local/bin/gcc: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped >file /usr/local/bin/g++ /usr/local/bin/gcc: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped

RE: compilation errors in mySQL C app

Hi Andy, Are you using a 64bit option to compile your program (I can't remember the option on gcc -m64 I think)? Looks like a 64bit mysql library trying to talk to a 32 bit program. I'm no expert but I had similar problems when I put a 64bit mysql on one of my Solaris boxen and tried to talk with

compilation errors in mySQL C app

Hi everyone I am trying to compile a simple C program to connect to a mySQL database (on localhost) and run a simple query. I am getting the following errors... >gcc test.c -L/usr/local/mysql/lib -lmysqlclient -o test ld: warning: file /usr/local/mysql/lib/libmysqlclient.a(libmysql.o): wrong EL

Re: mysql_use_result issue: useless iterating over unused results

I am not sure why they are doing it. You need to hack the protocol to understand it. Maybe some MySQL/network GURU will be able to help yuo. Regards, Karam --- Renald Buter <[EMAIL PROTECTED]> wrote: > On 01:55 Tue 11 Jan , Karam Chand wrote: > > Yup. > > > > This is a normal behaviour. mys

Re: mysql_use_result issue: useless iterating over unused results

On 01:55 Tue 11 Jan , Karam Chand wrote: > Yup. > > This is a normal behaviour. mysql_free_result() will > result in bringing each unasked rows to the client and > freeing it up row by row. > This sounds to me as a useless "feature". What could be the reason for such wasting behaviour? > BT

Re: mysql_use_result issue: useless iterating over unused results

Yup. This is a normal behaviour. mysql_free_result() will result in bringing each unasked rows to the client and freeing it up row by row. BTW, why do you need to do - "select * from " Karam --- Renald Buter <[EMAIL PROTECTED]> wrote: > Hello list, > > I am having this issue with mysql_us

Re: mySQL C++ API (which libraries)

The one supported by MySQL AB and the best till date is MySQL C API (well its best because I am C developer). It is the speediest too. I think you should find wrappers over the C API() over the net. If not then you can develop one for yourself and probably release it in GNU. Regards, Karam --- An

mySQL C++ API (which libraries)

Hi fellow developers ... I'm about to move my Perl code to C++ for security. Which mySQL libraries are the best ones to use? There are so may available I thought I'd consult the community in the know! Thanks Andy -- perl -e "print qq^bIG VeRN ! ^^qq^#'#Yv#=http://lists.mysql.com/mysql To unsubs

Re: JDBC driver support

Manish wrote: We're having some problems in getting MySQL 4.1.8 to work with JDBC drivers in - mysql-connector-java-2.0.14-bin.jar Do these drivers work with MySQL 4.1.8? hey seem to be working fine with 4.0.14 version of MySQL. Is there any compatibility data available for all these JDBC drivers a

mysql_use_result issue: useless iterating over unused results

Hello list, I am having this issue with mysql_use_result: it seems it will iterate over all unused results if I call 'mysql_free_result'. The following code illustrates this: mysql_query(&mysql,"SELECT * FROM a_very_large_table"); res = mysql_use_result(&mysql); i = 0; while (row = mysql_fetc

mysql_use_result issue: useless iterating over unused results

Hello list, I am having this issue with mysql_use_result: it seems it will iterate over all unused results if I call 'mysql_free_result'. The following code illustrates this: mysql_query(&mysql,"SELECT * FROM a_very_large_table"); res = mysql_use_result(&mysql); i = 0; while (row = mysql_fetc

Re: clerification of documentation on InnoDB locking.

From: "Sean" > on the page http://dev.mysql.com/doc/mysql/en/InnoDB_Locks_set.html > > This statement is confusing. > > "If you do not have indexes suitable for your query and MySQL has to scan the whole table to process the query, every row of the table will become locked" > > Is it saying that