Re: Table caching

In the last episode (Jun 22), Peter Hicks said: > I have a relatively simple table of 200+ network devices and 60+ > sites. This is accessed about 30 times a minute by various perl > scripts to pick up device/site information. > > Will I see any noticable benefit from creating a cached copy of th

Re: Indexing not working

Thank you Clark for your time > Try using straight joins to force MySQL to join from qb_test_result first. > The order chosen by the optimizer has no use for keys from this table. I tried to force indexes.. but it didn't help Thank you -- MySQL General Mailing List For list archives: http://lists.

Re: Indexing not working

Thank you Mathias once again > I suggest you to test after optimize table ... and analyze table ... > if you stay with the problem and you can give me a set of data, i'll try to > help > more. Initially while posting... i tried to reduce one table to avoid complexity from the actual query. I'm

Table caching

Hello I have a relatively simple table of 200+ network devices and 60+ sites. This is accessed about 30 times a minute by various perl scripts to pick up device/site information. Will I see any noticable benefit from creating a cached copy of this table as a MEMORY table? The data doesn't

Re: How to SELECT something (CONCAT) and search the field

While the query "WHERE expr LIKE '%$user%'" works without fail, it can not use an index, and thus on large tables will be exceedingly slow. mysql> explain select last, first from users where concat(last,first) like '%user%'\G *** 1. row ***

could a Trigger execute a outside command?

Hi, I am using MySql on Mac OS X. I am wondering if I could execute a command (shell, perl) by a Trigger. I read the manual and it seems this is impossible. ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PRO

Re: How to SELECT something (CONCAT) and search the field

I do this all the time and it works flawlessly. Just like your example and even more extreme. I use this technique to provide search mechamisms for my applications. ex, SELECT ID FROM table WHERE concat(field1, field2, field3,...{all the fields in the table}) Like '%searchstring%'; This w

compiling + making source for 5.7 on alpha

Can anyone advise please, tried binary installation but other users have reported encountering similar problems so I thought I'd try a source installation. Adjusted the "pentiumpro" flags out and configure reported no errors -when I use "make" I get "*** no targets. stop." The makefile is in ther

Re: replication general question

Hello. I haven't heard about periodical MySQL jobs, but Unix boxes usually have some midnight cron jobs (updating of locate database for example). [EMAIL PROTECTED] wrote: > > I have two mysql boxes setup. Fast machines, I think they are dual 3ghz with > boat loads of ram. They are

Re: connection error from c application

Hello. I've compiled your code using libraries and includes from MySQL-4.1.6 (yes, my testing environment isn'tperfect :) and successfully connected to MySQL-4.1.10. Old passwords was off, so I used a 4.1. authorization protocol. Elizabeth Bonifacio <[EMAIL PROTECTED]> wrote: > Dear All

Re: Extended insert syntax and replication

see this for troubleshootings : http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/Replication_Problems.html hope that helps Mathias Selon Jeremiah Gowdy <[EMAIL PROTECTED]>: > The inserts succeed on the master, so the problem isn't my SQL syntax. They > are legal extended inserts. It's

Re: Extended insert syntax and replication

The inserts succeed on the master, so the problem isn't my SQL syntax. They are legal extended inserts. It's just that the replication slave seems to insert them out of order and screw up the auto-increment primary key. - Original Message - From: <[EMAIL PROTECTED]> To: "Jeremiah Go

Re: Extended insert syntax and replication

Hi, this is a perl script converter for inserts to simple form. if you work from a mysqldump, you can try it to see if the converted inserts do not genrate errors : http://platon.sk/cvs/cvs.php/scripts/perl/mysql/mysqldump-convert.pl Mathias Selon Jeremiah Gowdy <[EMAIL PROTECTED]>: > I have two

Thanks for the help

Thanks for the help, I'll give some of these examples a try~!!! Thanks, Matt Babineau Criticalcode 858.733.0160 [EMAIL PROTECTED] http://www.criticalcode.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTEC

Extended insert syntax and replication

I have two servers doing replication for logs. When I do extended insert syntax on the master to combine multiple log entries, the slave complains about duplicate primary key numbers, even though my inserts don't set the primary key and the primary key is auto_increment. So any time I use ext

RE: How to SELECT something (CONCAT) and search the field

yes in therory. But practicaly, you always have business rules and data knowledge without what you can do nothing. so the substring must be constructed according to data. Mathias Selon Ben Kutsch <[EMAIL PROTECTED]>: > the substring will only work as long as you don't have spaces in the first >

Character Sets in 3.23.58

Hello, We are running mySQL 3.23.58 on a RedHat server. We have a database that needs to store Chinese (big5) and Vietnamese (Unicode-8 should work)how do I get it to store alternative character sets? The docs online only relate to ver 4so the "character set" attribute doesn't work.

RE: How to SELECT something (CONCAT) and search the field

the substring will only work as long as you don't have spaces in the first and last name columns 'Billy Ray' Smith and John 'Von Hoenhiem' would cause problems -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 4:05 PM To: Matt Babineau Cc: m

Re: replication general question

I don't think network latency would be an issue. This is within a protected network dmz so it has it's own switch. Here is the nagios script stuff. Might be more than what you need but let me know if you are able to use some of it. I have two on the server. first, I have: [EMAIL PROTECTED]

Re: How to SELECT something (CONCAT) and search the field

sorry for the first select (bad copy of a string 'lastname'): mysql> select concat(firstname,' ',lastname) from names where concat(firstname,' ',lastname) like 'Jean Dupond%'; ++ | concat(firstname,' ',lastname) | ++ | Jean Dupond

Re: How to SELECT something (CONCAT) and search the field

Hi, what's your version ? in 4.11 the two forms work : mysql> select concat(firstname,' ','lastname') from names; +--+ | concat(firstname,' ','lastname') | +--+ | Jean lastname| +--+

Re: How to SELECT something (CONCAT) and search the field

select first_name, lastname from user where first_name like '%$user%' or last_name like '%$user%' ; --- Matt Babineau <[EMAIL PROTECTED]> wrote: > Hey All- > > Got a fun question - I hit the manual but not much > luck on my question. I > want to combine 2 fields and then search them > > SE

MAC OS X backup after crash

Hi everyone, I just subscribed to the list and some of the articles are very helpful. I'm facing some problem on my mysql database server. One of our Raid drives crashed and we had to backup the whole data to another drive (only files), we did no mysqldump. Now I want to restore a certain databas

How to SELECT something (CONCAT) and search the field

Hey All- Got a fun question - I hit the manual but not much luck on my question. I want to combine 2 fields and then search them SELECT first_name, lastname FROM user WHERE CONCAT(first_name, ' ', last_name) LIKE '%$user%' Does this make sense? The CONCAT function was the closest I found to

Re: MySQL Server Parameter (v. 4.0.20-pc-linux-i686)

Yes they are very high, also key_buffer_size is a global parameter shared by all threads, it is recommended to be around 25% of your RAM, I would suggest since you have 2GB ram the following key_buffer_size = 500M ( greatly improves speed ) > sort_buffer_size= 2M > read_buffer_size=2M > write_buffe

Re: replication general question

What type of drives to you have on your system? That is often more important than CPU speed. My guess is that there are nightly maintenance crons slowing down disk access. I have never monitored replication via the seconds-behind-master function as we do not use 4.1, so I can't speak for how accur

Re: Indexing not working

Selon Michael Stassen <[EMAIL PROTECTED]>: > The PK is not used, nor should it be. Look at the EXPLAIN output. Hi, i hate the confusion people do between the primary key and the automatic index on the PK. Primary key is a generic concept for all databases. It assumes unicity and managed data ins

re: how to add comments to an existing table

James Black <[EMAIL PROTECTED]> wrote on 06/23/2005 03:41:32 PM: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > How would I add a comment to rows in an existing table, if I am not > changing the row definition? > This is for mysql 4.1 and 5.0. > Thanx. > - -- > "Love is mutual self-giving

re: how to add comments to an existing table

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 How would I add a comment to rows in an existing table, if I am not changing the row definition? This is for mysql 4.1 and 5.0. Thanx. - -- "Love is mutual self-giving that ends in self-recovery." Fulton Sheen James Black[EMAIL PROTECTED] -B

Re: MySQL Server Parameter (v. 4.0.20-pc-linux-i686)

Since I can't get the book until this evening ... In most sample my.cnf files online I see the following setup: [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer=16M write_buffer = 16M If these are per thread -- aren't they a bit high? thanks. erin --- Kishore Jalleda <[EMAIL PROTECTED

Re: MySQL Server Parameter (v. 4.0.20-pc-linux-i686)

Yes you are right, these are Thread specific settings, leave them at 1M or 2M, atleast that's what I set on our productions systems, else you risk at running out of memory under high loads, and it works great, the other parameters as cited in the book High performance Mysql , by Jeremy Zawodny says

MySQL Server Parameter (v. 4.0.20-pc-linux-i686)

I'm working on fine tuning the Server Parameters for a machine (with 2 GB of RAM). The database has a fair number of tables. Many of them are full of blobs. The version of our production MySQL is: 4.0.20-pc-linux-i686. In trying to decide on some of the buffer variables I've seen some very despar

Re: connection error from c application

I guess this is a problem with the version of the C client Libraries that you are using, because of the way 4.1.x version of mysql stores the hash value of the password using the PASSWORD( ) function, so when you are giving the password embedded in the C code, may be the server does not match it wi

Re: Indexing not working

[EMAIL PROTECTED] wrote: Hi, have you created an index on (id, testId) ? i can't see the other indexes ? The only ones are the PK and testStudent, so the PK is used. The PK is not used, nor should it be. Look at the EXPLAIN output. Let me rewrite the query with explicit joins, and reformat i

Re: mysqlshow question

Berman, Mikhail wrote: Hi Danny, Thank you for helping me here. Yes, I am aware of need to have the space between --host=xxx and --user=xxx, and command I am executing actually has a space. It looks like you believe that my problems related to security of remote logon. That is something, I am

Re: mysql_init

yes it is im still getting the mysql_init error... what is this usually indicataive of?? a build issue?? PATHs?? config file?? Im using the standard 'came with distribution' MySQL from SLAMD 10.1... I've got no idea what is this distribution (Mandrake Linux for AMD 64?) what is strange is th

Re: Increasing max_connections and table_cache on Solaris 8

Hello. I don't have enough experience with Solaris.. But on most Unixes your could change the limit of file descriptors for process, not for whole system. See: http://dev.mysql.com/doc/mysql/en/not-enough-file-handles.html "Martijn van den Burg" <[EMAIL PROTECTED]> wrote: > Hi,

Re: limit the number of startup process

Hello. I don't know such an option. However, in my opinion, max_connections variable could be helpful. See: http://dev.mysql.com/doc/mysql/en/server-system-variables.html [EMAIL PROTECTED] wrote: > Hi > > i like to imit te number of process at startup: > "/usr/sbin/mysqld --based

replication general question

I have two mysql boxes setup. Fast machines, I think they are dual 3ghz with boat loads of ram. They are not real busy servers but they have some pretty good sized tables, one of them with a few million rows. My question is, I have Nagios setup to monitor the seconds behind master on the bac

Re: selecting more sum()

Octavian, You seem to be missing an articles column linking it to newspapers. Supposing an id_newspapers column in articles, your query would be something like SELECT articles.title, CHAR_LENGTH(body) AS Length, newspapers.name AS Newspaper, COUNT(visitors.id) AS Visits, COUNT(comments.i

Re: Indexing not working

Sajith A wrote: EXPLAIN SELECT qb_test_result.id resultId, qb_question.testId AS testId, qb_test.title testName, qb_question.marks, qb_test.passrate, qb_test_result.marks testMark, qb_test_result.percentage testPercentage, qb_test_result.startTime, qb_test_result.endTime, qb_test_result.status

RE: mysqlshow question

Hi Danny, Thank you for helping me here. Yes, I am aware of need to have the space between --host=xxx and --user=xxx, and command I am executing actually has a space. It looks like you believe that my problems related to security of remote logon. That is something, I am going to investigate more

Re: mysql_init

Philippe Poelvoorde wrote: i've googled and the only answer to problems like this has been to reinstall the DB perl module. Ive tried this but still get same error. any clues??? thanks in advance. Ronan Is libmysqlclient.so available in one of your LD_LIBRARY_PATH directory ? thanks f

Re: mysql_init

i've googled and the only answer to problems like this has been to reinstall the DB perl module. Ive tried this but still get same error. any clues??? thanks in advance. Ronan Is libmysqlclient.so available in one of your LD_LIBRARY_PATH directory ? -- Philippe Poelvoorde COS Trading Lt

Re: Indexing not working

Hi Sajith, I tried to recreate you tables and do some tests, but i don't have significant data. So i don't take your explain plan. I suggest you to test after optimize table ... and analyze table ... if you stay with the problem and you can give me a set of data, i'll try to help more. Mathias S

Re: Indexing not working

Thank you Mathias for your time... > have you created an index on (id, testId) ? > i can't see the other indexes ? The only ones are the PK and testStudent, so > the > PK is used. Yes i also tried that .. but it was not getting used.. it listed as the possible_keys "PRIMARY" and "testStudent" but

Re: mysql and limitations and hardware features support

From: "d2clon" > im very interested about the limitations and hardware features support. > for example: > > software limitation: > how much rows does a table can to have? > how much size of a database does mysql support? These depend on the version of MySQL and the OS The number of rows is virtual

mysql_init

Trying to run exilog as part of the EXIM mta but getting a mysql error both when i run from command line and as part of apache CL /usr/lib/perl5/site_perl/5.8.5/x86_64-linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_init apache error log /usr/bin/perl: symbol lookup error: /usr/lib/

Re: Indexing not working

Hi, have you created an index on (id, testId) ? i can't see the other indexes ? The only ones are the PK and testStudent, so the PK is used. Mathias Selon Sajith A <[EMAIL PROTECTED]>: > I was trying to analyze a query that was taking almost 4 seconds to > execute. While trying to create additio

mysql and limitations and hardware features support

hello people: im very interested about the limitations and hardware features support. for example: software limitation: how much rows does a table can to have? how much size of a database does mysql support? ... hardware features support: has mysql multi-processor support? how much processors?

Indexing not working

I was trying to analyze a query that was taking almost 4 seconds to execute. While trying to create additional indexes - found that the query is not using any index from table qb_test_result . The type returned is ALL for qb_test_result . I have given the tables and query below. It would have bee

load balancer and cluster

(sorry for my english) hello people: i want to answer if do exists any mysql solution that implements load balancer and redundancy between 'application layer' and 'mysqld layer' i will try to explain me: i want to implement a completed mysql cluster system, and the documentation is very goo

connection error from c application

Dear All, I'm new into mysql and has been encountering huge problem in connecting to the database from the c application. The code execute with an error message : Failed to connect to database: Error: Client does not support authentication protocol requested by server; consider upgrading MySQL cli

limit the number of startup process

Hi i like to imit te number of process at startup: "/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/" but i couldn t find the option thx all -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

limit the number of startup process

Hi i like to imit te number of process at startup: "/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/" but i couldn t find the option thx all -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]