Re: HELP - Group_Concat broken after update

In the last episode (Sep 27), Ed Reed said: > Will someone please respond to this? > > >>> "Ed Reed" <[EMAIL PROTECTED]> 9/22/05 1:30 PM >>> > Bump! > > >>> "Ed Reed" < [EMAIL PROTECTED] > 9/21/05 2:09:58 PM >>> > > I just upgraded from 4.1.11 to 4.1.14a and now Group_Concat returns > garbage. In

InnoDB error "unable to create temporary file"

Hi list, After the most recent reboot (which we used to increase the ulimit/open_files_limit on our Solaris 8 machine running 4.1.10-log), the following message has started to appear in the errorlog: InnoDB: Error: unable to create temporary file; errno: 2 I have searched google and the lists

Re: HELP - Group_Concat broken after update

Will someone please respond to this? - Ed >>> "Ed Reed" <[EMAIL PROTECTED]> 9/22/05 1:30 PM >>> Bump! >>> "Ed Reed" < [EMAIL PROTECTED] > 9/21/05 2:09:58 PM >>> I just upgraded from 4.1.11 to 4.1.14a and now Group_Concat returns garbage. In the previous version Group_Concat returned a text str

Re: Joining data from two databases

Anthony Brown wrote: I have one database that I would like to split into two.. Well actually my client does.. I don't think we should. But, is there a way to join data from the seperated databases? One table authors will be connected to a table called contacts each residing in different databas

Joining data from two databases

Hi, I have one database that I would like to split into two.. Well actually my client does.. I don't think we should. But, is there a way to join data from the seperated databases? One table authors will be connected to a table called contacts each residing in different databases on the same ser

mySQL LINT / Schema checker?

We use SVN to commit our code, but sometimes a dev will commit broken SQL schema. We use "php -l" to validate all php prior to allowing the checkin, wondering if there is some simmilar tool for mySQL (we're migrating to v5.0 if that helps) to prevent broken schema syntax from sneaking into our rep

Recommendations for memory use with 16GB

I'm moving from 32-bit intel to the brave new world of AMD64. Our new servers are dual Opterons with 16GB of RAM. We will be running mysql 4.1.14-standard on redhat enterprise linux 4 x86_64. Since I'm new to this, what's my best bang-for-buck in setting up mysql's memory usage? -jsd- --

Re: linux timestamp

On 9/27/05, Nigel Wood <[EMAIL PROTECTED]> wrote: > Dotan Cohen wrote: > > >Hi all, I have a field in a mysql database v4.0.18 that contains a > >linux timestamp. I have been googleing for a solution that would > >return to me all the entries where the timestamp falls on, say a > >wednesday, or bet

Re: To multi thread or NOT to multi thread?

Hello again, I modified your threading code to use a thread pool. Here are my results: pooled-threading.c: [EMAIL PROTECTED]:~$ gcc -lmysqlclient_r -lpthread pooled-threading.c [EMAIL PROTECTED]:~$ time ./a.out Thread Safe ON real 0m0.068s user 0m0.041s sys 0m0.097s [EMAIL PROTECTED]:~$ time ./a

Re: strange order by problem

Claire Lee wrote: > This simplified my second expression in the if > statement. Thank you. But the query still doesn't sort > by the numbers, here's the result: > > mysql> select distinct secname, date from optresult > where secname like 'swap%' a > nd date like '2005-09-2%' order by if (secname l

Re: strange order by problem

This simplified my second expression in the if statement. Thank you. But the query still doesn't sort by the numbers, here's the result: mysql> select distinct secname, date from optresult where secname like 'swap%' a nd date like '2005-09-2%' order by if (secname like 'swap%',abs(substring(secnam

Re: strange order by problem

[EMAIL PROTECTED] wrote: Claire Lee <[EMAIL PROTECTED]> wrote on 09/27/2005 03:48:11 PM: I need to order a few names by the number following the main name. For example swap2, swap3, swap10 in the order of swap2, swap3, swap10, not in swap10, swap2, swap3 as it will happen when I do an order

Re: To multi thread or NOT to multi thread?

Pooly wrote: 2005/9/27, Lefteris Tsintjelis <[EMAIL PROTECTED]>: Hi, What makes me wonder is that the same test, with the code stripped down, to my surprise, is significantly faster that the multi threaded one, no matter how many times I run the tests. I am including the code for both test

Re: strange order by problem

Claire Lee wrote: > I need to order a few names by the number following > the main name. For example swap2, swap3, swap10 in the > order of swap2, swap3, swap10, not in swap10, swap2, > swap3 as it will happen when I do an order by. ... ORDER BY ABS(SUBSTRING(secname,5)) ... will insure tha

Re: strange order by problem

Claire Lee <[EMAIL PROTECTED]> wrote on 09/27/2005 03:48:11 PM: > I need to order a few names by the number following > the main name. For example swap2, swap3, swap10 in the > order of swap2, swap3, swap10, not in swap10, swap2, > swap3 as it will happen when I do an order by. > > So I came up w

RE: strange order by problem

Try this mysql> select distinct secname, date -> from optresult -> where secname like 'swap%' ->and date like '2005-09-2%' -> order by if(secname like 'swap%', -> (mid(secname,5,20)+0), -> secname); +--++ | secname | d

strange order by problem

I need to order a few names by the number following the main name. For example swap2, swap3, swap10 in the order of swap2, swap3, swap10, not in swap10, swap2, swap3 as it will happen when I do an order by. So I came up with the following query: mysql> select distinct secname, date from optresult

RE: MySQL 5.0 Release Candidate

I had the same problem. Disabling it isn't enough. I had to use the sc command from the Windows command prompt to delete the service. Just enter sc on the command line and a description of the command will be displayed. Fred -Original Message- From: Scott Hamm [mailto:[EMAIL PRO

Re: MySQL 5.0 Release Candidate

Scott Hamm <[EMAIL PROTECTED]> wrote on 09/27/2005 03:00:00 PM: > MySQL 5.0 was installed up to the point where I tried to start it in > Instnace Configuration wizard. It won't start at all even mysqld and mysqld > --safe-mode > > I'm getting frustrated -- hosed hard drive, reinstalled Windows 2

Re: To multi thread or NOT to multi thread?

2005/9/27, Lefteris Tsintjelis <[EMAIL PROTECTED]>: > Hi, > > What makes me wonder is that the same test, with the code > stripped down, to my surprise, is significantly faster that the > multi threaded one, no matter how many times I run the tests. I am > including the code for both tests I r

Re: MySQL 5.0 Release Candidate

Scott Hamm <[EMAIL PROTECTED]> wrote on 09/27/2005 11:25:15 AM: > While I try to install MySQL 5.0 and start it as "QCDA" server, and upon > "execute" it could not start service during MySQL Instance Configuration > Wizard on Windows 2000 Pro. The older and removed Mysql are set disabled in > ser

MySQL 5.0 Release Candidate

MySQL 5.0 was installed up to the point where I tried to start it in Instnace Configuration wizard. It won't start at all even mysqld and mysqld --safe-mode I'm getting frustrated -- hosed hard drive, reinstalled Windows 2000 Pro and installed MySQL 5.0 and it still *wont* run. -- Please avoid

Re: To multi thread or NOT to multi thread?

Hi again, On 9/27/05, Lefteris Tsintjelis <[EMAIL PROTECTED]> wrote: > > John McCaskey wrote: > > Hi, > > > > I think I can shed a bit of light on the topic. There are several > reasons > > why your multithreaded code is not a good example and would be slower. > > > > 1) locking/unlocking mutexes

Re: To multi thread or NOT to multi thread?

John McCaskey wrote: Hi, I think I can shed a bit of light on the topic. There are several reasons why your multithreaded code is not a good example and would be slower. 1) locking/unlocking mutexes of course does add *some* overhead *lots* would probably be a better choice here! :) 2) you

Re: To multi thread or NOT to multi thread?

Hi, I think I can shed a bit of light on the topic. There are several reasons why your multithreaded code is not a good example and would be slower. 1) locking/unlocking mutexes of course does add *some* overhead 2) you have a single database connection and are passing it around between threads t

Re: linux timestamp

Dotan Cohen wrote: Hi all, I have a field in a mysql database v4.0.18 that contains a linux timestamp. I have been googleing for a solution that would return to me all the entries where the timestamp falls on, say a wednesday, or between 2pm to 3pm. I am led to believe that it is possible, but I

Re: linux timestamp

Dotan Cohen wrote: Hi all, I have a field in a mysql database v4.0.18 that contains a linux timestamp. I have been googleing for a solution that would return to me all the entries where the timestamp falls on, say a wednesday, or between 2pm to 3pm. I am led to believe that it is possible, but I

Re: linux timestamp

On 27/09/2005, Dotan Cohen wrote: > Hi all, I have a field in a mysql database v4.0.18 that contains a > linux timestamp. I have been googleing for a solution that would > return to me all the entries where the timestamp falls on, say a > wednesday, or between 2pm to 3pm. SET @uts := UNIX_TIMEST

To multi thread or NOT to multi thread?

Hi, What makes me wonder is that the same test, with the code stripped down, to my surprise, is significantly faster that the multi threaded one, no matter how many times I run the tests. I am including the code for both tests I run. Since I couldn't find a good example of mutex locking t

linux timestamp

Hi all, I have a field in a mysql database v4.0.18 that contains a linux timestamp. I have been googleing for a solution that would return to me all the entries where the timestamp falls on, say a wednesday, or between 2pm to 3pm. I am led to believe that it is possible, but I have found no example

Re: too many connections

use a variable called max_connections( if its not there in my.cnf just add it ) and restart mysql eg . max_connections = 100 Kishore Jalleda On 9/27/05, Octavian Rasnita <[EMAIL PROTECTED]> wrote: > > Hi, > > I guess it is a stupid simple question: > > I have seen the following error in the log

Re: ORDER BY for ints

On Sep 27, 2005, at 10:28 AM, Pooly wrote: The command in PHP is: $query="SELECT id,first_name,last_name FROM Player ORDER BY id"; $players=mysql_query($query); When issued from the mysql prompt, order is fine, but when called from php I'm getting that strange order: 1, 10, 11, 12, etc...

MySQL 5.0 Release Candidate

While I try to install MySQL 5.0 and start it as "QCDA" server, and upon "execute" it could not start service during MySQL Instance Configuration Wizard on Windows 2000 Pro. The older and removed Mysql are set disabled in services properties. Error no. 0 What is the workaroud here? -- Please avoi

Re: ORDER BY for ints

Hi, > >>> The command in PHP is: > >>> > >>> $query="SELECT id,first_name,last_name FROM Player ORDER BY id"; > >>> $players=mysql_query($query); > >>> > >>> When issued from the mysql prompt, order is fine, but when > >>> called from php I'm getting that strange order: > >>> > >>> 1, 10, 11, 12

Re: ORDER BY for ints

On Sep 27, 2005, at 9:56 AM, Edward Vermillion wrote: Michael Stassen wrote: Stephen A. Cochran Lists wrote: On Sep 27, 2005, at 3:29 AM, Jasper Bryant-Greene wrote: mysql> SHOW CREATE TABLE Player| | Player | CREATE TABLE `Player` ( `id` int(16) NOT NULL auto_increment, `first_name

Re: ORDER BY for ints

Michael Stassen wrote: Stephen A. Cochran Lists wrote: On Sep 27, 2005, at 3:29 AM, Jasper Bryant-Greene wrote: mysql> SHOW CREATE TABLE Player| | Player | CREATE TABLE `Player` ( `id` int(16) NOT NULL auto_increment, `first_name` varchar(32) NOT NULL default '', `last_name` varchar(32

Re: Best way for maintaining a "master table" for use in several databases

Neven Luetic <[EMAIL PROTECTED]> wrote on 09/27/2005 09:35:04 AM: > > > Within a single server, you only need one copy of a table in one > > database. When you need data from it, just use the table's > > fully-qualified name and it won't matter which other database you are > > currently in (assum

Re: ORDER BY for ints

Stephen A. Cochran Lists wrote: On Sep 27, 2005, at 3:29 AM, Jasper Bryant-Greene wrote: mysql> SHOW CREATE TABLE Player| | Player | CREATE TABLE `Player` ( `id` int(16) NOT NULL auto_increment, `first_name` varchar(32) NOT NULL default '', `last_name` varchar(32) NOT NULL default '',

RE: Regarding the cpu utilization of mysqld

<[EMAIL PROTECTED]> wrote on 09/27/2005 06:47:50 AM: > > Hi, > > > We are using the same set of query's what we re using in some > other process, where the mysqld CPU utilization is minimum. But for this > process particularly, mysqld is utilising more than 90 % of CPU. Even in > 2GB R

Re: problem with mysql.sock

I could be wrong but this may have something to do with ownership and permissions of the socket file. I recently upgraded my MySQL version and had basically the same problem. I can't remember though if I had to change the ownership to root.root or mysql.mysql. HTH, Ed On Mon, 26 Sep 2005, San

Re: Best way for maintaining a "master table" for use in several databases

Neven Luetic <[EMAIL PROTECTED]> wrote on 09/27/2005 05:02:58 AM: > Hello, > > I have a database scheme, containing a table, whichs content should be > unique across all databases with this scheme (on several servers as > well). > > It would be possible to define one database, in which all chan

Re: how can i get rid of this error ?

"Bulent" <[EMAIL PROTECTED]> wrote on 09/27/2005 04:19:56 AM: > Hello > > I am a novice about mysql > I use mysql4.0.24 with php4.3.10. > When I upload jpeg/gif files to my webpage I get an error as below; > PHP Warning: mysql_close(): supplied resource is not a valid MySQL- > Link resource i

Re: Adding index to a replication slave

Jigal van Hemert <[EMAIL PROTECTED]> wrote on 09/27/2005 03:35:59 AM: > Mysql Lists wrote: > > I'm hoping they get replication setup by "diffs", only sending the diffs > > that are tracked from the master.. replicated to the slave.. That would > > be sweet :) > > > > > > On 9/27/05, *Jigal v

Re: Another LOAD Infile Problem

Jason Ferguson <[EMAIL PROTECTED]> wrote on 09/26/2005 10:58:02 PM: > Many thanks for the earlier response to why LOAD DATA INFILE wasnt working > for me. However, another problem has appeared. > > In the file I am reading, 2 of the fields are SUPPOSED to be float values. > However, in several

Re: ORDER BY for ints

On Sep 27, 2005, at 3:29 AM, Jasper Bryant-Greene wrote: mysql> SHOW CREATE TABLE Player| | Player | CREATE TABLE `Player` ( `id` int(16) NOT NULL auto_increment, `first_name` varchar(32) NOT NULL default '', `last_name` varchar(32) NOT NULL default '', `year` varchar(16) NOT NULL defaul

Re: Weird database files

> Jeff wrote: > > Had problem with our database this weekend, apparently an > app did an > > insert query that was huge size wise and this totally boogered up > > replication downstream. Also I cant read past that point in the > > binlog using mysqlbinlog on the master server. It complains that:

RE: Weird database files

> Jeff wrote: > > Had problem with our database this weekend, apparently an > app did an > > insert query that was huge size wise and this totally boogered up > > replication downstream. Also I cant read past that point in the > > binlog using mysqlbinlog on the master server. It complains th

Re: Advice Required

Vinayak Mahadevan <[EMAIL PROTECTED]> wrote on 27/09/2005 11:28:51: > [EMAIL PROTECTED] wrote: > > >Vinayak Mahadevan <[EMAIL PROTECTED]> wrote on 27/09/2005 04:55:13: > > > > > > > >>I am creating an application in Visual Basic 6.0 which will require a > >>centralised database server. All this

RE: Regarding the cpu utilization of mysqld

Hi, We are using the same set of query's what we re using in some other process, where the mysqld CPU utilization is minimum. But for this process particularly, mysqld is utilising more than 90 % of CPU. Even in 2GB RAM machine also, behaving same. We are using Windows XP/ 2000/ 2003 ser

Re: add a column if not exists

Hello. You can parse the output of 'SHOW CREATE TABLE' or 'SHOW COLUMNS'. See: http://dev.mysql.com/doc/mysql/en/show-columns.html http://dev.mysql.com/doc/mysql/en/show-create-table.html Claire Lee wrote: > I want to check if a column exists in a table before I > do an alter ta

Re: Stored Procedures and Functions

Hello. Have a look here: http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.html However, it isn't clear for me what originally read data means. Do you store the time of the first access to the data in some table or somewhere else? You might obtain a better answer from

Re: Weird database files

Hello. Yes, these files are from some unterminated query. See: http://dev.mysql.com/doc/mysql/en/temporary-files.html You may want to use --start-position (--start-datetime) and --stop-position (--stop-datetime) to skip the problematic statement and perform necessary updates on the sla

Re: How to change table character set

Hello. Have a look here: http://dev.mysql.com/doc/mysql/en/charset-upgrading.html http://dev.mysql.com/doc/mysql/en/charset-conversion.html MightyData wrote: > I have a database that was created with MySQL 4.0. The character set for > each table is latin1. I have upgraded the server

Re: Advice Required

[EMAIL PROTECTED] wrote: Vinayak Mahadevan <[EMAIL PROTECTED]> wrote on 27/09/2005 04:55:13: I am creating an application in Visual Basic 6.0 which will require a centralised database server. All this while I had been planning to use MS-Access. But then I found out that MS-Access is ok to

Re: Advice Required

Vinayak Mahadevan <[EMAIL PROTECTED]> wrote on 27/09/2005 04:55:13: > I am creating an application in Visual Basic 6.0 which will require a > centralised database server. All this while I had been planning to use > MS-Access. But then I found out that MS-Access is ok to be a desktop > rdbms but

RE: Advice Required

What are specifications of your DB. How much of data you have. How mant transactions you will be getting daily. Without these details it will be difficult to answer ur question. But for a centralised database server, I guess 1G RAM and 2CPU will be a good configuration to start with. sujay ---

Advice Required

I am creating an application in Visual Basic 6.0 which will require a centralised database server. All this while I had been planning to use MS-Access. But then I found out that MS-Access is ok to be a desktop rdbms but not for an enterprise level rdbms. So I am planning to use MySQL as the bac

Re: varchar vs char speed improvement

2005/9/27, Ow Mun Heng <[EMAIL PROTECTED]>: > Is there any doc looking at benchmarks of a database which is populated > entirely with fixed length char compared to variable character lengths? > > I know using char is preferred over varchar when it comes to speed. Is > there any available benchmarks

Best way for maintaining a "master table" for use in several databases

Hello, I have a database scheme, containing a table, whichs content should be unique across all databases with this scheme (on several servers as well). It would be possible to define one database, in which all changes would be made. But what's the easiest way to keep the table consistent in the

how can i get rid of this error ?

Hello I am a novice about mysql I use mysql4.0.24 with php4.3.10. When I upload jpeg/gif files to my webpage I get an error as below; PHP Warning: mysql_close(): supplied resource is not a valid MySQL-Link resource in /var/. What shall I do ? My php configuration as below; GD Suppo

RE: Avg row length is varying a lot from oracle to MySQL

I am using the show table status command to find the average length of row in a table. And it reported something about 686 bytes. But as I populated more data, this number has substantially decreased to 484 bytes. But one more thing I also learnt is the average row length returned by oracle is jus

Re: Adding index to a replication slave

Mysql Lists wrote: I'm hoping they get replication setup by "diffs", only sending the diffs that are tracked from the master.. replicated to the slave.. That would be sweet :) On 9/27/05, *Jigal van Hemert* <[EMAIL PROTECTED] > wrote: Balazs Rauznitz wrote:

Re: ORDER BY for ints

Stephen A. Cochran Lists wrote: On Sep 27, 2005, at 2:58 AM, Jigal van Hemert wrote: You are most likely to get meaningful suggestions to solve the mystery if you include the table definition (output of SHOW CREATE TABLE ) and the query. mysql> SHOW CREATE TABLE Player| | Player | CREATE

Re: Another LOAD Infile Problem

Jason Ferguson wrote: The data is split into about 60 files, average file size of 5 MB (varying from 1 to 10 MB). Since there are many files, I'm trying to minimize the required work (if there was just one consolidated file, no problem). The work can be automated easily with the right tools ;-)

Re: ORDER BY for ints

On Sep 27, 2005, at 2:58 AM, Jigal van Hemert wrote: You are most likely to get meaningful suggestions to solve the mystery if you include the table definition (output of SHOW CREATE TABLE ) and the query. mysql> SHOW CREATE TABLE Player| + +---

Re: Adding index to a replication slave

Balazs Rauznitz wrote: I have replication set up. Is it OK to alter one of the slaves and add several indexes ? It did seem to work, but I'd like to be sure. Replication does nothing more or less than copying the queries that alter the tables (inserts, updates, alter table, delete, etc.) to th

Re: MySQL 5.0.13-rc has been released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 26 Sep 2005, Jim McAtee wrote: > Is this a "release candidate" as the version in your message subject would > imply, or is it an actual "release", as your message states? Or does MySQL AB > even bother to differentiate the two? I agree