i follow instruction from the http://www.linuxhelp.net/guides/lamp/ to
install mysql
i followed the steps
but i get this error when i reach the testing phase..
can anyone help me.. i have trouble setting up the mysql server for almost 4
days.. every time of some error .. maybe this because i am
Hi,
Have you done a $ ps aux | grep mysql and checked the daemon is running?
It sounds as if it hasn't started. If not, then you need to check the
mysql log. It is probably in /var/log/mysqld.log or somewhere similar.
You can look up the errors at
http://dev.mysql.com/doc/mysql/en/index.html This
On Sat, 7 May 2005 09:35:21 +0100, wrote:
One issue you have to consider is how the data is entered. If the user
selects from a drop down list then this is ok but you need to plan how the
drop down list is compiled. If not then you need to thinks about spelling
errors, language issues etc.
Hi!
We are storing UTF-8 data in out mysql database and we need to get the length
of the data. But length() doesn't return the number of characters but the
pure number of bytes.
SELECT LENGTH('köter') = 6
Currently we are doing something like that:
SELECT LENGTH(CONVERT('köter' USING
Am Montag, 9. Mai 2005 11.55 schrieb Andreas Steichardt:
Hi!
We are storing UTF-8 data in out mysql database and we need to get the
length of the data. But length() doesn't return the number of characters
but the pure number of bytes.
SELECT LENGTH('köter') = 6
Currently we are doing
Hi all,
let's figure we have one big database table ~1mln rows.
I can easly to collect needed data from this table with query:
SELECT id,title,cdate FROM bigtable WHERE active ORDER BY cdate ASC,
id ASC LIMIT 300,100
So i get needed rows to display.
i can make easly with page numbers to
On 5/9/05, Andreas Steichardt wrote:
We are storing UTF-8 data in out mysql database and we need to get the
length
of the data. But length() doesn't return the number of characters but the
pure number of bytes.
Look at OCTET_LENGTH() and CHAR_LENGTH(). (While OCTET_LENGTH() is a
synonym,
://www.upscene.com
Features and fixes: http://www.upscene.com/news/20050509.htm
Database Workbench supports:
- Borland InterBase ( v4.x - v7.x )
- Firebird ( v1.x )
- MS SQL Server/MSDE ( v6.5, 7, 2000, MSDE 1 2 )
- MySQL 4, 4.1
- Oracle Database ( 8i, 9i, 10g )
If you experience any problems with this new
Dear friends,
how do you extract with a query only the first few lines from a blob field?
For instance: you have an article stored in the field. You would like to
visualise the first few lines before reading it all.
Thanks in advance.
--
symbulos - ethical services for your organisation
We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail.
key_buffer_size=536870912
read_buffer_size=2093056
max_used_connections=418
max_connections=2048
threads_connected=404
On Monday 09 May 2005 12:24, John Doe wrote:
Am Montag, 9. Mai 2005 11.55 schrieb Andreas Steichardt:
Hi!
We are storing UTF-8 data in out mysql database and we need to get the
length of the data. But length() doesn't return the number of characters
but the pure number of bytes.
Vaidas Zilionis wrote:
[...]
Example items are displayed 100 in page, and i display 20 pages
numbers
1 ... 4[5] 6 x
doomain.con/items.php?page=5
and i get all result here with limit 400,100
Yes, with PHP it would be something like this:
$items_per_page = 100;
$limit_clause =
Hello Roger,
Monday, May 9, 2005, 2:56:18 PM, you wrote:
Heh if i know page i would haven't problem.
but i need to get also correct page with link
doomain.con/items.php?showid=45
it can be anywhere! :)
I making web application with data binding (IE stuff) data is loading
very fast, can be
Hello Vaidas,
Monday, May 9, 2005, 3:08:26 PM, you wrote:
hm founded something intresting :)
set @mynr:=0;
Select @mynr as nr,table.id from table
where @a:=IF((table.id=0),0,(@a+1)) having table.id=518 order by id
strange IF hack :)
main problem what this metod not fast. tested in table with
How do I limit subqueries to 3 selects for each query selected, for
example, an operator put in 5 orders in each batch, and there are 2
different reports which is accuracy for all orders and 3 out of each 5
orders processed.
QA table holds batch information and Batch table holds all order
Have you checked if in the /etc/mysql/my.cnf the directive allow
networking is uncommented?.
This is a quite usual mistake.
Also check the host permissions of the root user.
Hope this helps.
Alvaro.
- Original Message -
From: Mark Sargent [EMAIL PROTECTED]
To: mysql@lists.mysql.com
news [EMAIL PROTECTED] wrote on 05/06/2005 06:08:18 PM:
hi,
When designing data it is common to have lookup tables such
animal_type : dog=1, cat=2,bird=3 etc
And then in other tables to refer to animals by their number 1, 2
or 3. This is memory and
presumably speed efficient. Howver
symbulos wrote:
how do you extract with a query only the first few lines from a blob field?
For instance: you have an article stored in the field. You would like to
visualise the first few lines before reading it all.
You could use the LEFT() function to return for instance the 200 first
Joerg Bruehe said:
Still, this seems to be a problem with the header files supplied / used
by gcc. Are you sure you used the fixincludes script?
Hi Joerg,
I tried your suggestion as per:
cd /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.1.0.0/3.3.2/
mv include inc
cd install-tools
export
On Monday 09 May 2005 15:17, Roger Baklund wrote:
You could use the LEFT() function to return for instance the 200 first
characters:
SELECT LEFT(article,200) AS start_of_article
FROM articletable WHERE ...
You could also use the SUBSTRING_INDEX() function, if your lines are
separated
You could use the LEFT() function to return for instance the 200 first
characters:
SELECT LEFT(article,200) AS start_of_article
FROM articletable WHERE ...
You could also use the SUBSTRING_INDEX() function, if your lines are
separated with \r\n:
SELECT SUBSTRING_INDEX(article,'\r\n',2) AS
Christian Meisinger wrote:
You could use the LEFT() function to return for instance the 200 first
characters:
SELECT LEFT(article,200) AS start_of_article
FROM articletable WHERE ...
You could also use the SUBSTRING_INDEX() function, if your lines are
separated with \r\n:
SELECT
I recently installed SUSE 9.1 64bit with MySQL 4.0.18 on a new server and have
been getting the following errors:
050509 10:53:14 Error reading packet from server: bogus data in log event
(server_errno=1236)
050509 10:53:14 Got fatal error 1236: 'bogus data in log event' from master
when
So... it sounds like a lot of people here (Dathan and Greg) have had
problems deploying MySQL on Opteron in a production environment.
I was wondering if we could start an Opteron HOWTO somewhere (mysql
wiki?) which could illustrate the minefields they've had to walk to
hopefully solidify
Try upgrading to the newest 4.0 release of mysql. 4.0 up until about .19
or .20 had odd replication problems.
Scott M. Grim wrote:
I recently installed SUSE 9.1 64bit with MySQL 4.0.18 on a new server and have
been getting the following errors:
050509 10:53:14 Error reading packet from server:
I am all in favor of this idea. Currently, this info is scattered all
over the web, and finding it can be time consuming (even w/ Google). I
see lots of people jumping the same hurdles, so a central location for
this info seems it would greatly benefit the community.
Greg
Kevin Burton wrote:
Thanks for the very useful suggestions!
I was thinking of adding a simple check to search for the first full stop
after the count of words.
It sounded sensible in the case where people want to have a full sententences,
not interrupted in the middle.
--
MySQL General Mailing List
For list
Greg Whalin wrote:
I am all in favor of this idea. Currently, this info is scattered all
over the web, and finding it can be time consuming (even w/ Google).
I see lots of people jumping the same hurdles, so a central location
for this info seems it would greatly benefit the community.
Greg Whalin wrote:
I suspect this is an OS issue. Our Opteron's were completing large
data update queries aprox 2-3 times slower than our Xeons when running
under 2.6. After a switch to 2.4, Opteron's are faster than the
Xeons. I mentioned NPTL being shut off (LD_ASSUME_KERNEL=2.4.19 in
Kevin Burton wrote:
Greg Whalin wrote:
I suspect this is an OS issue. Our Opteron's were completing large
data update queries aprox 2-3 times slower than our Xeons when running
under 2.6. After a switch to 2.4, Opteron's are faster than the
Xeons. I mentioned NPTL being shut off
Greg Whalin wrote:
We are currently running 2.3.2 (Fedora Core 1) on our Opterons. When
we were still running linux 2.6, we were on 2.3.3 (Fedora Core 2).
Yeah... we were being bitten by 2.3.2's NPTL implementation for MONTHs
before I heard a rumor that the Internet Archive moved to 2.3.4.
Its pretty filled now now. If you have anything to add please feel free.
http://hashmysql.org/index.php?title=Opteron_HOWTO
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi folks,
I need to get a version of MySQL running on AIX 5.1, but I see that the only
versions available are for v5.2 and v4.3.3. I tried both versions (32 and
64-bit) for 5.2 on my 5.1 box, but received this error when trying to
install:
[EMAIL PROTECTED] mysql] bin/resolveip
exec(): 0509-036
Kevin Burton wrote:
Greg Whalin wrote:
We are currently running 2.3.2 (Fedora Core 1) on our Opterons. When
we were still running linux 2.6, we were on 2.3.3 (Fedora Core 2).
Yeah... we were being bitten by 2.3.2's NPTL implementation for MONTHs
before I heard a rumor that the Internet Archive
Hi,
Is there a query which will alter a table to rename all the columns to
lowercase
eg Price to price, Quantity to quantity
--
zzapper
vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?
http://www.rayninfo.co.uk/tips/ vim, zsh success tips
--
MySQL General Mailing List
Greg Whalin wrote:
Curious, were you seeing deadlocks in Suns JVM w/ Tomcat?
Never with Tomcat but we might have a different number of threads. But
it *was* with Java...
We were forced to run Tomcat w/ NPTL off due to deadlocks under glibc
2.3.2+NPTL.
Yup.. thats the problem we had. But we
In article [EMAIL PROTECTED],
symbulos [EMAIL PROTECTED] writes:
On Monday 09 May 2005 15:17, Roger Baklund wrote:
You could use the LEFT() function to return for instance the 200 first
characters:
SELECT LEFT(article,200) AS start_of_article
FROM articletable WHERE ...
You could also
I'm implementing a tagging system in an online db app I've built. The idea
is that users of the system can tag other members and then do a search to
find all members who are tagged. To implement this I've created a table:
membertagset
Look into INSERT...SELECT, that will insert records based on a
selection only in one query.
http://dev.mysql.com/doc/mysql/en/insert-select.html
The other stuff is just regular queries. Are you stuck on how you
would write the query?
To add members from a group that are not already tagged by a
I just learned a lot stuff at
http://dev.mysql.com/doc/mysql/en/sorting-rows.html including sorting by
number-to-text, text-to-number, names, specific values, etc.
However, the document didn't mention on how to sort by relevance.
For instance, someone search for Ang:
COLUMN NAME: name
COLUMN
I don't think you are putting this question very well. You are not really
asking about sorting, which is accomplished (primarily) via the ORDER BY
clause; you are really asking about searching for rows that meet a certain
criteria, which is accomplished (primarily) via the WHERE clause.
If you
It seems strange that long_query_time is seconds based. I'm trying to
get most of our queries down to sub second time.
1 second is WAY too long. I'd ideally like 500ms.
Can you specify .5 for long_query_time? Doesn't seem to be working the
way I'd hoped...
Kevin
--
Use Rojo (RSS/Atom
You're probably looking for a full-text index. See the
online documentation:
http://dev.mysql.com/doc/mysql/en/fulltext-search.html
There are many, many gotchas to full-text searching (stop
words, a 50% threshold, et cetera) that can cause unexpected
results, so be sure to read every single word.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kevin Burton wrote:
It seems strange that long_query_time is seconds based. I'm trying to
get most of our queries down to sub second time.
1 second is WAY too long. I'd ideally like 500ms.
Can you specify .5 for long_query_time? Doesn't
Mark Matthews wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kevin Burton wrote:
It seems strange that long_query_time is seconds based. I'm trying to
get most of our queries down to sub second time.
1 second is WAY too long. I'd ideally like 500ms.
Can you specify .5 for
Rhino,
String comparisons are case insensitive in mysql by default.
mysql SELECT 'bang' LIKE '%ang%', 'Angel' LIKE '%ang%';
+-+--+
| 'bang' LIKE '%ang%' | 'Angel' LIKE '%ang%' |
+-+--+
| 1 |
I'm looking for a row numbering in a select statement. Something I can
use to determine in whivh row values are returned in a query.
I found this insanely old list post:
http://lists.mysql.com/mysql/337
That appears to be what I want, but an examination of the changelogs for
MySQL 3.23 didn't
Let me try this again, reworded for further clarity.
IF I use the following statement:
SELECT * FROM `items` WHERE `item` = 10902 HAVING `venturi_type`
= 'universal' OR `venturi_type` = 'special';
I get a complete and full data dump.
IF I change the statement by inserting a 'letter' in
Erik Bukakis wrote:
I just learned a lot stuff at
http://dev.mysql.com/doc/mysql/en/sorting-rows.html including sorting by
number-to-text, text-to-number, names, specific values, etc.
However, the document didn't mention on how to sort by relevance.
For instance, someone search for Ang:
COLUMN
-Original Message-
From: Richard Dale [mailto:[EMAIL PROTECTED]
Sent: Sunday, May 08, 2005 9:37 PM
To: mysql@lists.mysql.com
Subject: Dual Opteron, linux kernels, 64 bit, mysql 4.1, InnoDB
A new server is about to arrive here and will have have 8x15K
RPM spindles, dual
Here is the requested data dump from DESC items;
id int(10) PRI NULLauto_increment
itemvarchar(30)
brands text
categorytext
subcategory text
Selon Chris [EMAIL PROTECTED]:
I'm looking for a row numbering in a select statement. Something I can
use to determine in whivh row values are returned in a query.
I found this insanely old list post:
http://lists.mysql.com/mysql/337
That appears to be what I want, but an examination of
I use Redhat Advanced Server v4 (2.6 kernel) on my four dual opteron
systems. I've had no real performance issues with the I/O scheduler, but
that's because I run 8GB of ram with a huge key cache. I recommend taking
the box to 8GB of ram, it's worth it. Definately use RAID 10.
-
hi
i am using mysql-standard-4.1.11-pc-linux-gnu-i686.tar.gz
after extracting it .. i change dir into
mysql-standard-4.1.11-pc-linux-gnu-i686
then execute this command
./configure --prefix=/usr/local/mysql
it returns this
This is a MySQL binary distribution. It's ready to run, you don't
need to
Why not Raid 3 and take advantage of disk write and read performance.
Raid 3 isn't commonly used because it has CPU overhead. But at the same
time Apache causes CPU overhead waiting for the data from the drives.
I am buying this exact same server With 32 Gig of ram.
Frankly the slowest thing
I would go raid 10. This made a huge difference on one of my systems. You could
probably get fancier than that, but r10 works well. A different fs would likely
help. You said nothing about the layout of the db, but I'm sure you have that
under control.
P
-
Sent from my NYPL
ok i found the source file ..
tarball
mysql-4.1.11.tar.gz
after executing the ./configure command
i does some checking the it gives this error
checking for termcap functions library ... configure : error :no curses /
termcap library found
htmlDIV
DIVFONT color=#cc face=Lucida Handwriting,
On 10/05/2005 1:29 p.m., ganesan malairaja wrote:
./configure --prefix=/usr/local/mysql
it returns this
This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!
which Mysql distribution do i use .. to follow the instruction from
http://www.linuxhelp.net/guides/lamp/
Thank you Roger! :) This works well for me! ^_^
Thanks also to the other guys that I replied. :)
Ang sabi sa akin ni Roger Baklund noong 06:12 AM 5/10/2005...
This way and only four rows in the example is a bit vague, but maybe
something like this could work for you:
$crit = 'Ang'; # test case
Dear all,
I read the following on this page
http://dev.mysql.com/doc/mysql/en/server-system-variables.html:
bulk_insert_buffer_size
MyISAM uses a special tree-like cache to make bulk inserts faster for
INSERT ... SELECT, INSERT ... VALUES (...), (...), ..., and LOAD DATA
INFILE. This
now i am missing the file mysql.sock .. i could not find it anywhere on the
computer
i also could not find my.cnf ..
i created one my.cnf pointing it o /tem/mysql.sock
now i dont have the mysql.sock file
where to get it
--
MySQL General Mailing List
For list archives:
Apache doesn't cause CPU overhead waiting for the data from the drives, when
you do blocking I/O, the kernel removes your thread from the runnable queue,
making it impossible for you to use any CPU time.
Raid 10 has full disk read / write speed benefits, plus you get 1,
potentially 2 drives of
62 matches
Mail list logo