I'm getting a strange ordering when using ORDER BY on a int column.
The rows are being returned sorted as follows:
1
10
11
12
13
14
15
2
3
4
5
6
7
8
9
I'm sure this is a simple one, but I haven't found an answer in the
archives.
Thanks,
Steve
--
MySQL General Mailing List
For list
Hello,
I have recently installed FC3 and now I have
PHP(4.4.9) and MYSQL(3.23) which got installed along
with FC3.
I'm able to connect to MYSQL from command prompt.
But the problem fires when I do the same from a PHP
script. The error I get is Can't connect to local
MySQL server through socket
Hi Sandhya,
Have you checked the permissions? The error message is System error: 13
= Permission denied. Is your PHP/Apache user able to connect via the
socket? Try connecting as
$ su php/apache user -c mysql -u user you connect with -p
and see what happens.
Regards
David Logan
Database
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).
Jason
snippety-snip
Hi Jason
If it's not too late
[quote]
Linux
The Linux release is not available right now but we are already
working on the port.
[/quote]
raz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 23 Sep 2005, Jasper Bryant-Greene wrote:
Thing is, even though I get that error, the server keeps running and
accepting other connections and responding to queries fine.
Probably because the mysqld_safe wrapper script has restarted it
Hi,
I guess it is a stupid simple question:
I have seen the following error in the log files:
DBI connect('database=[database]','[username]',...) failed: #08004Too many
connections at /[path_to_script] line 12
I have taken a look in my.cnf but I couldn't find some settings for
increasing the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 26 Sep 2005, Alex S Moore wrote:
Has the md5sum been updated for the tarball (tar.gz) download?
I tried two sites and got the same size file, i.e,. 19209618 bytes, but the
md5sum does not agree.
Yes, the MD5 checksum and the GPG
Stephen A. Cochran Lists wrote:
I'm getting a strange ordering when using ORDER BY on a int column.
The rows are being returned sorted as follows:
The list is typically the way to order a string.
You are most likely to get meaningful suggestions to solve the mystery
if you include the
-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 this
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
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 tablename) and the query.
mysql SHOW CREATE TABLE Player|
+
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
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 tablename) and the query.
mysql SHOW CREATE TABLE Player|
| Player
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] mailto:[EMAIL PROTECTED]
wrote:
Balazs Rauznitz wrote:
I
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
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
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
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
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
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
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 not
[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
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
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
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
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
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
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 while I had been
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:
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:
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
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
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 van Hemert*
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 in
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 changes
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,
[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 RAM
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 '',
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 (assuming that
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`
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,
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, etc...
Steve Cochran
Then
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 avoid
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...
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 files:
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
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
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 :=
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
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
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
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
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 of course does
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
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
services
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 run.
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 2000
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
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
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 | date
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 with the
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 that
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 tests
[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
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 like
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
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 between 2pm to
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-
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
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
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
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 string and after the
73 matches
Mail list logo