My.cnf Have Delete The Table

May 9, 2007

i have update my.cnf with the following configuration and now i have a lor of customer that have lost him table, seem that this configuration have delete in random .Myi files, i would put this my.cnf also on others server but i would undestand which setting in this .cnf make problem for the table.

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
#skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=96M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=200
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=384M ## 128MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=3M ## 1MB for every 1GB of RAM
read_buffer_size=3M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=3M ## 1MB for every 1GB of RAM
thread_concurrency=2 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
log_slow_queries=/var/log/mysql-slow-queries.log
long_query_time=2
collation-server=latin1_general_ci

[mysql.server]
user=mysql
#basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

View 3 Replies


ADVERTISEMENT

How To Run OPTIMIZE TABLE

Mar 25, 2009

Today i need to run "OPTIMIZE TABLE" from MySQLTuner recommendation.

Now i don't know how to run it ? I try to put in SQL Query via phpmyadmin and:

SQL query:

OPTIMIZE TABLE

MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

View 5 Replies View Related

Full BGP Table

Apr 19, 2007

Can i expect a 7204VXR NPE-300 router with 256Meg to hold a full BGP table?

Would it be possible to hold to full BGP tables (multihoming) with a NPE-400 with 512Meg?

View 9 Replies View Related

Attachment Table

Oct 21, 2007

I have a site running on vps and the attachment table got crashed , I am unable to repair it :

thesymbi_vb.attachment
error : Not enough memory for blob at 605100 (need 6315809)
warning : Number of rows changed from 4 to 3081
status : OK

This is result of repairing from WHM, how to repair it?

View 5 Replies View Related

Can't Initialize Iptables Table

Mar 12, 2008

On my new unmanaged VPS i keep getting mass emails sent to me saying -

iptables v1.2.11: can't initialize iptables table `filter': iptables who? (do you need to insmod?)
Perhaps iptables or your kernel needs to be upgraded.

Im a bit of a n00b when it comes to unmanaged servers, just wondering if anyone knows whats wrong and how to fix.

View 6 Replies View Related

Mysql: Copying To Tmp Table

May 18, 2009

mysql: Copying to tmp table, what causes that?

My server is majorly overloading and mysql is atop the cpu, and when I do a processlist there are about 20 copying to tmp table processes.

View 3 Replies View Related

Table Marked As Crashed.

Apr 5, 2009

I have a table that is showing

MySQL Error: 145 (Table './dollarpt_ptc/flinks' is marked as crashed and should be repaired)

I've repaired it via
mysqlcheck --repair --all-databases

that didn't work. I've tried
find /var/lib/mysql/* -name *MYI |xargs myisamchk -o -r
as well with no luck.

I then dropped the table and I still get the message. I know it's using the correct database, so any help would be appreciated.

It's like there is a table where this data is kept, but I've looked and can't find anything.

View 2 Replies View Related

MySQL Table Crashed

Sep 28, 2007

Table '231_message' is marked as crashed and should be repaired

I haven't ever had this happen, is all my data truely lost or can i 'repair' it

i was moving sites to a different server (VPS -> dedicated) and on the vps i have a max of 20gb storage, well as i was using the cpanel transfer it filled this up because it didnt have a warning about this (i dont accept blame )

either way it seemed at this time someone on my site tried to make an adjustment to the table and it crashed it since there wasnt room? i really need to get this fixed asap so I can properly move this site with a working database

View 5 Replies View Related

Import Just One Table From A Sql Backup

Nov 13, 2007

I have a sql backup and I just want to restore the attachment table from it! , can anyone explain me how to do so?

View 4 Replies View Related

Optimizing Large MySQL Table

Nov 2, 2009

I optimized a mysql table of 2 million records and about 500MB.. it took about 15 minutes.. However, on the same DB now i have another huge table of 88 million records, it size is 2.2 GB and it has about 30 MB to optimize... my questions..

1.- How can I speed up the optimization process so it can take the less possible time? any tweaks to my.cnf?

2.- Should I repair it using phpmyadmin or just from the shell?

3.- Should I stop http traffic during this optimization?

This is a dedicated db mysql server that handles a large VB forum with 5-8 users online average:

Code:
Intel Xeon 3.2 x4 procs, 32 bits, 4 GB ram
/etc/my.cnf

Code:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
skip-bdb
query_cache_limit=1M
query_cache_size=48M
query_cache_type=1
max_connections=1200
interactive_timeout=100
wait_timeout=300
connect_timeout=10
thread_cache_size=128
key_buffer=48M
join_buffer=8M
max_allowed_packet=16M
table_cache=2036
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=4
myisam_sort_buffer_size=64M

# Add
max_heap_table_size = 48M
tmp_table_size = 48M
low_priority_updates=1
concurrent_insert=2

[mysqldump]
quick
max_allowed_packet=16M

[mysql.server]
user=mysql
#basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log-slow-queries=/var/log/slow-queries.log

On the other side, i have the same hardware for the webserver..

View 2 Replies View Related

Deleted Columns_priv Table MySQL

Jun 24, 2009

I accidentally deleted the columns_priv table in mysql database. How can I bring it back can anyone show me the structure of that table so I can build it back.

View 4 Replies View Related

Mysql: Incorrect Key File For Table

Apr 20, 2009

I have a server with many db on mysql 5

Any db contains 5 table with data

This data is processed by routine

Many time routine die with the error:
"Incorrect key file for table '/var/tmp/#sql_3018_0.MYI'; try to repair it"

The table sql_3018_0.MYI not exist, think that this is refered to a temporary table but is deleted by process..

View 1 Replies View Related

Mysqldump :: JUST The Data, NO Table Information

Apr 14, 2008

From Linux Shell, I need to back up a mysql database, JUST the data, NO Table information. Which options in mysqldump do I use?

View 14 Replies View Related

MYSQL Incorrect Key File For Table

Jul 3, 2008

what I can do about the following database error in mysql?

Incorrect key file for table '/tmp/#sql_(number of table.MYI); try to repair it

I've repaired, optimized and checked the database in phpmyadmin. Initially 2 tables were showing overhead, but the error message is for a temp table and I'm not sure how to try to repair a temp table.

View 5 Replies View Related

How To Alter Tabel And Create Table In Mysql

Jun 24, 2009

I have a script and there are some modifications that I want to make

In the instructions it says ALTER TABLE and CREATE TABLE in myqsl but I dont know exactly how to do this.

I have tried to google but everything i find is very technical and doesnt explain the easiest way to do it.

Should I use phpmyadmin or whats the correct way?

View 5 Replies View Related

Disk Doesn't Contain A Valid Partition Table

Feb 2, 2008

I am unable to mount the 2nd disk's extended partition. Please help.

Commands I tried and returns....

Quote:

mount -t ext2 /dev/hdd2 /second
mount: wrong fs type, bad option, bad superblock on /dev/hdd2,
missing codepage or other error
In some cases useful info is found in syslog - try
dmesg | tail or so

Quote:

mount -t ext3 /dev/hdd2 /second
mount: wrong fs type, bad option, bad superblock on /dev/hdd2,
missing codepage or other error
In some cases useful info is found in syslog - try
dmesg | tail or so

Also I tried to add it to /etc/fstab but it says the same error, Disk /dev/hdd2 doesn't contain a valid partition table... I am able to mount /dev/hdd1 successfully.

View 7 Replies View Related

Internal Server Error - When Reading Table

Nov 28, 2008

In the forum [url]suddenly we got Internal Server Error. Our host claims it is because of corrupted database accorind the logs:
081128 11:44:38 [ERROR] Got error 126 when reading table './lykman_clubcento/lykman11_members'
Repairing the database from cpanel didnt work. Old available backups are not available.

View 12 Replies View Related

Ip_conntrack: Table Full, Dropping Packet

Mar 20, 2008

ip_conntrack: table full, dropping packet

What does that error mean? It's related to iptables right? When I do this cat /proc/sys/net/ipv4/ip_conntrack_max, I get

65536

I increased it

131072

Because someone recommended me this number because I have 4gb of RAM. But I still get the table full errors or

host kernel: printk: 500 messages suppressed

What should I do? Should I keep increasing the number? How do I know how much I can increase it by?

View 14 Replies View Related

Nf_conntrack: Table Full, Dropping Packet

Mar 30, 2007

I have 2 identical boxes with FC6 and the same settings and almost the same amount of traffic.

Kernel is 2.6.20-1.2925.fc6 SMP

One is running without problem. The other become slow after few days and from errors I get this message:

nf_conntrack: table full, dropping packet

The table do not clean up automatically as reboot solve the problem. How to flush nt_conntrack table without reboot?

The limit is 65536, setting it double seems to solve the problem but I'm not sure it is the way to go.

View 2 Replies View Related

Kernel: TCP: Time Wait Bucket Table Overflow With VePortal

Oct 5, 2009

Any one facing any issue when Running CPanel on the VPS.

I always seem to be getting these errors only for Cpanel VPS only.

kernel: TCP: time wait bucket table overflow

kernel: TCP: too many of orphaned sockets (90 in CT****)

Even Cpanel Install by SSH or VePortal gives the same error.

View 12 Replies View Related

Mysql Disable INSERT Access To Specific User/table

Apr 26, 2009

How can I disable INSERT access to specific table.

The user should have full access the the DB except insert to specific table.

The tables_priv allow to set what enable and not what disable.

I'm using mysql v5

View 4 Replies View Related

Plesk 12.x / Linux :: Unable To Find Row By Field Login With Value In Smb Users Table

Aug 25, 2014

On a couple of domains I get this error if I click on the domain in the domains option or in the Subscriptions list.

Unable to find row by field login with value domain.com in smb_users table.

How can I fix this?

View 1 Replies View Related

Plesk Automation :: Error SMTP 550 - User Unknown In Virtual Mailbox Table

Nov 7, 2014

I have a problem with my Parallels Plesk Panel (v 11.5.30) in CentOS 6.4.

When I try to send an email by RoundCube to an other email address with the same domain (that is hosted in my server) i get this error:

Error SMTP (550): ... "xxxxxx@mydomain.com" (5.1.1 <xxxxxx@mydomain.com>: Recipient address rejected: User unknown in virtual mailbox table)

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved