MY first guess is that you simply need an ORDER BY field in yout (later,
ad you put it) SELECT.
However, the whole point of using a database such as MySQL is that you do
not worry about how exactly your data is stored. there are many different
tricks that a database can use to optimise both
Is it possible to change the character set just for an individual table and
if so which character set should I try to display this european characters?
Cheers,
Lee
- Original Message -
From: Sumito_Oda [EMAIL PROTECTED]
To: Lee Denny [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent:
Hello.
We're running MySQL 4.11 on a machine with 2GB memory, the table is
InnoDB with a compound primary key, and additional indexes on all rows
with searchable options in the API. Any generic advice or admin tools
would be great.
Use EXPLAIN to determine how efficient your
Hello.
I don't see correlations between error messages and replication
of this table. In my opinion, there's something wrong with
plugin_data.renderer table, check it. Usually you solve the
replication problem starting with the binary logs examination
(master and relay) with mysqlbinlog
Hello.
Please, send the output of the following statements:
show variables like '%colla%';
show variables like '%char%';
Andr$s Villanueva [EMAIL PROTECTED] wrote:
Anyone??
Original Message
The tables are now entirely in utf8, and that is also the
Hi,
I have four tables among others in my database: Bookings, Work_Types,
Practices Projects. Bookings occur in a Practice for a Project and have a
Work_Type. A Practice can have many Bookings but must have one and only one
Booking where the Work_Type.Day_Type = 1. This rule was introduced
Hello.
Are you sure that you are running mysqld-max (mysqld-max-nt)? Are you
able to select data from invisible tables? Is it possible that you have disabled
symlinks? Does the problem remain with 4.1.11 version?
I use mysql 4.0.23-nt on win XP.
In order to shift some of my
Which cnf file (small,medium,large,huge) has params
that are closer to mysql defaults for starting up
server?
I see default unix socket file is /tmp/mysql.sock
which could be removed by someone accidently.
Is it normal to keep it that way or keep in a
protected directory ?
Thanks.
[snip]
I have four tables among others in my database: Bookings, Work_Types,
Practices Projects. Bookings occur in a Practice for a Project and
have a
Work_Type. A Practice can have many Bookings but must have one and only
one
Booking where the Work_Type.Day_Type = 1. This rule was introduced
Hi,
I used sql-bench, but that is testing things we already know. We want to
establish how many concurrent connections / queries our database server can
handle before it starts getting into trouble (no, a different one from the
email of last night). This system is a dual proc with 4GB ram and
Hi,
I have an interesting problem, i.e upto 20k data is inserted in 20
min. But for 39k it took 3.5 hours. Could you please help me in this,
what are all the possible scenarios which leads to this kind of
problems. Is there any fine tuning mechanism in Mysql 4.0.23 with
innodb?
Please help
From: Chris Knipe
I found super-smack (which tests 100% what I want), but the problem now is
Maybe you can use Jeremy Zawodny's MyBench?
http://jeremy.zawodny.com/mysql/mybench/
It requires a bit of programming skills to get your logic in the Perl script
(plus DBI, DBD::mysql and Time::HiRes
You can use the mysqlshow command to list all disabled keys:
e.g.:
mysqlshow -k world foo
When the indexes are displayed the word disabled will be in the comment
field
--
Partha Dutta, Senior Consultant
MySQL Inc, NY, USA, www.mysql.com
Are you MySQL certified?
I'm going to start the InnoDB engine... and I want to know if the syntax for
the CNF file unified at last ?
Can I use:
innodb-file-per-table
instead of
innodb_file_per_table ?
[This is just an example]
Can I use only minus sign in the whole CNF file instead of underline ?
Gabriel
--
Hi! thanks for your response.
This are the values of the variables you asked for:
collation_connection: utf8_general_ci
collation_database: utf8_general_ci
collation_server: utf8_general_ci
character_set_client: utf8
character_set_connection: utf8
character_set_database: utf8
shaun thornburgh [EMAIL PROTECTED] wrote on 05/04/2005
06:54:23 AM:
Hi,
I have four tables among others in my database: Bookings, Work_Types,
Practices Projects. Bookings occur in a Practice for a Project and
have a
Work_Type. A Practice can have many Bookings but must have one and
Hi Jay,
Thanks for your reply, I tried your query but it jus hang :(
Here is some sample data:
mysql SELECT * FROM Bookings WHERE Practice_ID = 11049;
I am not sure about max - but I am running mysql.exe (I think it is the same
as mysqld-nt).
No - when I do a select * from on a table in the moved database - I get the
error that the table does not exist.
well - how can i tell if i have disabled symlinks???
I have not checked using 4.1.11.
Hi,
Thanks for the reply. Are u suggesting that I shutdown MySQL? I thought that a
FLUSH table command would take care of things.
Stupid me!
gerald_clark [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
Hi,
We're in the process of benchmarking/evaluating MySQL(4.1.9) on Linux for
our
hi ,guys.
i tried to start mysqld it reports below ,can someone give me some advices?
050504 09:43:33 mysqld started
050504 9:43:33 [ERROR] Can't create interrupt-thread (error 11, errno: 0)
050504 09:43:33 mysqld ended
Jack
[EMAIL
Hello All
I am about to set up ODBC for MySQL (iODBC) on our UNIX systems. We have many
machines that will need to use this installation. I would like to leverage a
NFS mount that is available to all the machines. We currently leverage the NFS
mount for a MySQL Client.
I am wondering if
Actually - I have some more details to make this clearer:
We will be using UnixODBC - already installed on a NFS mount, and the MySQL
drivers. So, could we install the MySQL drivers on the NFS Mount?
Thanks again - Gabe
-Original Message-
From: [EMAIL PROTECTED]
Sent: Wednesday, May
I have been using ACCESS to do simpe data editing on our MySQL tables for 3
years.
I recently installed 5.0.4 on my machine to evaluate it. I linked the tables
into ACCESS through my old ODBC driver and got
ODBC-update on a linked table 'product_order_choice' failed
[Microsoft][ODBC
Oliver Hirschi [EMAIL PROTECTED] schrieb im Newsbeitrag
news:[EMAIL PROTECTED]
Hi
I updated mySQL 4.0.8 to 4.1.1 and I have now problems with foreign
key
retrictions.
Is it right, that mySQL 4.1.x has something changed due to the foreign
key restriction?
Is there an option to turn off the
You can turn off foreign key restrictions within your session:
SET SESSION foreign_key_checks = 0;
Then later, turn them back on using
SET SESSION foreign_key_checks = 1;
--
Partha Dutta, Senior Consultant
MySQL Inc, NY, USA, www.mysql.com
Are you MySQL certified?
Hello all,
I have a problem on a development machine that somehow got every single
mysql program in the /usr/bin directory wiped out (which looks like it
was everthing but mysqld).
The server is actually up and running, and the datadir is intact, so it
looks like my data is okay. However, I
kristen...
the issues that i saw/reolved (at least for now) have to do with how mysql
sets things up for replication, which has to do with granting the correct
privs/rights...
i did the following:
1) create the database (foo)
2) grant all privs to user for foo on host
3) grant replication
Hassan Schroeder wrote:
Mark Sargent wrote:
h, that is annoying, as I did a yum remove mysql b4 installing
4.1. Shouldn't the yum remove, remove it fully..?
Sorry, can't help there, don't know anything about 'yum'.
[EMAIL PROTECTED] ~]# mysql -p
Enter password:
Welcome to the MySQL monitor.
Dear all at mysql list
I'dd like to know if it is possible (and the right sintax) to execute a nested
(2 or more levels) select... something like this.
select * from products
where productId IN
(
select idNumber
from other_table
);
This has the same result than a JOIN. I've done
It's possible starting with mysql 4.1
-Eric
[EMAIL PROTECTED] wrote:
Dear all at mysql list
I'dd like to know if it is possible (and the right sintax) to execute a nested
(2 or more levels) select... something like this.
select * from products
where productId IN
(
select idNumber
from
Mark Sargent wrote:
ok, I don't fully understand why, but, mysql is still installed in
/usr/bin. What I've done, just for now, is renamed mysql in that dir to
mysqlold. I've added /usr/local/mysql/bin to my path. I then tried the
cmd mysql and also ./mysql from within the dir
Is there a link that someone can suggest which details out how to move
databases from one location to another in mysql?
Thanks in advance.
Anoop
On 5/4/05, Anoop kumar V [EMAIL PROTECTED] wrote:
I am not sure about max - but I am running mysql.exe (I think it is the
same as mysqld-nt).
Yes, indexes slow down inserts (or updates that change the value of a
column that is indexed).
Also, remember that MySQL only uses one index per per table in a query.
So if there are some columns in your table that are indexed, but,
1) Have poor cardinality (number of distinct values - low
Hello all at mysql,
Are there tools available to automatically generate database (tables) creation
code starting from some grafical description of data... maybe it's a crazy idea
but I think it makes sense...
maybe: ER Diagrams to SQL
or:Object Diagrams to SQL
anything based on some kind
I have some data where the date is already in USA format (MM-DD-).
I would like to be able to insert this data without having to massage
the date in the code.
Is there a way to specify the Date Format for an INSERT statement?
Something like:
INSERT INTO tblMyTable(myDate)
In the last episode (May 04), Michael J. Pawlowsky said:
I have some data where the date is already in USA format
(MM-DD-). I would like to be able to insert this data without
having to massage the date in the code.
MySQL seems to think that USA format is MM.DD., which I've never
seen
Thanks! Explain and InnoDB monitor were exactly what I needed to
diagnose and fix the problem! In case you were curious, the issue was
that the statement I was expecting to run was not the statement that
was running, but the first hundred and some-odd characters in both
were the same. Using the
Dan Nelson wrote:
Is there a way to specify the Date Format for an INSERT statement?
Something like:
INSERT INTO tblMyTable(myDate) VALUES(DATE_FORMAT('USA', '12-31-2004');
Try the STR_TO_DATE function:
SELECT STR_TO_DATE('12-31-2004','%m-%d-%Y');
2004-12-31
Yup.. that works...
Gordon wrote:
I have been using ACCESS to do simpe data editing on our MySQL tables for 3
years.
I recently installed 5.0.4 on my machine to evaluate it. I linked the tables
into ACCESS through my old ODBC driver and got
ODBC-update on a linked table 'product_order_choice' failed
[EMAIL PROTECTED] wrote:
Hello all at mysql,
Are there tools available to automatically generate database (tables) creation
code starting from some grafical description of data... maybe it's a crazy idea
but I think it makes sense...
maybe: ER Diagrams to SQL
or:Object Diagrams to SQL
I'm getting lots of duplicate rows even though I have a
unique index defined over multiple columns.
The issue is that multiple NULL values are allowed,
even when some values are not null.
This could be as specified by the SQL standard,
but it's certainly confusing for the developer.
(By the way,
I think you should review the very recent thread why NOT NULL in
PRIMARY key?? which might shed some light on your particular issue.
In a nutshell, NULL!=NULL, so the database engine can not detect the
duplicate rows, as is expected.
-Hank
On 5/4/05, Dennis Fogg [EMAIL PROTECTED] wrote:
I'm
I have a unique key on username and email address in mysql. In my
application logic, I want to test for that response on failed insert. Error
number 1062 tells me there is a duplicate key, but no way to tell what key
that is.
The error string returned is more telling, but seems less than ideal
At 19:09 -0700 5/4/05, Scott Haneda wrote:
I have a unique key on username and email address in mysql. In my
application logic, I want to test for that response on failed insert. Error
number 1062 tells me there is a duplicate key, but no way to tell what key
that is.
The error string returned
on 5/4/05 7:22 PM, Paul DuBois at [EMAIL PROTECTED] wrote:
At 19:09 -0700 5/4/05, Scott Haneda wrote:
I have a unique key on username and email address in mysql. In my
application logic, I want to test for that response on failed insert. Error
number 1062 tells me there is a duplicate key,
When I installed MySQL-server version 5.0.4 on my Fedora Core 3 system
(Linux x86, using RPMs from MySQL.com) with SELinux running in enforcing
mode, the server failed to start, possibly due to denials from the
SELinux implementation.
'restorecon -R -v /var/lib/mysql' failed to let the server
Hassan Schroeder wrote:
Mark Sargent wrote:
ok, I don't fully understand why, but, mysql is still installed in
/usr/bin. What I've done, just for now, is renamed mysql in that dir
to mysqlold. I've added /usr/local/mysql/bin to my path. I then tried
the cmd mysql and also ./mysql from within
I am have trouble connecting to the MySQL server 4.1 using the API,
though I have no trouble connecting using the same parameters from the
command line mysql.exe.
I'm using server version 4.1.10 on Windows Server 2003, which was
started with --old-password (to ensure back compatibility with
48 matches
Mail list logo